The Data Engineer position is heavily involved with analyzing data, understanding and working with researchers, and working within a healthcare organization witha huge emphasis on our Epic software system. The Data Engineer position focuses on the, implementation, maintenance, and architecture of the MHealth Fairview data environment. The Data Engineer leverages all appropriate data tool(s) to acquire, restructure, and store enterprise data in a data warehouse and an increasing number of data marts. The Data Engineer participates in the planning, design, and deployment of enterprise data strategies by analyzing and translating business needs into a long-term solution data model that reduces redundancies, streamlines data movements, and improves enterprise information management, as well as leading the design, development, testing, administration, and maintenance of Master Data Management (MDM) platforms and processes, in partnership with Data Governance. The Data Engineer also supports the day-to-day operations of the data environment by monitoring data pipelines and troubleshooting any errors or performance issues that may occur in order to ensure complete and timely availability of data. The Data Engineer assists with the management of access to data in the environment to ensure the security of the data, and compliance with HIPAA guidelines.
This position is a full-time, 80hr per week, benefit eligible position! Some of the benefits we offer at Fairview include medical insurance - as low as $0, dental insurance - also a $0 option, PTO (up to 24 days per year starting), and 403B with up to a 6% employer match; click here to learn more!
When working at M Health Fairview, we want to support our employees growth, honor their strengths and give them the freedom to feel empowered to make a difference in the lives of others.
Responsibilities
- Implement effective large, sophisticated database and/or platform solutions and models to store and retrieve data based on architecture design.
- Define and implement data strategies, policies, controls to ensure accurate, complete, secure, trusted, reliable enterprise data
- Apply leadership skills with IT, business owners, and end users to define and document business, technical, and operational requirements.
- Champion initiatives to help the organization understand and improve data consistency, quality, and flows.
- Brings together, cleanses, and transforms data to provide insight and actionable recommendations independently.
- Assess database implementation procedures to ensure they follow internal and external regulations.
- Build analytics tools that apply the data pipeline to deliver actionable insights into customer acquisition, operational efficiency, and other key business performance metrics.
- Recommend solutions to improve new and existing database systems and data pipelines.
- Introduce and advocate for industry standard methodologies of modern data warehouse such as customer-centric, adaptable, automated, elastic, governed, secure, etc
- Prepare accurate database design and structure documentation for management and executive teams.
- Creates and leads independently enterprise level initiatives to produce written narrative summaries that outline project purpose, methodology, summary of findings, trends of interest, and opportunities for consideration.
- Educate team members on standards and best practices through training and individual support.
Qualifications
Minimum Qualifications
- Bachelor's Degree or certification of associate degree in related field, or equivalent work experience is required
- 3+ years of experience in data analysis and/or data architecture
- 3+ years of experience with various data models; Kimball, Inmon, and vaults
- 3+ years of experience with SQL(PL/SQL or T-SQL)
- Ability to read and write sophisticated queries joining multiple data sets
- Ability to write and troubleshoot stored procedures
- Ability to analyze SQL execution plans and build appropriate indexes on tables with poorly performing queries
- 3+ years of experience with database principles, processes, technologies along with solid understanding of Extract, Transform and Load (ETL) and tools
- 3+ years of experience in application development, data analysis, data consolidation, or data management / governance.
- Sophisticated knowledge of Azure platform/data tools such as Azure Data Lake, Azure Data Factory, Azure Synapse, Power BI, DevOps, Databricks, and other associated technologies
- Sophisticated knowledge of Amazon Web Service tools such as Redshift, BigQuery, Looker, and other associated technologies
- Knowledge of or experience with data quality tools and data governance tools
- Experience implementing and maintaining continuous integration/continuous delivery (CI/CD) processes
- Experience in multiple data modeling methodologies such as Data Vault and Kimball Dimensional Modeling for both structured and unstructured data
- Excellent technical and interpersonal communication skills
- Strong organizational and time management skills
- Ability to effectively lead and coordinate multiple projects and responsibilities.
- Strong quantitative and analysis skills.
- Ability to think creatively and work closely to address problems.
Preferred Qualifications
- Master’s degree in Computer Science, MIS, Data Engineering or another relevant field
- Experience with multiple RDBMS platforms (SQL Server, Oracle, etc.)
- Experience with SSIS/Data Factory or other ETL tools
- Familiarity with development methodologies, including the AGILE development approaches
- Experience with reporting Systems Development Lifecycle (SDLC) within an enterprise Electronic Health Record (EHR).
- Experience with cloud technologies; Azure (Synapse, Hyper-scaled SQL Server, etc) and/or AWS
EEO Statement
EEO/AA Employer/Vet/Disabled: All qualified applicants will receive consideration without regard to any lawfully protected status