Data Engineer

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 BIA Data Engineer Designs, implements, and maintains complex data engineering solutions in the Business Intelligence and Analytics team Responsible for design, development, implementation, testing, documentation, and support of analytical and data solutions/projects requiring data aggregation/data pipelines/ETL/ELT from multiple sources into an efficient reporting mechanism, database/data warehouse using appropriate tools like Informatica, Azure Data Factory, SSIS. This includes interacting with business to gather requirements, analysis, and creation of functional and technical specs, testing, training, escalation, and follow-up. Support of the applications would include resolving issues reported by users. Issues could be caused by bugs in the application or user errors or programming errors. Resolution process will include, but not limited to, investigate known bugs on software vendor support website, create tickets or service requests with software vendor, develop scripts to fix data issues, make program changes, test fixes and apply the changes to production. These tasks and activities will be completed with the help and under the guidance of the supervisor. Participation in team and / or project meetings, to schedule work and discuss status, will be required. The position also requires staying abreast with changes in technology, programming languages, and software development tools. ## **What You'll do as a Data Engineer** * Data Pipeline/ETL (40%): Designs and implements data stores and ETL data flows and data pipelines to connect and prepare operational systems data for analytics and business intelligence (BI) systems. * Support & Operations (10%): Manages production deployments and automation, monitoring, job control and production support. Works with business users to test programs in Development and Quality. Investigates issues using vendor support website(s). * Data Modeling/Designing Datasets (10%): Reviews and understands business requirements for development tasks assigned and applies standard data modelling and design techniques based upon a detailed understanding of requirements. * Data Architecture and Technical Infrastructure (10%): Plans and drives the development of data engineering solutions ensuring that solutions balance functional and non-functional requirements. Monitors application of data standards and architectures including security and compliance. * SDLC Methodology & Project Management (5%): Contributes to technical transitions between development, testing, and production phases of solutions' lifecycle, and the facilitation of the change control, problem management, and communication processes. * Data Governance and Data Quality (5%): Identifies and investigates data quality/integrity problems, determine impact and provide solutions to problems. * Metadata Management & Documentation (5%): Documents all processes and mappings related to Data Pipelines work and follows development best practices as adopted by the BIA team * End-User Support, Education and Enablement (5%): Contributes to training and Data Literacy initiatives within the team and End user community. * Innovation, Continuous Improvement & Optimization (5%): Continuously improves and optimizes existing Data Engineering assets/processes. * Partnership and Community Building (5%): Collaborates with other IT teams, Business Community, data scientists and other architects to meet business requirements. Interact with DBAs on data designs optimal for data engineering solutions performance. ## **The Experience, Abilities and Skills Needed** * Bachelor's Degree and 2-4 years of relevant experience * Development, maintenance, and enhancement of Data Pipelines (ETL/ELT) and processes with thorough knowledge of star/snowflake schemas * Developing complex SQL queries and SQL optimization * 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. * Understanding of Data Architecture * Knowledge of ETL and data engineering standards and best practices for the design and development of data pipelines and data extract, transform and load processes * Design, build and test data products based on feeds from multiple systems, using a range of different storage technologies, access methods or both * Knowledge of data warehousing concepts, including multi-dimensional models and ETL logic for maintaining star-schemas * Good Understanding of concepts and principles of data modelling. * Ability to produce, maintain and update relevant data models for specific needs. * Can reverse-engineer data models from a live system * SQL programming desirable (i.e., stored procedures dev.) * Proficient in data analysis, defect identifications and resolutions. * Strong professional verbal and written communication skills. * Ability to work with little supervision and within changing priorities. * Ability to analyze requirements and troubleshoot problems. ## **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 Pay range for this opportunity is $70,000-95,000. This position is eligible for bonus participation. 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](https://steris-corp-comm.box.com/s/pgvfuqq6urrtkov891ypp1a7bvdvn2ta) 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](https://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. Req ID: 51493 Job Category: Information Technology Location: Mentor, OH, US, 44060 Workplace Type: Hybrid _[STERIS Sustainability](https://www.steris.com/sustainability)_ _[Life at STERIS](https://careers.steris.com/content/Life-at-STERIS/?locale=en_US)_ **Nearest Major Market:** Cleveland **Nearest Secondary Market:** Akron **Job Segment:** Testing, Infection Control, Patient Care, Data Warehouse, Business Intelligence, Technology, Healthcare