Job Title: Data Analyst - ETL
Duration: 12+ Months
Location: Remote
Contractor’s Key Person shall:
- Perform analysis of Client’s data system as needed, which may include reviewing documentation and analyzing current system/ environment, including data models, schemas and tables, data dictionaries, ETL’s, system and database management processes, data quality, security, queries, reporting environment.
- Work with client’s project team members (PM, BAs, DBAs, data analysts, architects), and users to identify/ determine business/technical requirements.
- Gather and document detailed system, data and integration requirements for system improvements (e.g. changes to ETL code, business rules, HAL tables, new or updated OHG Medicaid claim code grouping categories, etc.)
- Design, develop and implement new ETL code/ packages.
- Migrate existing ETL process built in legacy SAS coding to Microsoft Structured Query Language (“SQL”) stack language/ stored procedures, by:
- Woking with various program areas and business teams to make code as modular as possible.
- Reviewing and analyzing existing ETL SAS programming code to update to new SQL language/ procedures
- Developing new SQL stack / stored procedures programming code to create new ETL processes.
- Test, troubleshoot and implement the new ETL code in the HAL test and production environments.
Equal Opportunity Employer
We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.