Senior Developer, Analytics

Oatey • Cleveland, OH

3d • 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 understand processes, define KPIs and analytical questions, and establish requirements and acceptance criteria. It develops and maintains Power BI reports, dashboards, semantic models, and analytics-layer data transformations; validates data and business logic; supports governed self-service analytics; and troubleshoots and improves production solutions. Generative AI is used to support development and analysis, with outputs validated and company data protected.

Corporate-site associates are required to work in person according to Oatey’s Hybrid & Remote Workplace Policy. The role is primarily sedentary and involves prolonged sitting and computer work. The work environment is a climate-controlled office or remote environment with moderate noise levels. Minimal travel is required, though occasional travel to Oatey locations, conferences, training, or vendor/partner meetings may be necessary.

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 analytics data.
• Strong analytical, problem-solving, communication, collaboration, and facilitation skills.
• Ability to translate business questions into technical requirements, explain analytics to technical and non-technical audiences, conduct small-group training, and create reusable best-practice guidance.
• Demonstrated practical use of generative AI for analytics and code development, such as 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, business acceptance testing, deployment, documentation, and support.
• Design, develop, and maintain Power BI reports, dashboards, and semantic models, including advanced DAX, relationships, security requirements, 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 for SQL, DAX, code development, troubleshooting, documentation, and analysis; assess its value, validate outputs and controls, protect company data, and retain human accountability for delivered results.
• Support governed self-service analytics through associate training, documentation, and best-practice guidance on available data, certified semantic models, reporting standards, and appropriate analytics use.
• Troubleshoot production analytics issues, respond to assigned support requests, and continuously improve solutions for reliability, performance, usability, and business value.

Benefits

• Generous paid time off programs and paid company holidays.
• Annual discretionary cash profit sharing; target cash profit sharing is 12%.
• Immediate eligibility and vesting in a 401(k), including 100% company match up to 5% of eligible compensation.
• Medical, dental, vision, and life insurance offerings for associates and qualified dependents.
• 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.
• Associate 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