Data Analyst

Company 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. Role Overview The Data Analyst is responsible for developing and delivering high-quality analytical insights that support business decision-making. This includes a wide range of deliverables such as sales and performance reporting, campaign and marketing analytics, dealer and customer insights, and the creation of dashboards and data visualizations to enable clear and effective consumption of data. Key Impact You will conduct both strategic and ad hoc analyses to support overall business strategy, inform day-to-day decisions, and provide deeper insight into customer behavior, marketing effectiveness, and business performance trends. You will partner closely with business stakeholders to identify analytical needs, understand key challenges, and translate business questions into actionable insights while collaborating with data and analytics teams. Responsibilities Serve as the organization’s Power BI subject matter expert, designing, developing, and optimizing enterprise‑grade dashboards, reports, and data models that support critical business decisions. Establish Power BI best practices, governance standards, and reporting frameworks to ensure consistency, scalability, and data accuracy across all business reporting. Lead requirements gathering sessions with stakeholders to translate complex business needs into intuitive Power BI dashboards and self‑service analytics solutions. Optimize Power BI performance through advanced data modeling, DAX calculations, report tuning, and efficient integration with BigQuery and other data sources. Develop and deliver sales, marketing, and business performance reporting through advanced Power BI dashboards, data models, and visualizations that enable self‑service analytics and data‑driven decision making. Analyze campaign performance, customer behavior, and business trends to generate actionable insights and recommendations. Perform both strategic and ad hoc analyses to support business strategy, day‑to‑day operations, and future forecasting. Query, manipulate, and automate large datasets using SQL, BigQuery, and Alteryx to ensure accurate and efficient data processing. Build and maintain performance metrics and reporting frameworks for service, customer, and program analytics. Present findings and insights through clear visualizations, reports, and presentations to both technical and non‑technical audiences. Navigate and utilize modern cloud environments, specifically Google Cloud Platform (GCP) and Big Query, to manage large‑scale data operations. Proactively identify and resolve data quality issues, partnering with business owners to fix problems at the source. Translate technical solution concepts into clear, simple narratives that help clients and internal teams understand the “so what” behind the numbers. Develop scripts and automated workflows to replace manual reporting, increasing the speed and accuracy of analytic delivery. Continuously evaluate and adopt new technologies to keep the analytics stack efficient and forward‑looking. Partner with strategy and delivery teams to align analytic deliverables with client business goals. Participate in client‑facing status meetings, providing technical clarity and progress updates that build trust. Work within a distributed team to maintain high standards of accuracy and quality across different time zones and project phases. Qualifications A degree in a quantitative field (Statistics, Math, CS, Economics, Physics) or equivalent technical experience. 2+ years of experience in data analysis, with a proven track record in data wrangling, modeling, and measurement. 2–4+ years of hands‑on Power BI development experience, building executive‑level dashboards, KPI frameworks, and scalable reporting solutions. Experience developing and maintaining enterprise reporting solutions, KPI frameworks, and business performance dashboards within Power BI. Background in financial analytics or experience within integrated marketing, digital agency, or consulting environments. Strong communication skills with the ability to explain complex data concepts to non‑technical peers and leadership. Inventive and quick learner, with the ability to efficiently seek out, learn, and apply new areas of expertise. Highly self‑motivated, able to work independently and collaborate. Strong oral and written communication skills (English). Strategic and clear thinking to translate sophisticated ideas to get results. Attention to detail with a strong aim to implement common standards. Excellent data wrangling skills – query, join, manipulate data, automate processes. Expert‑level Power BI experience, including advanced dashboard development, data modeling, DAX, report optimization, workspace management, security implementation, and governance. Strong knowledge of SQL, BigQuery, Alteryx, GCP, Qlik, AI tools, and Microsoft Office. Desired Skills Familiarity with automotive services, vehicle sales, parts business, subscription services, loyalty program data, etc. (not required). Experience meeting clients directly to understand business needs and discuss findings. Ability to organize findings for business consumption into PowerPoints. Knowledge of Python or R for advanced statistical modeling or process automation. Benefits Medical, dental, and vision coverage. 401(k) retirement plan. Paid holidays. Flexible Time Off (FTO) to recharge when needed. Additional programs focused on wellness, financial security, and professional growth. EEO and Accommodation Statement We are an equal‑opportunity employer. We believe that innovative ideas and solutions start with unique perspectives. We are committed to providing every employee a workplace free of discrimination and intolerance. We will ensure individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, perform job functions, and receive benefits and privileges of employment. Please contact us to request accommodation. #J-18808-Ljbffr OneMagnify