Colorado Manufacturing Jobs

Colorado Jobs

Job Information

VIVA USA Inc Snowflakes Lead Developer in Denver, Colorado

Req Ref No: AMCOSL10 Location: Denver, CO Duration: 12.0 months

Description

Description:

Snowflake data engineers will be responsible for architecting and implementing very large scale data intelligence solutions around Snowflake Data Warehouse.

A solid experience and understanding of architecting, designing and operationalization of large scale data and analytics solutions on Snowflake Cloud Data Warehouse is a must. Professional knowledge of Matillion and/or AWS Redshift is a must. Developing ETL pipelines in and out of data warehouse using combination of Python and Snowflakes SnowSQL Writing SQL queries against Snowflake. Developing scripts Unix, Python etc. to do Extract, Load and Transform data Working knowledge of AWS Redshift Provide production support for Data Warehouse issues such data load problems, transformation translation problems Translate requirements for BI and Reporting to Database design and reporting design. Understanding data transformation and translation requirements and which tools to leverage to get the job done Understanding data pipelines and modern ways of automating data pipeline using cloud based Testing and clearly document implementations, so others can easily understand the requirements, implementation, and test conditions.

Job Responsibilities:

• Be part of a development team to build and maintain the ETL processes • Analyze the needs and the environment to make sure the solution you're developing considers the current architecture and operating environment as well as future functionality and enhancements • Develop, test, debug, document and help operationalize various ETL applications leveraging industry best practices • Work closely and collaborate with various cross functional IT teams to identify, troubleshoot and fix data issues, and resolve data gaps that impact the fulfillment of the business's functional requirements • Lead team members and customers to gather and validate requirements as well as deliver features/enhancements • Collaborate with other functions involving architects, team leads and team members to architect and design solutions to meet functional and technical requirements • Responsible for writing complex SQL queries for mining of operational data

Required Skill

Minimum 1 year of designing and implementing a fully operational production grade large scale data solution on Snowflake Data Warehouse. 3 years of hands on experience with building productionized data ingestion and processing pipelines using Java, Spark, Scala, Python 2 years of hands on experience designing and implementing production grade data warehousing solutions on large scale data technologies such as Teradata, Oracle or DB2 Expertise and excellent understanding of Snowflake Internals and integration of Snowflake with other data processing and reporting technologies Excellent presentation and communication skills, both written and verbal Ability to problem solve and architect in an environment with unclear requirements.

Preferred Skills

Bachelor’s degree in Computer Science, Engineering, Technical Science or 3 years of technical architecture and build experience with large scale solutions. 2 years of hands on experience designing and implementing production grade data warehousing solutions on large scale data technologies such as Teradata, Oracle or DB2 Expertise and excellent understanding of Snowflake Internals and integration of Snowflake with other data processing and reporting technologies Excellent presentation and communication skills, both written and verbal Ability to problem solve and architect in an environment with unclear requirements . A solid experience and understanding of architecting, designing and operationalization of large scale data and analytics solutions on Snowflake Cloud Data Warehouse is a must. Some experience in designing and developing efficient and robust ETL/ELT workflows using tools such as Metillion, Informatica, Ab Initio, Talend or Apache Spark if above experience is not available. Experience in Linux/UNIX scripting and SQL Experience with Healthcare space

VIVA is an equal opportunity employer. All qualified applicants have an equal opportunity for placement, and all employees have an equal opportunity to develop on the job. This means that VIVA will not discriminate against any employee or qualified applicant on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.

DirectEmployers