ETL/ Data Warehouse Developer Level 3 @ Austin, TX (Onsite)

Hello,

Hope you're doing well,

Position : ETL / Data Warehouse Developer Level 3

Location : Austin, TX (Onsite)

Duration : Long Term

Client : Loblolly / State of Texas

Job Description :

The Employees Retirement System of Texas requests the services of 1 ETL / Data Warehouse Developer Level 3.

General Description :

Performs highly advanced (senior-level) ETL / data warehouse development work as part of a small, but vital data management team. Diverse responsibilities include data modeling, ETL, data quality, development of data sources, performance testing, and maintenance responsibilities around existing data warehouse.

Duties and Responsibilities

Essential Functions :

Performs advanced ETL / data warehouse architectural work including data warehouse design,

data modeling, and metadata design

Works closely with business SMEs to reverse engineer the rules that govern business

processes, corresponding data streams, and associated source systems

• Translates business needs into high level technical designs for business intelligence solutions;

applies rapid iterative development methodologies as appropriate to ensure the solution keeps

pace with business needs

Perform in-depth, thorough, and accurate reporting or ad hoc analysis as needed

Contributes to the long-term vision of the ETL / enterprise data warehouse (EDW) by delivering

Agile solutions

Develops efficient ETL for loading the data warehouse and makes timely data available for

business users

Assists in capturing processes, procedures and other metadata in documentation; ensures that

documentation is well organized, complete, and appropriate for the audience

Troubleshoots, supports and maintains the data warehouse and associated tools used by the

team

Contributes to and follows best practices established by the governance council, data stewards

and enterprise data officer

Develops and improves continuous release and testing processes

Designs, deploys, and manages standardized, centralized data sources for agency reporting

Helps to establish best practices for development, testing, migration and error handling

Implements and maintains business intelligence security best practices including those related

to HIPAA

Participates in the training of junior developers

Performs other duties as assigned

Experience and Training :

3 years

of hands on experience in data warehouse development

3 years

of hands on experience in ETL development (creating automated processes and troubleshooting issues)

3 years

of hands on experience moving and manipulating large data sets

2 years

of hands on experience dimensional modeling for data warehouses

Preferred Qualifications :

Experience in health / life insurance, accounting and financials, or investment data related activities.

Experience with data tools (i.e. Alteryx, Visual Studio, SSIS, MSSQL )

Experience with Azure and agile iterations

Experience with ERP applications (i.e. PeopleSoft, Safyr, etc.)

Knowledge of health care claims data