ETL Data Warehouse Developer/Analyst, Austin TX (Onsite) ONLY LOCAL

NO H1B,CPT,OPT

Austin TX (Onsite) ONLY LOCAL

Rate-$50/hr on c2c

Hi,

Hope you are doing Good!!!

Please find the attached Job Description. If you feel comfortable then please send me your updated resume or call me back on 512-898-7112.

Position: ETL Data Warehouse Developer/Analyst

Location: Austin TX (Onsite), willing to come to Austin and willing to do both steps of the interview process)

Duration: 12 Months Contract

Interview Process: 1 hour video interview.

If they like person before they extend offer candidate will need to agree to go on site and meet the teams and hiring manager there. If it's good they can receive an offer to start.

Job Description:

Essential Functions:

As a Data Warehouse Developer/Analyst, the worker will function as a part of a team and must have the following skills:

• Performs advanced 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 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 (i.e. SQL servers)
• 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
• Performs other duties as assigned

Essential Work Behaviors:
• Communicates respectfully and works harmoniously with all co-workers, customers, and vendors.
• Provides exceptional customer service
• Is flexible; able to work under pressure and; able to adapt to change; and able to work on multiple problems and tasks.
• Takes initiative to prevent and solve problems.

Qualification Requirements
Education/Special Requirements:
• Bachelor’s degree in computer science, engineering, statistics, economics, finance, library science, or related business field.

Experience and Training
• Three (3) years of hands on experience in data warehouse development (i.e. WhereScape, etc.)
• Three (3) years of hands on experience in SQL server ETL development (creating automated processes and troubleshooting issues) using services like
SSIS, SSRS, SSAS
• Three (3) years of hands on experience moving and manipulating large data sets
• Two (2) years of hands on experience dimensional modeling for data warehouses
• Three (3) years of hands on experience around documentation of standards, best practices, and governance as it relates to data warehouse development
• Two (2) years of hands on experience in Generative AI and Alteryx

Preferred Qualifications
• Experience in health/life insurance, benefits, accounting and financials, or investment data related activities
• Experience with data tools (i.e. Alteryx, Visual Studio, SSIS, MSSQL, WhereScape )
• Experience with Azure and agile iterations
• Experience with ERP applications (i.e. PeopleSoft, Safyr, etc.)
• Knowledge of health care claims data (i.e. HIPAA data)
• Experience troubleshooting performance in SQL servers