Data Integration Developer II

POSITION DESCRIPTION:

The data integration (DI) Developer II is part of an innovative team of developers responsible for the delivery of Business Intelligence (BI) data for Trinity Michigan Medical Group. This is an intermediate level role for an experienced data integration developer who understands data warehouse design and architecture.  Primary job functions include data warehousing, data management, and supporting the architectural design of the enterprise data ecosystem, primarily utilizing the Microsoft data technology stack. This position requires developing broad healthcare subject matter expertise to understand customer requests, properly build the data warehouse, support BI reporting, and data analytics needs. DI Developers analyze data models and determine best-fit data integration methods from multiple data sources. They utilize SQL Server Integration Services (SSIS) packages, raw SQL, python scripting, and stored procedures to query, integrate, and transform data. The DI team collaborates closely with their counterparts, the BI Analysts, on defining, analyzing, and validating data objects to meet project deliverables. Data Integration developers forecast resource requirements and establish delivery timetables for new projects, while prioritizing their workloads. They also provide support for production extract/transform/load (ETL) jobs and data warehouse operations. The DI developer keeps up to date on data industry trends and explores areas for process automation and work improvements. They investigate innovative technology like artificial intelligence (AI), machine learning, and predictive analytics to derive deeper insights from data.

ESSENTIAL JOB FUNCTIONS:

1. Works closely with business Subject Matter Experts (SMEs) and BI Analysts to understand and map business needs into data warehouse and ETL design.
2. Creates and maintains Data Warehouse data model following set standards, utilizing both Relational and Dimensional Modeling techniques.
3. Creates and maintains ETL jobs to effectively load Enterprise Data Warehouse with good data quality.
4. Performs high level data extraction and manipulation from various healthcare databases and files to support organizational quality, utilization initiatives and other information needs.
5. Creates and maintains reports, reusable queries and/or dashboards to improve IHA’s operational reporting capability.
6. Understands different data delivery and data consumption method and create reports and dashboards as needed.
7. Leads Enterprise Data Warehouse projects and acts as technical project manager.
8. Creates and maintains metadata and documentation, including data models, data dictionary, data mapping.
9. Looks for ways to use data to support IHA’s quadruple aim.
10. Keeps up with industrial data technology trends and bring innovative ideas to the organization.
11. Understands Business Intelligence, Advanced Analytics, Machine Learning and Robotic Processing.

ORGANIZATIONAL EXPECTATIONS:

1. Creates a positive, professional, service-oriented work environment for staff, patients and family members by supporting the mission and values of both IHA and Trinity Health.
2. Must be able to work effectively as a member of the Information Systems team.
3. Assumes responsibility for performance of job duties in the safest possible manner, to assure personal safety and that of coworkers, and to report all preventable hazards and unsafe practices immediately to management.
4. Successfully completes IHA’s “The Customer” training and adheres to IHA’s standard of promptly providing a high level of service and respect to internal or external customers.
5. Maintains knowledge of and complies with IHA standards, policies and procedures.
6. Maintains complete knowledge of office services and in the use of all relevant office equipment, computer and manual systems.
7. Maintains strict patient and employee confidentiality in compliance with IHA and HIPAA guidelines.
8. Serves as a role model by demonstrating exceptional ability and willingness to take on new and additional responsibilities.  Embraces new ideas and respects cultural differences.
9. Uses resources efficiently.
10. If applicable, responsible for ongoing professional development – maintains appropriate licensure/certification and continuing education credentials, participates in available learning opportunities.

MEASURED BY:

Performance that meets or exceeds IHA CARES Values expectation as outlined in IHA Performance Review document, relative to position.

ESSENTIAL QUALIFICATIONS:

EDUCATION:  Bachelor’s degree in computer or data-related field or equivalent combination of education and relevant experience. Knowledge of the healthcare industry preferred.

CREDENTIALS/LICENSURE:  None

MINIMUM EXPERIENCE:   Minimum 5 years’ experience in data warehouse design and development. Experience in production support, reporting tools (SSRS, Crystal Reports, Tableau, Power BI), ETL tools (SSIS), performance tuning and programming. Minimum 3 years’ working experience in health care environment.

POSITION REQUIREMENTS (ABILITIES & SKILLS):

1. Minimum 5 years’ working experience in data warehouse and ETL development.
2. Minimum 3 years’ working experience in health care environment.
3. Expert in creating Data Warehouse data model following set standards, utilizing both Relational and Dimensional Modeling techniques.
4. Expert in ETL (Extract, Transform and Load) design and development.
5. Expert in SQL Server BI suite, including SSIS, SSRS, SSAS and Power BI.
6. Strong SQL/TSQL programming skills.
7. Understanding master data management and data quality principles, experience in Microsoft SQL Server Data Quality Services and/or Master Data Services a plus.
8. Excellent communication skills in both written and verbal forms, including proper phone etiquette.  Ability to speak before groups of people, either in-person or virtually.
9. Ability to lead and manage Enterprise Data Warehouse project and provide input to IHA BI strategy.
10. Ability to work independently and collaboratively in a team-oriented environment; displays courteous and friendly demeanor.
11. Ability to mentor and cross-train other team members to improve the team’s overall productivity.
12. Ability to work effectively with various levels of organizational members and diverse populations including IHA staff, providers, family members, insurance carriers, and vendors.
13. Ability to cross-train in other areas of department in order to achieve smooth flow of all operations.
14. Good organizational and time management skills to effectively juggle multiple priorities and time constraints.
15. Ability to exercise sound judgement and problem-solving skills, specifically as it relates to resolving data analytics and systems issues.
16. Ability to handle patient and organizational information in a confidential manner.
17. Successful completion of IHA competency-based program within introductory and training period.
18. Sufficient knowledge of medical terminology to perform responsibilities.  
19. Ability to drive to other office/practice sites and meeting and training locations.