Job Title: Snowflake Engineer/Administrator
Role type: Long-term Contract
Location: Hybrid - Austin, TX (One day a week onsite)
Job Description
- 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.
Requirement :
- Experience designing and developing complex Snowflake SQL scripts that are fast and efficient
- Experience administering Snowflake databases, data warehouses or data lakes, including implementing security, tuning and optimization, as well as troubleshooting
- Strong analytical and problem-solving skills with experience as a system analyst for a data analytics, performance management system, or data warehousing project.
- 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.
- Experience in planning and delivering software platforms used across multiple products and organizational units.
- Experience designing and developing scripts using Python
- Experience on an agile sprint team
- Experience with JIRA software
- Experience working with multiple teams concurrently, being able to prioritize and complete work on time with high quality
- Proven ability to write well designed, testable, efficient code by using best software development practices
- Understanding of security principles and how they apply to healthcare data
- Experience with state of the art software components for a performance metrics data visualization or business intelligence environment
- Excellent oral and written communication skills.
- Effectively manage multiple responsibilities, prioritize conflicting assignments, and switch quickly between assignments, as required.
- Bachelor’s degree in Computer Science, Information Systems, or Business or equivalent experience.
- Prior experience in the Healthcare Industry
- Prior experience working with PII or PHI data
- Prior experience working with HL7 data
- Prior experience with Azure