Analytics Architect

Rumpke; Bevis (OH); On-site; USD 140,000 - 190,000; Full time

Benefits offered by this job

Health insurance

Dental

Vision

Matching 401(k)

Life insurance

Paid vacation

Job summary

Rumpke Waste and Recycling in Cincinnati, OH is seeking an Analytics Architect who will design and own the semantic layer strategy across domains, enabling self-service analytics and reliable reporting.

You will collaborate with Data Architects and Analytics Engineers to set modeling standards, ensure data quality, and drive scalable solutions. This senior role requires strong communication and mentoring across teams and a commitment to enterprise-wide architecture.

Qualifications

• Bachelor's degree in Computer Science, Analytics, or related field.
• 10+ years of experience in data modeling, analytics engineering, or data architecture.
• Experience setting enterprise-wide data modeling or semantic layer standards.
• Extensive hands-on with Snowflake, semantic layers, and SQL.
• dbt Analytics Engineering Certification and Snowflake SnowPro Core Certification preferred.

Responsibilities

• Define and own the semantic layer strategy across all domains.
• Set enterprise-wide data modeling standards and patterns.
• Evaluate tools for the semantic/analytics layer and ensure long-term maintainability.
• Partner with Data Architect for platform-alignment.
• Advise on long-term analytics architecture strategy including scalability.
• Establish frameworks for data quality, observability, and governance.

Skills

Analytical skills

Problem solving

Mentoring

Stakeholder alignment

Written communication

SQL

Snowflake

dbt

Education

Bachelor's degree in Computer Science/Analytics

Master's degree preferred

dbt Analytics Engineering Certification

Snowflake SnowPro Core Certification

Tools

Snowflake

SQL

dbt

Job description

Corporate Campus | Corporate HQ
3990 Generation Dr
Cincinnati, OH 45251, USA

Description

Rumpke is a family-owned and operated company that ranks as one of the largest firms in the waste and recycling industry. Our mission is simple: to deliver exceptional waste and recycling solutions to our customers and communities through a commitment to safety, service, the environment and the growth of our people.

When you join Rumpke, you’ll be part of a team providing essential services to millions of residents, businesses, and neighborhoods. You will enjoy competitive pay and comprehensive benefits, including health, dental, vision, matching 401(k), life insurance, paid vacation, and more.

This is your opportunity to make a difference for you and your family. Come join our team!

As a member of the Data and Analytics team, the Analytics Architect responsibilities will fall between data engineering and the business, turning raw, well-structured data into governed, business-friendly semantic models - the layer that both self service tools and analysts depend on for accurate, consistent answers. This role owns the semantic layer strategy and architecture across all business domains. This role sets enterprise-wide modeling standards and technology direction, resolves cross-domain architectural risks, partners with the Data Architect on platform alignment, and mentors junior team members on architectural thinking.

Responsibilities of Position:

• Define and own the semantic layer strategy and architecture across all domains, ensuring consistency as new domains and use cases are added
• Set enterprise-wide data modeling standards, patterns, and technology choices for Analytics Engineering, influencing adoption across the team without direct management authority
• Evaluate and select tools and technologies for the semantic/analytics layer, weighing cost, scalability, and long-term maintainability Identify cross-domain architectural risks or inconsistencies before they compound, and drive resolution across multiple domains
• Partner with the Data Architect to ensure alignment between platform architecture and analytics/semantic layer architecture
• Advise team leadership on long-term analytics architecture strategy, including how today's decisions affect future scalability and flexibility
• Establish frameworks for data quality, observability, and governance that apply consistently across all domains
• Serve as the final technical escalation point for complex, cross-domain modeling problems
• Mentor junior team members on architectural thinking, not just modeling execution
• Perform other duties as assigned

Supervisory Responsibility:

• This position will not manage employees

Skills & Abilities Needed for Position:

• Excellent analytical and problem-solving skills
• Ability to resolve ambiguous or conflicting requirements independently
• Ability to mentor and review the work of less experienced team members
• Ability to drive alignment and prioritization across multiple stakeholders and competing priorities
• Excellent written and verbal communication skills
• Ability to diagnose root causes of data or reporting issues, not just identify symptoms

Experience & Knowledge Needed for Position:

• Bachelor's degree in Computer Science, Analytics, or related field required; Master's degree a plus
• 10+ years of experience in data modeling, analytics engineering, or data architecture required
• Experience setting enterprise-wide data modeling or semantic layer standards required
• Extensive hands‑on expertise with Snowflake or a comparable cloud data warehouse architecture, semantic layers, and SQL required
• dbt Analytics Engineering Certification and Snowflake SnowPro Core Certification preferred

Physical Requirements in a Regular Workday:

• Frequently lifting/carrying a max of 10 lbs; rarely a max of 35 lbs
• Rarely pushing/pulling a max of 20 lbs-li>Continuously working inside
• Occasionally stooping/kneeling/crouching/crawling
• Frequently sitting; occasionally standing/walking

Additional Working Conditions/Aspects:

• Ability to travel between offices, as required
• Ability to workflexible hours; expected to work nights and weekends as needed
• Ability to work overtime, weekends, and/or holidays
• Legally eligible to work in the United States
• Valid driver’s license (if applicable)
• Must successfully complete pre-employment testing
• Must be able to read and speak the English language

This job description is intended to describe the general nature, complexity, and level of work to be performed by employees assigned to this position and is not to be construed as an exhaustive list of responsibilities, duties, and/or skills required. It does not prescribe or restrict the work that may be assigned. Furthermore, this does not establish an employment contract and is subject to change at the discretion of the company.

Rumpke Waste and Recycling is committed to equality in all aspects of employment. It is Rumpke’s policy to provide equal opportunities to all employees and potential employees without regard to race, color, religion, gender, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.

Qualifications

Education

Required

Bachelors or better in Relevant field.

High School or better.

Preferred

General Education Diploma or better.

Masters or better in Relevant field.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
This employer is required to notify all applicants of their rights pursuant to federal employment laws.For further information, please review the Know Your Rights notice from the Department of Labor.