Sr. Data Engineer (ETL & ELT)

Sr. Data Engineer (ETL & ELT)

ESSENTIAL FUNCTIONS:
- 20% Develops and maintains infrastructure systems (e.g., data warehouses, data lakes) including data access APIs. Prepares and manipulates data using multiple technologies.


- 15% Interprets data, analyzes results using statistical techniques, and provides ongoing reports. Executes quantitative analyses that translate data into actionable insights. Provides analytical and data-driven decision-making support for key projects. Designs, manages, and conducts quality control procedures for data sets using data from multiple systems.


- 15% Develops data models by studying existing data warehouse architecture; evaluating alternative logical data models including planning and execution tables; applying metadata and modeling standards, guidelines, conventions, and procedures; planning data classes and sub-classes, indexes, directories, repositories, messages, sharing, replication, back-up, retention, and recovery.


- 15% Creates data collection frameworks for structured and unstructured data.


- 15% Improves data delivery engineering job knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking state-of-the-art practices; participating in professional societies.


- 10% Applies data extraction, transformation and loading techniques in order to connect large data sets from a variety of sources.


- 10% Applies and implements best practices for data auditing, scalability, reliability and application performance.

Required Skills


- BS Degree in Computer Science, Information Technology or Engineering or related field (In lieu of a Bachelor's degree, an additional 4 years of relevant work experience is required in addition to the required work experience.
- 5 years Experience with database design and developing modeling tools. Experience developing and updating ETL/ELT scripts.
- Hands-on experience with application development, relational database layout, development, data modeling.
- Strong technical and analytical and problem solving skills to troubleshoot to solve a variety of problems.,
- Requires strong organizational and communication skills, written and verbal, with the ability to handle multiple priorities.
- Healthcare payor industry experience is a big plus


Preferred Qualifications
Knowledge, Skills and Abilities (KSAs)
Knowledge and understanding of at least one programming language (i.e., SQL, NoSQL, Python).
Knowledge and understanding of database design and implementation concepts.
Knowledge and understanding of data exchange formats.
Knowledge and understanding of data movement concepts.