Senior Data Analyst

OneMagnify; Dearborn (MI); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Medical, dental, vision coverage

401(k) retirement plan

Paid holidays

Flexible Time Off

Job summary

OneMagnify is seeking a Senior Data Analyst to develop analytics deliverables, dashboards, and strategic insights across sales, marketing, and customer behavior. You will query large datasets, build automated data processes, and present findings to stakeholders, aligning analytics with business goals and growth.

The role emphasizes collaboration with partners and teams, leveraging GCP, BigQuery, SQL, and BI tools to drive decision-making and improve marketing effectiveness.

Qualifications

• Minimum 5 years in an analytical role with data manipulation, QA, statistics, and reporting.
• Proficiency with GCP/BigQuery, SQL, Alteryx, Power BI, Tableau, and Qlik.
• Bachelor’s or advanced degree in a quantitative field such as Statistics, Mathematics, Data Science, or related field.
• Strong problem-solving and communication skills, able to translate data into actionable insights.

Responsibilities

• Query, join, and wrangle large datasets; create calculated variables and automate data processes.
• Analyze performance metrics like response rates, sales lift, and profitability.
• Develop and support business and sales performance reporting with actionable insights.
• Serve as SME in customer analytics and financial reporting.
• Build dashboards and visualizations using Power BI, Tableau, Qlik, and Alteryx within GCP.
• Collaborate with clients to understand needs and present findings.
• Create clear presentations for stakeholders with visuals and insights.
• Preferably apply automotive service/parts industry familiarity to analytics initiatives.

Skills

GCP/BigQuery

SQL

Alteryx

Power BI

Tableau

Qlik

Data wrangling

Statistical analysis

Presentation skills

Cross-functional collaboration

Education

Bachelor's or higher in Statistics/Mathematics/Data Science

Tools

BigQuery

Google Cloud Platform

Tableau

Power BI

Alteryx

Qlik

Job description

OneMagnify is an AI native, platform-enabled B2B digital agency operating at the intersection of data, technology, and creativity. We help complex organizations drive measurable business outcomes by building smarter customer experiences and delivering highly integrated solutions across digital, media, and technology. By combining deep industry expertise with advanced analytics and artificial intelligence, we enable our clients to make better decisions, move faster, and compete more effectively in dynamic markets.

The Impact You'll Have:

The Senior Data Analyst is responsible for developing and supporting a range of analytic deliverables that drive business insights. These deliverables include, but are not limited to, sales and performance reporting, campaign and marketing analytics, dealer and customer behavior analysis, as well as the development of dashboards and other data visualizations to support business decision-making. The role also involves conducting strategic ad hoc analyses to inform overall business strategy, support day-to-day decision-making, and provide a deeper understanding of business performance, marketing campaign effectiveness, and customer behavior—both past and projected trends. The analyst will collaborate with business partners to identify analytical needs, understand key challenges, and address critical business questions, while working closely with data and analytics team members to deliver actionable insights.

What you’ll do:

• Leverage strong data wrangling skills to query, join, and manipulate large datasets, create calculated variables, and automate data processes.
• Analyze business and marketing program performance, including metrics such as response rates, sales lift, incremental revenue, net profit, and customer profiling.
• Develop and support business and sales performance reporting (BPR), delivering actionable insights to drive strategic decision-making.
• Serve as a subject matter expert in customer analytics, customer experience analytics, program effectiveness, and financial reporting.
• Build and maintain dashboards and data visualizations using tools such as Power BI, Qlik, Alteryx, and BigQuery, preferably within the Google Cloud Platform (GCP) ecosystem.
• Collaborate directly with clients to understand business needs, present key findings, and participate in team and stakeholder meetings.
• Create clear and impactful presentation materials, including PowerPoint decks with visualizations and insights for business stakeholders.
• (Preferred) Apply familiarity with the automotive service and parts industry to support targeted analytics initiatives.

What you’ll need:

• Minimum of 5 years of experience in an analytical role, with validated expertise in data manipulation, quality assurance, statistical analysis, and reporting.
• Strong proficiency in tools such "such as GCP/BigQuery, SQL, Alteryx, Power BI, Tableau, and Qlik to query, transform, visualize, and present complex data sets.">
• Bachelor’s or advanced degree in Statistics, Mathematics, Data Science, Econometrics, Computer Science, Analytics, Finance, or a related field.
• Solid understanding of at least one core analytics specialty.
• Excellent problem-solving skills with a passion for uncovering insights from data.
• Skilled in interpersonal communication, able to collaborate successfully with partners from multiple teams and communicate results to customers at all levels.
• Ability to work independently and cross-functionally in a dynamic environment.
• Strategic problem solver with the ability to distill complex information into clear, actionable insights.
• Meticulous attention to detail with a commitment to data accuracy, consistency, and alignment to common standards.
• Highly motivated, quick learner, and adaptable to changing business needs and evolving technologies.
• A high degree of personal integrity, professionalism, and ethical standards.

Future-Ready Skills (Nice to Have):

• Experience in integrated marketing, digital agency, marketing services, or consulting environments preferred.

Benefits

We believe great work happens when people have the support and flexibility they need to thrive.

• Medical, dental, and vision coverage.
• A 401(k) retirement plan.
• Paid holidays.
• Flexible Time Off (FTO) so you can take time away to recharge when you need it.
• Additional programs focused on wellness, financial security, and professional growth.

We are an equal opportunity employer.

We believe that Innovative ideas and solutions start with unique perspectives.

That’s why we’re committed to providing every employee a workplace that’s free of discrimination and intolerance.

We’re proud to be an equal opportunity employer and actively search for like-minded people to join our team.

We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform job functions, and to receive benefits and privileges of employment.

Please contact us to request accommodation.

Whether it’s awareness, advocacy, engagement, or efficacy, we move brands forward with work that delivers results. Through meaningful analytics, engaging communications and innovative technology solutions, we help clients tackle their most ambitious projects and overcome their biggest challenges.