CHG Healthcare
Data Engineer
CHG Healthcare, Salt Lake City, Utah, United States, 84193
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 Tableau extracts to enable others to build dashboards and reports. This role will report to the Data Platform manager.Responsibilities
Implement the Enterprise Data Strategy defined by the companyAnalyze, design, develop, and deploy ETL solutions using dbt, Snowflake, and Prefect as well as the Microsoft BI Suite for legacy support.Contribute to ongoing migration to the Cloud, as well as load data/maintain data quality in the Data LakeDevelop, package, and deliver new service offerings related to Data and Business IntelligenceWork 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 environmentParticipate in testing methodology and criteriaQualifications
Willing to work alone as well as in a team, helping team members achieve project goalsDemonstrate 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 objectivesMaintain existing and develop new data pipelines, Tableau Extracts, and other data development requests, with considerations for processing performanceEnsure quality data output for each development task through appropriate Self-QA that follows the testing standards of the Data Platform teamSolid understanding of logical and physical models, including Kimball methodologyEducation And Years Of Experience
3-5 year(s) experience with data analysis and building ELT/ETL solutions3-5 year(s) experience with ELT/ETL and cloud data warehousing methodologies and tools; (Snowflake, dbt, and Prefect preferred)3-5 years SQL experience writing medium to complex queriesDemonstrated experience with reporting-database integration, using APIs to extract data from source systems, and processing data in a range of database platformsDemonstrated experience with software design practices, relational databases, and data-driven reporting applicationsBachelor’s degree or equivalent work experience in a technical fieldPreferred
Strong preference for candidates with experience building data pipelines using PythonExperience with Prefect as an orchestration toolExperience building and/or using a semantic or metric layerExperience with the Kimball MethodologyWe 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 $79,800-- $216,600 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 matchTraditional 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 availableRecognition programs with rewards including trips, cash, and paid time offFamily-friendly benefits including paid parental leave, fertility coverage, adoption assistance, and marriage counselingTailored training resources including free LinkedIn learning coursesVolunteer time off and employee-driven matching grantsTuition reimbursement programsCHG 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.
#J-18808-Ljbffr
Implement the Enterprise Data Strategy defined by the companyAnalyze, design, develop, and deploy ETL solutions using dbt, Snowflake, and Prefect as well as the Microsoft BI Suite for legacy support.Contribute to ongoing migration to the Cloud, as well as load data/maintain data quality in the Data LakeDevelop, package, and deliver new service offerings related to Data and Business IntelligenceWork 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 environmentParticipate in testing methodology and criteriaQualifications
Willing to work alone as well as in a team, helping team members achieve project goalsDemonstrate 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 objectivesMaintain existing and develop new data pipelines, Tableau Extracts, and other data development requests, with considerations for processing performanceEnsure quality data output for each development task through appropriate Self-QA that follows the testing standards of the Data Platform teamSolid understanding of logical and physical models, including Kimball methodologyEducation And Years Of Experience
3-5 year(s) experience with data analysis and building ELT/ETL solutions3-5 year(s) experience with ELT/ETL and cloud data warehousing methodologies and tools; (Snowflake, dbt, and Prefect preferred)3-5 years SQL experience writing medium to complex queriesDemonstrated experience with reporting-database integration, using APIs to extract data from source systems, and processing data in a range of database platformsDemonstrated experience with software design practices, relational databases, and data-driven reporting applicationsBachelor’s degree or equivalent work experience in a technical fieldPreferred
Strong preference for candidates with experience building data pipelines using PythonExperience with Prefect as an orchestration toolExperience building and/or using a semantic or metric layerExperience with the Kimball MethodologyWe 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 $79,800-- $216,600 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 matchTraditional 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 availableRecognition programs with rewards including trips, cash, and paid time offFamily-friendly benefits including paid parental leave, fertility coverage, adoption assistance, and marriage counselingTailored training resources including free LinkedIn learning coursesVolunteer time off and employee-driven matching grantsTuition reimbursement programsCHG 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.
#J-18808-Ljbffr