Senior Developer, Analytics

20600 Emerald Parkway, Cleveland, Ohio 44135 United States of America

Since 1916, Oatey has provided reliable, high-quality products for the residential and commercial plumbing industries, with a commitment to delivering quality, building trust and improving lives. Today, Oatey operates a comprehensive manufacturing and distribution network comprised of industry leading family of companies:
Oatey, Cherne, Keeney, Quick Drain, Hercules, Dearborn, Oatey Canada, William H. Harvey, Masters, Contact, Belanger, Lansas, and Durgo.

At Oatey, we're doing big things - and by joining us, you'll have the chance to do big things too. You can build a strong career in an innovative, inclusive, high-performance environment, with the confidence that your company cares — about you, our customers and our world.

Ready to make an impact in a place where you matter?

-

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.This role owns solutions from requirements through deployment and ongoing support, and reports to the Vice President, Analytics.

• Partner with business teams to understand processes, define key performance indicators (KPIs), analytical questions, requirements, and acceptance criteria; own solutions from discovery through source identification, data preparation, semantic modeling, report/dashboard development, validation and business acceptance testing (UAT), deployment, documentation, and support.
• Design, develop, and maintain high-quality 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 to accelerate SQL, DAX, code development, troubleshooting, documentation, and analysis; assess where AI adds value over structured data, 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 ways to create or use analytics.
• Troubleshoot production analytics issues, respond to assigned support requests, and continuously improve existing solutions for reliability, performance, usability, and business value.

• 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 in reports, dashboards, DAX, relationships, and performance optimization, with 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 the ability to query, transform, validate, and troubleshooting data used in analytics solutions.
• Preferred experience with Microsoft Fabric or a comparable modern cloud analytics platform; working knowledge of ETL/ELT concepts and…