Snowflake Data Engineer

Founded in 2008, Locumsmart provides web-based software-as-a-service solutions to the healthcare recruitment industry. The Locumsmart web-portal provides workflow automation, vendor management (VMS), and managed services provider (MSP) software for lowering costs, and increasing the efficiency of recruitment. Our clients include some of the largest hospital systems and staffing firms in the country. 

Locumsmart is looking for a Data Engineer to join our Data Platform team. The Data Platform team gathers and enables data throughout the organization to provide insights into all aspects of Locumsmart’s business, including enabling data driven capabilities of the Locumsmart SaaS platform. As a Data Engineer on the Data Platform team, you will build ETL processes and data models to support the Technology Team’s building of dashboards, reports, and ML/AI platform capabilities.

Responsibilities:

• Implement the Enterprise Data Strategy defined by the company

• Analyze, design, develop, and deploy ETL solutions using Fivetran, dbt, and Snowflake

• 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, and dbt 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 Skills:

• Experience building and/or using a semantic or metric layer

• Experience with the Kimball Methodology

• Experience being a DBA knowledge source, advising on query and index optimization

• Experience delivering or supporting ML/AI solutions

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? You.