Enterprise Data Modeler/Architect
Mentor, OH, US, 44060
STERIS
STERIS is a leading provider of infection prevention and other procedural products and services. Learn more here.At STERIS, we help our Customers create a healthier and safer world by providing innovative healthcare and life science product and service solutions around the globe.
Position Summary
The Data Architect demonstrates mastery of skills and knowledge and is a mentor, strategist, thought leader, evangelist, champion, Plans and leads data engineering activities.Responsible for overseeing the design, development, deployment, and maintenance of scalable and robust data solutions. Develops and manages data integration pipelines connecting disparate data sources. Works closely with data architects, data scientists, analysts, and other stakeholders to support business needs in analytical and data solutions/projects. Collaborates with Infrastructure and DBA teams to ensure appropriate infrastructure is in place. Optimizes and streamlines data processing efforts to ensure data quality, security, privacy, on time delivery and compliance. Provides technical leadership, mentorship, reviews deliverables and provides feedback to the data engineering team.
Duties
- Data Architecture and Technical Infrastructure (30%): Defines, plans, designs and support implementation of enterprise data architectures and enterprise data platform. Plans and leads data engineering activities for strategic, large, and complex programs. Leads the selection and development of data engineering methods, tools, and techniques.
- SDLC Methodology & Project Management (15%): Plans technical transitions between development, testing, and production phases of solutions' lifecycle, and the facilitation of the change control, problem management, and communication processes.
- Innovation, Continuous Improvement & Optimization (15%): Develops organizational policies, standards, and guidelines for the development and secure operation of data services and products. Ensures adherence to technical strategies and architectures.
- Data Modelling / Designing Datasets (10%): Coordinates the application of analysis, design, and modelling techniques to establish, modify or maintain data structures and their associated components. Manages the iteration, review and maintenance of data requirements and data models.
- Partnership and Community Building (10%): Collaborates with other IT teams, business community, data scientists and other architects to meet business requirements.
- Data Pipeline/ETL (5%): Sets standards for data modelling and design tools and techniques, advises on their application, and ensures compliance. Defines and implements administration and control activities related to data warehouse planning and development and the establishment of policies and procedures pertaining to its management, security, maintenance, and utilization.
- Support & Operations (5%): Manages the investigation of enterprise data requirements based upon a detailed understanding of information requirements.
- Data Governance and Data Quality (5%): Ensures that data is reliable, secure, and timely. Implement Data privacy and best practices. Defines, designs and implements data quality assessment and improvement methodology, processes and solutions.
- End-User Support, Education and Enablement (3%): Plans, designs, develops and facilitates training and Data Literacy initiatives within the team and End user community.
- Metadata Management & Documentation (2%): Ensure standards, and best practices in documentation of Metadata, Data Engineering processes and Architectures.
Required Experience
- Bachelors Degree in Data Science, Analytics, or a related field
- 7 years’ experience in development, maintenance, and enhancement of Data Pipelines (ETL/ELT) and processes with thorough knowledge of star/snowflake schemas
- 7 years’ experience in developing complex SQL queries and SQL optimization
- 7 years’ experience in development experience must be full Life Cycle experience including business requirements gathering, data sourcing, testing/data reconciliation, and deployment within Business Intelligence/Data Warehousing Architecture.
- 5 years’ experience in designing and implementing data security
- 7 years’ experience in monitoring and optimizing data storage and data processing
- 2 years’ experience in delivering Data Solutions using Cloud Technologies
Skills/ Competencies
- Advanced SQL skills and experience with relational databases and database design like Oracle and SQLSERVER.
- Significant experience working with cloud Data Warehouse and Data Lake solutions (e.g., Snowflake, Redshift, BigQuery, Azure Data Lake Storage, Amazon S3, etc.)
- Experience working with data ingestion tools such as Fivetran, stitch, or Matillion.
- Working knowledge of Cloud-based solutions (e.g., Azure, AWS and GCP).
- Experience building and deploying machine learning models in production.
- Strong proficiency in object-oriented languages: Python, Java, C++, Scala.
- Strong proficiency in scripting languages like Bash.
- Strong proficiency in data pipeline and workflow management tools (e.g., Airflow, Azkaban).
- Familiarity with big data frameworks such as Apache Hadoop and Apache Spark
- Strong project management and organizational skills.
- Excellent problem-solving, communication, and organizational skills.
- Demonstrated leadership experience and skills
- Ability to communicate effectively and influence technical and business stakeholders at all levels of the organization
- #LI-KS1 #LI-Hybrid
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, life sciences and dental products and services. STERIS is a $5 billion, publicly traded (NYSE: STE) company with approximately 17,000 associates and Customers in more than 100 countries.
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 and the use of affirmative action programs 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.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Airflow Architecture AWS Azkaban Azure Big Data BigQuery Business Intelligence Data governance Data pipelines Data quality Data warehouse Data Warehousing ELT Engineering ETL FiveTran GCP Hadoop Java Machine Learning Matillion ML models Oracle Pipelines Privacy Python RDBMS Redshift Scala SDLC Security Snowflake Spark SQL Testing
Perks/benefits: Career development Team events
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.