Analytics Architect

Rumpke of Ohio, Inc.; Cincinnati (OH); On-site; USD 130,000 - 170,000; Full time

Job summary

Rumpke of Ohio, Inc. is seeking an Analytics Architect to lead the semantic layer strategy across all domains. You will define enterprise-wide data modeling standards and select technologies to ensure scalable, maintainable analytics infrastructure.

The role partners with the Data Architect to align platform architecture with semantic models and mentors teammates in architectural thinking. The ideal candidate brings 10+ years in data modeling or analytics engineering, strong Snowflake and SQL

Qualifications

• 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.
• Experience setting enterprise-wide data modeling or semantic layer standards.
• 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.

Responsibilities

• Define and own the semantic layer strategy and architecture across all domains.
• 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.

Skills

Analytical thinking

Problem solving

Mentoring

Communication

Data-driven decisions

Education

Bachelor's degree in Computer Science or related field

Master's degree preferred

Tools

Snowflake

SQL

dbt

dbt Analytics Certification

Snowflake SnowPro Core Certification

Job description

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

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.

Qualifications

Education

• High School (required)
• General Education Diploma (preferred)
• Bachelors of Relevant field (required)
• Masters of Relevant field (preferred)