Steward Health Care System

Receive alerts when this company posts new jobs.

Similar Jobs

Job Details

Data Quality Engineer

at Steward Health Care System

Posted: 10/28/2020
Job Status: Full Time
Job Reference #: 35205
Keywords: architecture

Job Description

Location: Steward Health Care
Posted Date: 9/9/2020

The Quality Assurance advances Steward’s mission of providing world class healthcare in the community by delivering relevant information to key stakeholders to drive improvements in care quality, operational effectiveness, and risk management. The Data Quality Engineer is responsible for designing, developing, documenting and performing data quality checks across all data assets. That includes ETL jobs, reports, dashboards and data pipelines. The primary goal for this role is to ensure high quality of data delivered to internal stakeholders and customers. Validation of data in data repositories against data from source systems and validation of metrics and data in reports/dashboards against data in the repositories is a key responsibility.

Principle responsibilities are to make data assets consistently accurate for users:

  • Design, develop and maintain data quality assurance framework
  • Work in conjunction with technical and business stakeholders to ensure high quality data
  • Design and develop testing frameworks to test, monitor and alert
    • ETL jobs
    • BI reports and dashboards, and
    • other data pipelines
  • Write SQL scripts to validate data in the data repositories against the data in the source systems
  • Write SQL scripts to validate data surfacing in BI assets against the data sources
  • Ensure data quality by checking warehouse data against front-end application user interfaces
  • Track, monitor, and document testing results
  • Write high-quality, well-structured code that is maintainable and extensible
  • Analyze complex data systems to develop automated and reusable solutions for extracting requested information while assuring data validity and integrity
  • Perform tasks spanning the full lifecycle of data management activities with minimal supervision

Other key activities:

  • Collaborate with Product Managers and business community to elicit, document, and translate business requirements for data needs into technical requirements while contributing to a unified system architecture and minimizing technical debt
  • Promote and support the infrastructure of reporting, analytics, and data sourcing strategy; this includes developing and advancing standards and best practices and recommending infrastructure changes when appropriate
  • Perform ongoing monitoring and refinement of data platform
  • Design and implement solutions to improve data platform
  • Collaborate on and learn new technologies
  • Maintain, expand, and improve ETL processes
  • Maintain data standards, enforce standard development protocols, and analyze requirements to ensure technical and standard operating procedure impacts are considered
  • Develop and coordinate test plans
  • Troubleshoot and performance tune data management code
  • Limit non-standard solutions and escalate when used with documentation supporting exception requirements
  • Manage code using GitHub and other version control approaches as applicable
  • Perform other duties as assigned

Work team approach:

  • Work on a highly collaborative agile team
  • Coordinate work with Database Administrators and System Engineers, as needed
  • Assist report writers and data visualization team members with data sourcing
  • Participate in technical reviews and provide detailed feedback for process improvement
  • Collaborate with the Decision Services team, other members of Information Services, and cross-functional business stakeholders to translate business requirements into technical specifications

Education/Experience/Licensure/Technical/Other:

Education: Bachelor’s degree; Computer Science, MIS or Mathematics are preferred majors.

Experience (Type & Length):5+ years working in healthcare or life sciences preferred. 7+ years relevant work experience working in a business intelligence developer role.

Certification/Licensure: None Required

Software/Hardware: 5+ years’ experience in Microsoft SQL Server 2005 and 2008 RDBMS, Microsoft SQL Server 2005 and 2008 Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS) and Microsoft SQL Server Analysis Services (SSAS). Expert knowledge of SQL programming languages.

Other: Exceptional candidates will have proven experience with some or all of the following technologies: web services, ASP.Net, C#, QlikView

Application Instructions

Please click on the link below to apply for this position. A new window will open and direct you to apply at our corporate careers page. We look forward to hearing from you!