Data Migration Engineer

Posted 9 Days Ago
Be an Early Applicant
Hiring Remotely in US
Remote
Mid level
Big Data • Healthtech • Information Technology • Analytics
The Role
The Data Migration Engineer will oversee the migration of data from the legacy Health Catalyst DOS system to the Ignite platform. Responsibilities include migrating and re-engineering data marts, building and migrating BI applications, troubleshooting issues, and validating data consistency between the two platforms.
Summary Generated by Built In

Join one of the nation’s leading and most impactful health care performance improvement companies. Over the years, Health Catalyst has achieved and documented clinical, operational, and financial improvements for many of the nation’s leading healthcare organizations. We are also increasingly serving international markets. Our mission is to be the catalyst for massive, measurable, data-informed healthcare improvement through:

  • Data: integrate data in a flexible, open & scalable platform to power healthcare’s digital transformation​
  • Analytics: deliver analytic applications & services that generate insight on how to measurably improve​
  • Expertise: provide clinical, financial & operational experts who enable & accelerate improvement​
  • Engagement: attract, develop and retain world-class team members by being a best place to work​

Role: Migration (Data) Engineer

Team: Migration Team - Analytics Services
Location: US Remote

Scope: Fractional/Temp Work - data migration project

Start date: Jan 2025

Estimated end date: June 2025

Hours: 40 hours/week

*This position is not eligible for visa sponsorship*

The Data Migration Engineer plays a pivotal role in the seamless transition from Health Catalyst DOS to the new Ignite platform. This role will be responsible for the technical activities of migration, which will include migrating and re-engineering data marts in Databricks, building new BI applications and/or migrating existing applications to point to new platform, troubleshooting issues, and validating to ensure the new Ignite versions match DOS as expected.

Duties and Responsibilities:

  • Migrate client data marts and reports from the DOS legacy system to new Ignite platform
  • Migrate some or all components of legacy DOS data models into new platform, includes potential for re-factor and new development
  • Re-point BI layer to new platform, includes building measures and visualizations within BI layer
  • Migrate one visualization tool to another (Power BI to Tableau)
  • Identify and fix issues during migration that require remediation
  • Lead data validation tests to ensure consistent results between two platforms
  • Follow established processes and document findings according to Health Catalyst standards

What you'll bring to this role:

  • Experience writing and optimizing Databricks queries with performance and efficiency in mind
  • Understanding of Extract, Load, and Transform processes. 
  • Ability to effectively manage multiple projects
  • Willingness to learn new technology and methodologies
  • Experience with Tableau and Power BI, developing visualizations and reporting that consume data models for non-technical users

Required Experience:

  • Strong experience as a Data Engineer with knowledge of Source Control/git/ADO, VS Code, Databricks
  • Technical experience in multiple competencies; data query, data movement (ELT), data modeling, and BI visualization tools (Power BI, Tableau, Qlik). Strong expertise in Tableau.
  • Process improvement mindset to optimize processes, provide innovative ideas for automated tooling enhancements, and other ways to reduce migration timeline
  • Solid project management and organization skills
  • Ability to create documentation for future migration teams
  • Ability to mentor/train/educate others
  • Ability to independently learn new software tools quickly and ask for help or training when necessary
  • Ability to adapt quickly and change direction as needed to address client needs
  • Ability to collaborate with multiple disciplinary stakeholders to prioritize the project management deliverables and understand risk and/or impact

Nice to Have Skills:

  • Scripting experience, Python preferred

Soft Skills needed for this role:

  • Quick Learner
  • Strong attention to detail
  • Ability to follow defined processes and documentation
  • Critical thinking for validation
  • Ability to meet deadlines and be accountable for their work

Information Security and Compliance Responsibilities (This section can not be changed or modified)
 

  • Maintain compliance with training directives required by the organization pertaining to Information Security, Acceptable Use Policy and HIPAA Privacy and Security.
  • Adhere to and comply with the organizations Acceptable Use Policy.
  • Safeguard information system assets by identifying and reporting potential and actual security events to the organizations Security and Compliance Officers.

The above statements describe the general nature and level of work being performed in this job function.  They are not intended to be an exhaustive list of all duties, and indeed additional responsibilities may be assigned by Health Catalyst.

Studies show that candidates from underrepresented groups are less likely to apply for roles if they don’t have 100% of the qualifications shown in the job posting. While each of our roles have core requirements, please thoughtfully consider your skills and experience and decide if you are interested in the position. If you feel you may be a good fit for the role, even if you don’t meet all of the qualifications, we hope you will apply. If you feel you are lacking the core requirements for this position, we encourage you to continue exploring our careers page for other roles for which you may be a better fit.

At Health Catalyst, we appreciate the opportunity to benefit from the diverse backgrounds and experiences of others. Because of our deep commitment to respect every individual, Health Catalyst is an equal opportunity employer.

Top Skills

Databricks
SQL
The Company
HQ: Salt Lake City, UT
1,362 Employees
On-site Workplace
Year Founded: 2008

What We Do

Health Catalyst is dedicated to enabling health care organizations to fundamentally improve care by building the most comprehensive and fully integrated suite of healthcare data warehousing and process improvement solutions available.

Health Catalyst was formed by a group of healthcare veterans with vast data warehousing and quality improvement experience. Our founders and executives collaborated for nearly a decade to revolutionize clinical process models using analytics. During development, they faced numerous hurdles in the quest to develop a data warehouse that could handle the complexities unique to healthcare data.

After determining that the predominant approaches to data modeling weren’t effective for healthcare data, they discovered the solution, which is now known as the Adaptive Data Architecture. Using a late-binding bus architecture, Catalyst’s adaptive data model is agile, flexible, and can be implemented in a matter of weeks compared to the months or years traditional approaches require. Today at Health Catalyst, you’ll work with a team of experts who know that healthcare needs to change—and have made the change it needs a reality.
Transforming healthcare is our passion.

Similar Jobs

Remote
United States
92 Employees

eClinical Solutions Logo eClinical Solutions

Senior Database Engineer (Remote)

Cloud • Healthtech • Professional Services • Software • Pharmaceutical
Easy Apply
Remote
United States

Capital One Logo Capital One

Sr. Product Operations Analyst - Capital One Software (Remote)

Fintech • Machine Learning • Payments • Software • Financial Services
Remote
Hybrid
McLean, VA, USA
55000 Employees
97K-111K Annually

Golden Hippo Logo Golden Hippo

SEO Analyst

Digital Media • eCommerce • Information Technology • Marketing Tech • Retail • Social Media • Analytics
Remote
Hybrid
Los Angeles, CA, USA
500 Employees
61K-81K Annually

Similar Companies Hiring

Cencora Thumbnail
Pharmaceutical • Logistics • Healthtech
Conshohocken, PA
46000 Employees
Jobba Trade Technologies, Inc. Thumbnail
Software • Professional Services • Productivity • Information Technology • Cloud
Chicago, IL
45 Employees
InCommodities Thumbnail
Renewable Energy • Machine Learning • Information Technology • Energy • Automation • Analytics
Austin, TX
234 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account