Director, Data Operations – Acquisition & Delivery
NeueHealth
ETLSQL
Job Level
Mid-LevelSenior
Tech Stack
ETLSSIS
About the role
- Acts as a lead developer and designer for the data warehouse team.
- Designs, develops, tests, and maintains applications and processes to parse, extract, transform, and load data from multiple data sources to the data warehouse.
- Develops ETL/ELT processes and models for parsing, extracting, and loading data.
- Documents, tests, and debugs data programs prior to implementation in the live production environment using standard testing and validation protocols.
- Groups and summarizes data to optimize performance for scheduled processes and end user reporting.
- Develops, maintains, and supports the data warehouse data structures and ETL/ELT processes.
- Develops complex data feeds and reports for external and internal clients as requested.
- Questions users to determine fields and array of data needed to fulfill requests.
- Creates and documents reports.
- Builds dynamic end user reporting systems to generate standard scheduled reports and easy interface functionality for ad hoc reporting needs.
- Mentors less experienced team members to develop their skills.
- Acts as a resource for the team by providing advice and guidance on programming issues and concerns.
- Brainstorms solutions with the team and provides feedback as needed.
- Develops data integration processes and procedures for transforming, extracting, and loading data between the data warehouse and other internal data systems.
- Fosters close working relationships with project management and end users to design efficient data driven solutions.
- Assists with managing the workload of the team by assigning projects and tasks for the group.
- Performs other related duties as assigned.
Requirements
- An undergraduate degree in a related field or an equivalent combination of training and experience.
- A minimum of 5 years of experience in data warehouse design and development, report writing, and ETL development.
- Previous financial services industry experience is a plus.
- Experience with Snowflake, SnowSQL, and ETL/ELT tools.
- Experience with dbt and SSIS a plus.
- Understanding of data governance and data quality best practices.
- Excellent verbal, written, and interpersonal communication skills.
- A team player, able to work effectively in a team fostered, multi-tasking environment.
- Background & EEO Statement: successfully passing a background check including credit, criminal, education, employment, OFAC, and social media background history.
