Senior Developer, Analytics

Oatey Company • Cleveland, OH

4d • $86,418 - $138,269 • Hybrid

About The Position

The Senior Analytics Developer delivers trusted business intelligence and analytics solutions across Oatey, partnering with business teams to translate reporting needs into scalable solutions using Power BI, Microsoft Fabric, SQL, and responsible AI. The role owns solutions from requirements through deployment and ongoing support, and reports to the Vice President, Analytics.

The position partners with business teams to define KPIs, analytical questions, requirements, and acceptance criteria, then manages the full solution lifecycle—from discovery and data preparation through modeling, report development, validation, deployment, documentation, and support. It develops and maintains Power BI reports, dashboards, semantic models, and analytics-layer transformations, while validating data quality and resolving source or governance issues with partner teams.

The role also applies generative AI to analytics and code development with appropriate validation, controls, and protection of company data. It supports governed self-service analytics through training and guidance, troubleshoots production issues, and continually improves the reliability, performance, usability, and business value of analytics solutions.

Requirements

• At least 5 years of professional experience in analytics, business intelligence, data, or a related analytics role, with demonstrated responsibility for delivering analytics solutions to business users.
• Advanced Power BI experience with reports, dashboards, DAX, relationships, and performance optimization.
• Strong semantic modeling skills across facts, dimensions, grain, measures, business definitions, and reusable structures.
• Advanced SQL skills and strong knowledge of relational data concepts, including querying, transforming, validating, and troubleshooting data used in analytics solutions.
• Strong analytical, problem-solving, communication, collaboration, and facilitation skills.
• Ability to translate business questions into technical requirements and explain analytics to technical and non-technical audiences.
• Ability to conduct small-group training and create reusable best-practice guidance.
• Demonstrated practical use of generative AI for analytics and code development, including SQL or DAX generation, troubleshooting, documentation, or data analysis, with critical review, validation, and human ownership of outcomes.
• Bachelor’s degree in information technology, Computer Science, Data Analytics, Business Analytics, Information Systems, or a related field, or equivalent relevant experience with Analytics in lieu of a degree.

Nice To Haves

• Experience with Microsoft Fabric or a comparable modern cloud analytics platform.
• Working knowledge of ETL/ELT concepts and analytics-layer data preparation.
• Experience with SAP S/4HANA.
• Familiarity with manufacturing, distribution, supply chain, or retail/commercial business domains.

Responsibilities

• Partner with business teams to understand processes and define KPIs, analytical questions, requirements, and acceptance criteria.
• Own analytics solutions from discovery through source identification, data preparation, semantic modeling, report and dashboard development, validation, UAT, deployment, documentation, and support.
• Design, develop, and maintain Power BI reports, dashboards, and semantic models, including advanced DAX, relationships, security, usability, and performance optimization.
• Develop and maintain analytics-layer transformations and Silver and Gold structures in Microsoft Fabric, Azure SQL Server, and related platforms.
• Use Fabric integration and, where applicable, Azure Data Factory to support ingestion, transformation, orchestration, and refresh.
• Validate data accuracy, investigate discrepancies, document business logic and lineage, and collaborate with Data Governance and application teams to resolve data quality or source-system issues.
• Use generative AI to accelerate SQL, DAX, code development, troubleshooting, documentation, and analysis; evaluate its value, validate outputs and controls, protect company data, and retain human accountability.
• Support governed self-service analytics through associate training, documentation, and best-practice guidance on data, certified semantic models, reporting standards, and appropriate analytics use.
• Troubleshoot production analytics issues, respond to assigned support requests, and improve solutions for reliability, performance, usability, and business value.

Benefits

• Generous paid time off programs and paid company holidays.
• Annual discretionary cash profit sharing.
• Immediate eligibility and vesting in 401(k), including 100% company match up to 5% of eligible compensation.
• Medical, dental, vision, and life insurance offerings for associates and qualified dependents.
• Significant company contribution to a Health Savings Account with a High Deductible Health Plan.
• Short-term and long-term disability income protection coverage at no cost to associates.
• Paid maternity and paid parental leave.
• Tuition reimbursement.
• Well-being resources, including resource groups, an Employee Assistance Program, and dedicated mental health support.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior