Job description

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. 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-Remote Pay range for this opportunity is $125,000 - $150,000. This position is eligible for bonus participation and long term incentives. Minimum pay rates offered will comply with county/city minimums, if higher than range listed. Pay rates are based on a number of factors, including but not limited to local labor market costs, years of relevant experience, education, professional certifications, foreign language fluency, etc. STERIS offers a comprehensive and competitive benefits portfolio. Click here for a complete list of benefits: STERIS Benefits Open until position is filled. STERIS is a leading global provider of products and services that support patient care with an emphasis on infection prevention. WE HELP OUR CUSTOMERS CREATE A HEALTHIER AND SAFER WORLD by providing innovative healthcare and life sciences products and services around the globe. For more information, visit www.steris.com . If you need assistance completing the application process, please call 1 (440) 392.7047. This contact information is for accommodation inquiries only and cannot be used to check application status. STERIS is an Equal Opportunity Employer. We are committed to equal employment opportunity to ensure that persons are recruited, hired, trained, transferred and promoted in all job groups regardless of race, color, religion, age, disability, national origin, citizenship status, military or veteran status, sex (including pregnancy, childbirth and related medical conditions), sexual orientation, gender identity, genetic information, and any other category protected by federal, state or local law. We are not only committed to this policy by our status as a federal government contractor, but also we are strongly bound by the principle of equal employment opportunity. The full affirmative action program, absent the data metrics required by § 60-741.44(k), shall be available to all employees and applicants for employment for inspection upon request. The program may be obtained at your location’s HR Office during normal business hours.

Requirements

Must-haves

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

Nice-to-haves

None flagged.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

awssqlaiml

Platform: phenom
Effort: medium

Benefits

Benefits detected in the listing.

Dental

Vision

401(K)

Paid Time Off

Parental Leave