Data Engineer
Midvale, UT
Full Time Mid-level / Intermediate USD 81K - 220K
CHG Healthcare
CHG Healthcare is the nation's largest physician staffing company—and one of FORTUNE magazine's Best Companies to Work For.Healthcare’s helping hand.
CHG shook things up in 1979 by inventing the locum tenens staffing model. We connect doctors with patients who need their care. As the largest physician staffing firm in America, our providers treat millions of patients each year.
Our industry is growing and demand is high. This means you’ll have plenty of opportunities to grow and develop in your career. Keeping healthcare healthy can be as fun as it is rewarding
Engineering is looking for a Data Engineer to join our Data Platform team. The Data Platform team gathers and enables data throughout the organization in order to provide insights into all aspects of CHG’s business. This allows our Sales and other business partners to make better informed decisions. As a Data Engineer on the Data Platform team, you will build ETL processes and data models to enable others to build dashboards and reports. This role will report to a Data Engineering manager.
Responsibilities:
- Implement the Enterprise Data Strategy defined by the company
- Analyze, design, develop, and deploy ETL solutions using Fivetran, dbt, and Snowflake
- Contribute to ongoing migration to the Cloud
- Develop, package, and deliver new service offerings related to Data and Business Intelligence
- Work with management, data platform architect, report developers, project managers, and product managers to understand and prioritize data and information requirements and deliver in an agile environment
- Participate in testing methodology and criteria
Qualifications:
- Willing to work alone as well as in a team, helping team members achieve project goals
- Demonstrate ability to help and mentor others as well as be open to mentoring from senior level peers, internalize feedback, change personal processes and behavior to conform to team objectives
- Maintain existing and develop new data pipelines, data models, and other data development requests, with considerations for processing performance
- Ensure quality data output for each development task through appropriate Self-QA that follows the testing standards of the Data Platform team
- Solid understanding of logical and physical models, including Kimball methodology
Education & Years of Experience:
- 3-5 year(s) experience with data analysis and building ELT/ETL solutions
- 3-5 year(s) experience with ELT/ETL and cloud data warehousing methodologies and tools; (Fivetran, Snowflake, dbt, and Prefect preferred)
- 3-5 years SQL experience writing medium to complex queries
- Demonstrated experience with reporting-database integration, using APIs to extract data from source systems, and processing data in a range of database platforms
- Demonstrated experience with software design practices, relational databases, and data-driven reporting applications
- Bachelor’s degree or equivalent work experience in a technical field
Preferred:
- Strong preference for candidates with experience building data pipelines using Python
- Experience with Prefect as an orchestration tool
- Experience building and/or using a semantic or metric layer
- Experience with the Kimball Methodology
We believe in fair compensation for all of our people, which is why our pay structure takes into account the cost of labor across U.S. geographic markets. For this position, we offer a pay range of $81,400 -- $220,700 annually, with pay varying depending on work location and job-related factors such as knowledge, position level and experience. During the hiring process, your recruiter can provide more information about the specific salary range for the job location.
CHG Healthcare offers starting salaries for sales positions in the form of total target compensation (TTC = base + commission + bonus), which includes base pay, commission, and bonuses. Sales positions receive short-term incentives through commission plans and bonuses. On the other hand, non-sales positions have starting salaries that consist of a base salary and short-term incentives through various bonus plans, which are paid out monthly, quarterly, or annually.
In return we offer:
• 401(k) retirement plan with company match
• Traditional healthcare benefits such as medical and dental coverage, and some unique benefits like onsite health centers, corporate wellness programs, and free behavioral health appointments.
• Flexible work schedules - including work-from-home options available
• Recognition programs with rewards including trips, cash, and paid time off
• Family-friendly benefits including paid parental leave, fertility coverage, adoption assistance, and marriage counseling
• Tailored training resources including free LinkedIn learning courses
• Volunteer time off and employee-driven matching grants
• Tuition reimbursement programs
Click here to learn more about our company and culture.
CHG Healthcare values a diverse and inclusive workforce. Interested in this role but not a perfect fit? Apply anyway.
We welcome applicants of any race, color, religion, sex, sexual orientation, gender identity, national origin, veteran status and individuals with disabilities as an Affirmative Action/Equal Opportunity Employer. We are an at-will employer.
What makes CHG Different?
Tags: Agile APIs Business Intelligence Data analysis Data pipelines Data strategy Data Warehousing dbt ELT Engineering ETL FiveTran Pipelines Python RDBMS Snowflake SQL Testing
Perks/benefits: 401(k) matching Career development Fertility benefits Flex vacation Health care Medical leave Parental leave Salary bonus Wellness
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.