What are the responsibilities and job description for the ETL Data Warehouse Developer Level 3 position at My3Tech?
Hello
Hope youre 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 (seniorlevel) 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 indepth thorough and accurate reporting or ad hoc analysis as needed
Contributes to the longterm 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
Key Skills
SQL,Pentaho,PL / SQL,Microsoft SQL Server,SSIS,Informatica,Shell Scripting,T Sql,Teradata,Data Modeling,Data Warehouse,Oracle
Employment Type : Full Time
Vacancy : 1
