drjobs ERS ERS EDWD ETL Data Warehouse Developer 3

ERS ERS EDWD ETL Data Warehouse Developer 3

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Austin, TX - USA

Monthly Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

Hello
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
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 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:

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

Thanks & Regards.

An EVerify 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 retransmission 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.

Employment Type

Full Time

Company Industry

About Company

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.