People. Passion. Purpose. 

At P3 Health Partners, our promise is to guide our communities to better health, unburden clinicians, align incentives and engage patients.

We are a physician-led organization relentless in our mission to overcome all obstacles by positively disrupting the business of health care, transforming it from sickness care into wellness guidance.

We are looking for a Senior Data Engineer. If you are passionate about your work; eager to have fun; and motivated to be part of a fast-growing organization in Las Vegas, Nevada, then you should consider joining our team.

Senior Data Engineer

Overall Purpose:

Responsible for data integration to support all inbound/outbound Data Warehouse ETL processes. This includes but not limited to, development, testing and integration of ETL Processes (using SSIS or/other standard ETL tools). This position works closely with business systems analysts, project managers and various business stakeholders to support and provide quality delivery of data through extraction and transformation using defined business rules.

Responsible for the development of Microsoft SQL Server Stored procedures, Data Tables, Reports, and Analytics. Key in maintaining Data integrity and data quality through close working with business users and business systems analysts.

Responsible for Data loading, tracking, validation and Root Cause Analysis of reported data irregularities.

Responsible for work queuing and reporting of Sprint progress and daily task progress and issues to ensure rapid development of code.

Responsible for demonstrating deep understanding of one or more healthcare data domains, such as HCC, MRA, RAF, Claims, Eligibility, or CMS financial data.

Education and Experience:

• Bachelor’s degree in computer science or related field
• 3-5 Years of proficient experience in designing and developing of mappings, transformations, sessions, workflows and deploying integration solutions using standard ETL tools (SQL Server Integration Services preferred)
• Previous experience in healthcare, or extended knowledge of healthcare terminology and data relationships required.

Knowledge, Skills and Abilities:

• Strong experience in performance tuning of ETL processes
• Proficient in data integration between different data sources. Extensively worked on data extraction, Transformation and loading data from various sources like SQL Server and Flat files, data warehouse loading and cube dimension and fact loading and validation.
• Knowledge and experience of working on SQL Queries and database scripting (procedures, functions, jobs, physical data model creation)
• Experience in Development, Support, Maintenance, and Enhancement projects
• Development experience in MS SQL (SQL 2005/2008/2012/2014/2016/2018,2021 or further), T-SQL, basic database design skills and application performance tuning
• Experience with Data Warehouse lifecycle including data analysis, data modeling and design
• Strong problem solving and troubleshooting skills
• Effective verbal and written communication skills
• Demonstrated ability to deliver working solutions on a tight/evolving schedule

Essential Functions: 

• Work with business users to define and understand business requirements related to changes and enhancements of existing enterprise data warehouse
• Perform unit testing of development jobs before production deployment
• Fulfill ad-hoc report requests for the supported business stream(s) as required
• Communicate all issues, risks, concerns and status to management, business partners and other departments in a timely manner
• Work with stakeholders at all levels in the organization and across departments to ensure compliance and governance methods, processes, and tools are followed/used