Junior Data Analyst

This role is open to our San Francisco and Minneapolis office locations.

About you

Other people see data, but you see the story it is trying to tell and paint the picture so everyone can understand. You know that assuming the answer to a problem, without looking at what data tells us, is foolish. You live to see metrics and dimensions that can be combined to tell a digital story. Working with dashboards, reports and analytics energizes and excites you.

You enjoy working autonomously while also being part of a team. As a details person, you can easily see errors and make sense of what needs to change to correct them. You take direction and feedback well and aren’t afraid to speak up when issues arise and provide suggestions for how to solve them.

If this sounds like you, keep reading…

About us

We are the pre-eminent global tech communications consultancy. We are a group of expert communicators who are fanatical about tech and are here to help businesses ignite their possibilities. Our local experience and global scale allow us to deliver bold but pragmatic comms guidance to tech companies all over the world.

When you work with us, we connect and support you in a way that allows you to achieve limitless success and career growth. For years now, we’ve been named a Best Place to Work by PR Week, PRNews and Crain’s New York.

We are connected, ambitious and curious, but most of all we are one team working together to be the global alternative.

We are looking for an exceptional person to join our team as a Junior Data Analyst.

Converting data to information through visualization is the core responsibility of the Junior Data Analyst. They are part of the North America Strategy + Planning team, with a dotted line to the Global Head of Data & Analytics who is based in the UK. The Junior Data Analyst works well with client teams to deliver insightful and accurate data visualizations. They are organized, thorough, and provide support on various data projects. The Junior Data Analyst is a team member who works collaboratively with the rest of the client service and digital team to deliver quick and effective solutions. They assist data and technology projects, support other business projects, programs, and initiatives, and know when to escalate or flag something up to leadership when the situation calls for it. The Junior Data Analyst is always staying on top of the latest data practices and testing new tools. They are pushing internal teams and clients to adopt new processes and technology when they see an opportunity. They will be comfortable liaising with clients and presenting within meetings and comfortable working within a remote environment and across time zones.

Activities include:

• Identifying internal and external data visualization and reporting needs, across multiple media tools, in collaboration with the Global Head of Data & Analytics, program teams, strategy + planning, and client services teams.
• Fulfilling data visualization and reporting needs across the business through the development of intuitive, engaging, insightful, and attractive dashboards and visualizations in Google Data Studio, or other data visualization tools. Kinds of visuals will vary between internal and external data.
• Preparing data visualizations, finding additional context, and summarizing key takeaways for presentations and reports.
• Cleaning and organizing large datasets and verifying and ensuring accuracy, integrity, and consistency of data.
• Understanding and driving thought leadership across the organization about the implications of data, and interpreting data in context, including identifying trends and outliers.
• Helping with the selection and roll-out of data visualization tools and dashboards.
• Responding to ad-hoc requests for internal business information and data visualizations.
• Assisting the client service and digital team with the development of reports and system configuration and testing.
• Performing other job-related duties as assigned by the North America Strategy + Planning team and the Global Head of Data & Analytics.
• Keeping abreast of best practices in the use of technology in data visualization and evaluation and participating in relevant professional organizations for professional development.
• Helping to drive the understanding and need to push data into insights for new business and client work.

What your week will look like:

• 30%: Liaising with clients to check in on ongoing projects, presenting new products or features, handling one-off requests, and troubleshooting existing projects
• 40%: Cleaning, analyzing, and managing data to upload into our dashboards; building new dashboards, developing new features in existing dashboards, working with data team to develop new product offerings; managing relational databases
• 25%: Working with strategy, planning, and account teams to troubleshoot data issues, expand organizational data management capabilities, and help out with small data-related projects; researching and develop tech stack
• 5%: Professional development through company and online trainings

Experience:

• Highly proficient user of data visualization platforms (Google Data Studio preferred)
• Growing familiarity and general comfortability with tools such as Quid, Cision, and Netbase
• Ability to critically think, analyze trends to inform insights, and make well-reasoned recommendations
• Advanced Excel/Google sheets knowledge (pivot tables, formulas)
• Fast learner with ability to adopt new data analytical processes
• Ability to convey complex or niche information in a simple and digestible format
• Ability to work in a team with people from a diverse range of backgrounds and levels data literacy
• Experience writing SQL joins/queries
• Experience cleaning large datasets
• Experience developing Boolean searches
• Familiarity and working with relational databases a plus

Why Us:

• Flexibility – We understand that life doesn’t always fit around the 9-5; and that work/life integration is crucial.
• Global Reach & Opportunity – You will have the opportunity to work within global teams and travel within the US and globally to connect with clients and colleagues.
• Great Benefits - Strong benefits package includes paid time off, holidays, sick leave, cultural celebration days off, paid time off for community involvement, medical, dental and vision insurance, disability and life insurance, 401K match and a paid 6-week sabbatical after every 4 years of continuous employment. Hotwire offers a variety of bonus opportunities to include business development, annual company bonuses and referral bonuses. Additional benefits include wellness allowance, internet, and phone reimbursement.
• Development Opportunities – A strong learning and development program with training opportunities at all levels.
• Autonomy – The freedom and support to be limitless, and the opportunity to own your career and create the future you want.
• Variety – No day is the same as the last. Both within our own walls, and with our clients, we navigate change daily and there’s always an opportunity to stretch your skills, learn something new, seek out a new challenge, and gain expertise. 
• Our Amazing Team – We are connected, ambitious, and friendly. We don’t step on toes to get ahead, we build each other up, develop and teach each other and understand that each person’s individual success is a win for all.

We engage in Thoughtful Working, empowering our talent to determine the best way to work for our clients, our team and Hotwire every single day.  

Compensation Range: $59K-$95K, depending on level of experience

The range listed is just one component of Hotwire’s total compensation package for employees, which includes bonus opportunities and a variety of benefits mentioned above. Hotwire takes into consideration a candidate’s education, training, and experience, as well as the position’s work location, expected work to be performed, required travel (if any), external market and internal value, and internal pay alignment when determining the salary level for potential new employees. A potential new employee’s salary history will not be used in compensation decisions