ETL Data Warehouse Developer 3
ETL Data Warehouse Developer 3
Posted on :
11-02-2025
Employer Active
1 Vacancy
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Share
Send me jobs like this
Job Alert
You will be updated with latest job alerts via emailValid email field required
Send jobs
Monthly Salary
Not Disclosed
Salary Not Disclosed
Vacancy
1 Vacancy
Posted on :
11-02-2025
Job Description
Hello All
*** Greetings from My3tech ***
Role: ERS (ERS EDWD) ETL/ Data Warehouse Developer 3
Location: Onsite(Austin TX)
Client: Texas Employee retirement systems
** All travel per diem parking and/or living expenses shall be at the workers and/or Vendors 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 (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:
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
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
Employment Type
Full Time
Key Skills
Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.
