Position Summary

The Enterprise Data Modeler / Data Architect designs and leads enterprise-scale data models that power cloud data warehouses, data lakes, and analytics platforms. This role partners closely with business stakeholders, data engineers, and analytics teams to translate business and analytical needs into scalable, high‑quality data models and metadata that enable trusted, self-service reporting, advanced analytics, and data science use cases.

This role is hybrid-based in Mentor, Ohio.

What You'll do as a Enterprise Data Modeler / Data Architect

• Design, implement, and maintain conceptual, logical, and physical data models for enterprise data warehouses, data lakes, and specialized data stores.
• Collaborate with business and technical stakeholders to gather requirements and translate them into efficient, scalable data designs.
• Define and govern enterprise data modeling and metadata standards, best practices, and design patterns.
• Partner with data engineering teams to ensure data models align with ETL/data pipelines, lineage, and performance requirements.
• Develop and maintain data documentation, including data dictionaries, business glossary entries, and data catalog metadata.
• Support and evolve the Enterprise Data Catalog and Business Glossary, capturing business, technical, and operational metadata.
• Work with Data Owners and Data Stewards to ensure key data elements have clear definitions, ownership, lineage, and data quality context.
• Serve as a technical leader and mentor, promoting data modeling, metadata, and governance best practices across the organization.

The Experience, Abilities and Skills Needed

• Bachelor’s degree in Computer Science, MIS, Informatics, or related field
• 10+ years of experience in enterprise data modeling, preferably in cloud-based data warehouse and data lake environments.
• Strong expertise in dimensional modeling (star and snowflake schemas) and relational data design.
• Hands-on experience with cloud data platforms such as Snowflake, AWS Redshift, or Google BigQuery.
• Advanced SQL skills and experience designing database schemas and structures.
• Proven experience with Enterprise Data Catalogs and Business Glossaries, including tools like Collibra, Alation or MS Purview
• Experience with defining metadata standards, mandatory attributes, and data stewardship workflows.
• Ability to collaborate on metadata strategy supporting self-service BI, analytics, and data governance.
• Proficiency with data modeling tools (e.g., Erwin, ER Studio, IBM InfoSphere Data Architect or similar).
• Solid understanding of data engineering concepts, ETL/data pipelines, data lineage, and integration practices.
• Experience embedding metadata, naming standards, and data quality practices into data platforms and development processes.
• Excellent communication and collaboration skills across business, analytics, and technology teams.
• Expertise with data and metadata modeling best practices to design data repositories optimized to support AI/ML applications and use cases is highly desired.

What STERIS Offers

At STERIS, we invest in our employees and their families for the long term! STERIS wouldn’t be where it is today without our incredible people. We share our success together with you by rewarding you for your hard work and achievements.

Here is just a brief overview of what we offer:

• Competitive Pay
• Extensive Paid Time Off and (9) added Holidays.
• Excellent healthcare, dental, and vision benefits
• 401(k) with a company match
• Long/Short term disability coverage
• Parental Leave
• Additional add-on benefits/discounts for programs such as Pet Insurance
• Continued training and educations programs
• Excellent opportunities for advancement in a stable long-term career
• #LI-KS1 #LI-Hybrid