Senior Developer, Analytics

Oatey Company; Cleveland (OH); Hybrid; USD 86,000 - 138,000; Full time

Benefits offered by this job

Generous paid time off

401(k) with company match

Health insurance

Tuition reimbursement

Disability coverage

Job summary

Oatey is seeking a Senior Analytics Developer to deliver trusted BI solutions across the organization. You will translate reporting needs into scalable Power BI dashboards and semantic models, leveraging Microsoft Fabric, SQL, and AI to accelerate development.

You will own solutions from requirements through deployment and support, reporting to the VP of Analytics. You will partner with business teams to define KPIs, ensure data quality, and drive performance improvements while enabling governed

Qualifications

• 5+ years delivering analytics solutions to business users
• Advanced Power BI: reports, dashboards, DAX, semantic modeling
• Advanced SQL and relational data concepts
• Familiarity with Microsoft Fabric or modern cloud analytics platform; ETL/ELT concepts

Responsibilities

• Partner with business teams to define KPIs, questions, requirements and acceptance criteria; own solutions from discovery to deployment
• Design, develop, and maintain Power BI reports, dashboards, and semantic models with optimized performance
• Develop analytics-layer transformations in Fabric, Azure SQL Server and related platforms; support ingestion and orchestration with ADF
• Validate data accuracy, document logic, and collaborate with Data Governance to resolve issues
• Use generative AI to accelerate SQL, DAX, code development, and analysis while retaining human accountability
• Support self-service analytics through training, documentation and best-practice guidance
• Troubleshoot production analytics issues and continuously improve solutions for reliability and business value

Skills

Power BI

SQL

DAX

Fabric

Generative AI

Data modeling

Communication

Education

Bachelor’s degree in IT / CS / Data Analytics

Tools

Microsoft Fabric

Azure Data Factory

Azure SQL Server

Job description

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

Why Oatey?

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?

Position Summary:

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.

Position Responsibilities:

• 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.

Knowledge and Experience:

• 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 analytics-layer data preparation.
• Strong analytical, problem-solving, communication, collaboration, and facilitation skills; able 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, including SQL or DAX generation, troubleshooting, documentation, or data analysis, with evidence of critical review, validation, and human ownership of outcomes.
• Experience with SAP S/4HANA and familiarity with manufacturing, distribution, supply chain, or retail / commercial business domains is preferred.

Education and Certification:

• 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.

Physical Activities and Other Working Conditions:

• Associates working at Corporate sites are required to work in-person according to the Hybrid & Remote Workplace Policy.
• This role is primarily sedentary and involves prolonged periods of sitting and working on a computer. Regular use of hands for typing and operating office equipment is required, along with visual focus on screens and documents. Occasional standing, walking, and lifting up to 10-15 pounds may be required. Work is performed in a climate-controlled office or remote environment with moderate noise levels.
• Minimal travel is required; occasional travel to Oatey locations, conferences, training, or vendor/partner meetings may be necessary.

#LI-SV1

#LI-Hybrid

Compensation Range for the Position:

$86,418.00 - $112,343.50 - $138,269.00 USD

Target Cash Profit Sharing for the Position:

12.00%

Offer amount determined by experience and review of internal talent.

Oatey Total Rewards

• Generous paid time off programs and paid company holidays to support flexibility and work-life balance
• Annual Discretionary Cash Profit Sharing
• Immediate eligibility and vesting in 401(k), including 100% company match, up to 5% of eligible compensation
• Market leading health insurance including medical, dental, vision, and life insurance offerings for associates and qualified dependents
• Significant company contribution to Health Savings Account with a High Deductible Health Plan (HDHP)
• Short-Term and Long-Term Disability income protection coverage at no cost to associates
• Paid Maternity and Paid Parental Leave
• Tuition reimbursement
• A strong set of complementary resources to support associate well-being, including resource groups, EAP, and dedicated mental health support.

Equal Opportunity Employer

The Oatey family of companies are an equal opportunity employer committed to Diversity, Equity, and Inclusion. We recruit, employ, promote, and offer competitive pay for all jobs without regard to race, color, creed, religion, sex, age, national origin, disability, sexual orientation, or any other characteristic protected by law.

Protect Yourself from Recruitment Scams

Oatey is committed to a safe and transparent hiring process. Please be aware of fraudulent recruiting communications.

How to recognize official Oatey communication:

• Emails will come from @oatey.com or [e-mail]
• We do not use unofficial or misspelled domains

What Oatey will never do:

• Ask for payment or fees at any stage
• Request sensitive personal or financial information early in the process
• Make a job offer without interviews

If something seems suspicious, do not engage. Instead, verify roles through our careers site and please make us aware by contacting [e-mail].