Sr. Engineer II, Data Engineering
Description
Company: Oak Street Health
Title: Sr. Engineer II, Data Engineer
Location: Treehouse (30 W Monroe, Chicago, IL) or Remote
Role Description
The Sr. Engineer II, the Data Engineer will be responsible for delivering high quality modern data solutions through collaboration with our engineering, analysts, and product teams in a fast-paced, agile environment leveraging cutting-edge technology to reimagine how Healthcare is provided. You will be instrumental in designing, integrating, and implementing solutions as well supporting migrations of existing workloads to a new modernized data platform. The Sr Data Engineer II is expected to have extensive knowledge of modern programming languages, designing and developing data solutions.
Responsibilities
- Design & build data pipelines to move data from various internal and external sources into a data warehouse that can scale with the growing data needs of the company.
- Writes ETL processes, designs database systems and develops tools for real-time and batch data processing.
- Research, analyze, recommend and select technical approaches for solving difficult and meaningful development and integration problems.
- Collaborate with cross functional stakeholders to understand requirements and prioritize data needs across the company.
- Participate in efforts to develop and execute testing, training, and documentation across applications.
- Understand and work with multiple data sources to meet business rules and support analytical needs
- Participate in development and support of Data Warehouse solutions
- Work with business analysts and stakeholders to understand business needs and develop highly scalable solutions. Make recommendations to help solve problems or improve processes
- Develop cross validation rules to ensure data accuracy
- Meet business requirements of the projects as new data sources are added
- Provide production support of existing ETL processes
- Document steps needed to migrate database objects between various environments including Development, UAT, Staging, and Production
- Provide regular project updates to management as needed
- Proactively Communicate issues, risks, and concerns to management and development team
- Document ETL process thoroughly to allow peers to assist with support as needed
- Manage day to day activities of the ETL developer
- Participate in code reviews after ETL developers complete projects
What we're looking for
We're looking for motivated, experienced individual with:
- Bachelor's degree in Computer Science, Computer Engineering, relevant technical field, or equivalent practical experience
- 5+ years hands-on experience with cloud orchestration and automation tools, CI/CD pipeline creation
- Expert-level SQL, Python, Java or PySpark
- Hands-on experience with dimensional data modeling, schema design, and data warehousing.
- Hands-on experience with developing solutions in Azure Data Lake, Azure Data Factory, Azure SQL Data Warehouse, Azure Synapse and mongoDB is a plus.
- Ability to see projects through from the beginning to end, power through and get things done. Not afraid or put off by more mundane tasks as long as they are providing value
- Willingness to identify and implement process improvements, and best practices as well as ability to take ownership to work within a fast-paced, collaborative, and team-based support environment.
- Technical leadership; capable of handling mentorship, cross functional project execution, and solid individual contribution
- Able to communicate complex technical concepts to both technical and non technical audiences
- Knowledge of T-SQL and basic C# for SSIS tasks
- Experience in relational and multi-dimensional databases as well as 2-tier and 3-tier architecture.
- Excellent analytical and program debugging skills
- A desire to work within a fast-paced, collaborative, and team-based support environment
- Ability to work independently as well as function as part of a team
- Ability to take ownership of a project and see it from end to end
- Excellent oral and written communication skills
"Nice-to-haves"
Ideal candidate would have exposure working with the following types of data:
- Healthcare Insurance data feeds as either flat files or EDI communications: Eligibility, Claims, Pharmacy Claims, Revenue, etc.
- Healthcare Codes: ICD, CPT, NDC, HCPC, DRG, etc.
- HCC Model, STARS Measures and HEDIS Metrics
- Clinic Utilization Management Analytics
What does being "Oaky" look like?
- Radiating positive energy
- Assuming good intentions
- Creating an unmatched patient experience
- Driving clinical excellence
- Taking ownership and delivering results
- Being relentlessly determined
Why Oak Street Health?
Oak Street Health is on a mission to "Rebuild healthcare as it should be'', providing personalized primary care for older adults on Medicare, with the goal of keeping patients healthy and living life to the fullest. Our innovative care model is centered right in our patient's communities, and focused on the quality of care over volume of services. We're an organization on the move! With over 150 locations and an ambitious growth trajectory, Oak Street Health is attracting and cultivating team members who embody "Oaky" values and passion for our mission.
Oak Street Health Benefits:
- Mission-focused career impacting change and measurably improving health outcomes for medicare patients
- Paid vacation, sick time, and investment/retirement 401K match options
- Health insurance, vision, and dental benefits
- Opportunities for leadership development and continuing education stipends
- New centers and flexible work environments
- Opportunities for high levels of responsibility and rapid advancement
Oak Street Health is an equal opportunity employer. We embrace diversity and encourage all interested readers to apply.