What are the responsibilities and job description for the Sr. Data Warehouse Engineer position at Montage Health?
Welcome to Montage Health's application process!
Job Description : Job Description
Position Overview
We are looking for a highly skilled data warehouse engineer with exceptional ETL skills to play a crucial role in designing and implementing cutting-edge data pipeline infrastructures and models while providing essential support for our data warehouse. Success in this role will be fueled by expertise of data pipelines, data warehousing, and excellent communication skills. In addition to your core responsibilities, you may take on tasks such as designing and implementing data models, developing and testing data integration processes, and collaborating with fellow data professionals to guarantee data quality.
Responsibilities :
- Develop and maintain data pipelines, API-based or file-based data flows between source systems and the data warehouse
- Use innovative tools and techniques to automate common data preparation and integration tasks with the goal of reducing defects and ensuring data quality
- Implement best practices to ensure the integrity of data with exception-handling routines
- Provides source to target mapping development, support, and maintenance.
- Lead troubleshooting efforts and formulate interdisciplinary task force groups for ETL issues
- Design, develop, and deploy data structures and data transformations in the enterprise data warehouse using Python, SSIS, ADF
- Maintain and extend Epic Caboodle platform and develop custom Caboodle data modeling components
- Form relationships and coordinate with business stakeholders to identify data needs, clarify requirements, and implement solutions
- Contribute to the department's short-term and long-term strategic plan
- Make appropriate recommendations on management of data extraction, and analysis
- Maintain knowledge of the current regulations and technologies related to data management
- Assist with data governance initiatives in the areas of data quality, data security, metadata and master data management
- Actively contribute to all aspects of the data project lifecycle including request intake and acknowledgment, project estimation, time-tracking, and prioritization of tasks.
- Be an exemplary team player with excellent collaboration skills
- Exhibit outstanding customer service skills with stakeholders
- Perform other duties as required or assigned.
Experience
Education
Licensure / Certifications
Additional Information
Hours : Must be able to accommodate pacific time zone hours
Location : Remote
Equal Opportunity Employer
Salary Range (based on years of applicable experience)
115,481 to $154,356
LI-AC1
Assigned Work Hours :
Full time (exempt)
Position Type : Regular
Pay Range (based on years of applicable experience) :
55.52
74.21
Salary : $56 - $74
