What are the responsibilities and job description for the ERS (ERS EDWD) ETL/ Data Warehouse Developer 3 position at My3Tech?
Job Details
Hello,
Hope you are doing well,
Hope you are doing well,
Position: ERS (ERS EDWD) ETL/ Data Warehouse Developer 3
Location: Austin, TX (Onsite)
Duration: Long term
Client: Loblolly/State of Texas
Client: Loblolly/State of Texas
Job Description:
Please submit resumes only for candidates who are currently based in Austin or are willing to relocate to the area
** All travel, per diem, parking, and/or living expenses shall be at the worker's and/or Vendor's expense. **
(Resume and Photo ID required: For the safety and security of our clients and their systems, any candidate resume submitted must also include a photo ID of the candidate. Any candidate resume submitted without a photo ID will be eliminated from potential selection for the role.) Please place this at the beginning of the resume when submitting the resume.
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
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 |
Thanks & Regards.
An E-Verify Company
DISCLAIMER: The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, re-transmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer or if you want to be REMOVED please reply with REMOVE in the Subject line of this email.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
