Home

Hybrid Position || Snowflake SQL Engineer || Austin , TX(Need Local Candidate of TX) at Austin, Texas, USA
Email: [email protected]
Email from Technix LLC

Direct client position

JobID: #

529501194

Position: Snowflake SQL Engineer

Duration: 10 months

Location: Austin , TX(Hybrid)

Agency : Texas Health and Human Services Commission

(Need Local Candidate of Texas )

DESCRIPTION OF SERVICES :

Texas Health and Human Services Commission requires the services of 1 Systems Analyst 3, hereafter referred to as Candidate(s), who meets the general qualifications of Systems Analyst 3, Applications/Software Development and the specifications outlined in this document for the All-work products resulting from the project shall be considered "works made for hire" and are the property of Texas Health and Human Services Commission.

The Department of Information Resources (DIR) requires the services of one (1) Snowflake Engineer/Administrator hereafter referred to as Worker, who meets the general qualification of Systems Analyst 3, Emerging Technologies and the specifications outlined in this document for Health and Human Services Commission (HHSC) Information Technology.   

HHSC IT is continuing to develop an HHS Performance Portal pilot initiative with a goal to accomplish the following:

  Implementation and configuration of the infrastructure for the performance portal pilot

Design, development, and implementation (DD&I) of the performance portal using an agile methodology for all standard SDLC phases that includes, but is not limited to:

   Validation of performance metric requirements

 Creation of Epics/User Stories/Tasks

Automation of data acquisition from a variety of data sources

   Development of complex SQL scripts

 Testing integration, load and stress

  Deployment / publication internally and externally

   Operations support and enhancement of the Performance Portal pilot

This development effort will utilize an agile methodology based upon the approach currently in use at HHSC for the Texas Integrated Eligibility Redesign System (TIERS). As a member of the agile development team, the worker responsibilities may include:

Data acquisition from a variety of data sources for multiple uses.

Developing complex SQL scripts to transform the source data to fit into a dimensional model, then to create views and materialized views in Oracle.

Administering multiple Snowflake databases, including managing access, creating schemas, creating, updating and deleting tables, and monitoring use.

  Collaborating with other members of the Data Engineering Team on the design and implementation of an optimal data design.

Verification and validation of SQL scripts and database views.

Developing automated means of performing verification and validation.

 Participating in all sprint ceremonies

Work closely with the Architects and Data Engineering Team on implementation designs and data acquisition strategies.

 Develop mockups and work with customers for validation

Working closely with other members of the team to address technical problems

Assisting with the implementation and configuration of developmental tools

 Producing and maintaining technical specifications, diagrams, or other documentation as needed to support the DD&I efforts

Participation in requirements and design sessions

   Interpreting new and changing business requirements to determine the impact and proposing enhancements and changes to meet these new requirements

 All other duties as assigned.

CANDIDATE SKILLS AND QUALIFICATIONS :

Required 8 years Experience designing and developing complex
Snowflake SQL scripts
that are fast and efficient

 Required 8 years Experience administering
Snowflake databases, data warehouses or data lakes, including implementing security, tuning and optimization,
as well as troubleshooting

    Required 8 years  experience in Strong analytical and problem-solving skills with experience as a system analyst for a data analytics, performance management system, or data warehousing project.

 Required 8 years  experience in Technical writing and diagraming skills, including proficiency with modeling and mapping tools (e.g., Visio, Erwin), and the
Microsoft Office Suite (Word, Excel, and PowerPoint) and MS Project.

 Required 8 years  Experience in planning and delivering software platforms used across multiple products and organizational units.

   Required 8 years  Experience designing and developing scripts using
Python

     Required 8 years  Experience on an
agile sprint team

Required 8 years  Experience with
JIRA software

   Required 8 years  Experience working with multiple teams concurrently, being able to prioritize and complete work on time with high quality

 Preferred  6 years experience in Proven ability to write well designed, testable, efficient code by using best software development practices

   Preferred  4 years experience in  Understanding of security principles and how they apply to healthcare data

   Preferred  4 years  Experience with state-of-the-art software components for a performance metrics data visualization or business intelligence environment

Preferred  4 years experience in Excellent oral and written communication skills.

Preferred  4 years experience in Effectively manage multiple responsibilities, prioritize conflicting assignments, and switch quickly between assignments, as required.

 Preferred  4 years experience in Bachelors degree in Computer Science, Information Systems, or Business or equivalent experience.

  Preferred  3 years experience in Prior experience in the Healthcare Industry

 Preferred  2 years experience in Prior experience with an HHS agency

Preferred  2 years experience in Prior experience working with PII or PHI data

Preferred  2 years experience in Prior experience working with HL7 data.

 Preferred  2 years experience in  Prior experience with Azure

Thanks,

PRATIIK DESHMUUKH

TECHNICAL RECRUITER

Mail:
 [email protected], www.technixonline.com

Direct: 480-389-2903

Phoenix, AZ, 85050

Technix LLC |
Phoenix, AZ
|
phoenix, AZ 85050 US

|

Update Profile
|

Constant Contact Data Notice

Keywords: information technology microsoft Arizona Texas
Hybrid Position || Snowflake SQL Engineer || Austin , TX(Need Local Candidate of TX)
[email protected]
[email protected]
View all
Tue Oct 08 01:56:00 UTC 2024

To remove this job post send "job_kill 1820590" as subject from [email protected] to [email protected]. Do not write anything extra in the subject line as this is a automatic system which will not work otherwise.


Your reply to [email protected] -
To       

Subject   
Message -

Your email id:

Captcha Image:
Captcha Code:


Pages not loading, taking too much time to load, server timeout or unavailable, or any other issues please contact admin at [email protected]
Time Taken: 9

Location: Austin, Texas