An employer is looking for a Snowflake Data Engineer/Modeler for a remote, direct-hire opportunity. The Data Engineer will build strong relationships with business partners and internal (IT) teams while delivering sustainable solutions. The Health and Wellness data team is building a central data warehouse in snowflake and migrating their other data warehouses into this one while adhering to industry data standards for their data models
* Develop a high-quality codebase, lead design discussions, execute development against design, and navigate complex codebase
* Responsible for development implementation of technical design within a defined set of teams. Execute against defined technology roadmap to
* support project portfolio and business strategy
* Participate in implementing enterprise standards across domains: operations, infrastructure, data, applications, development, security & risk, and
* business continuance
* Provide technical clarity between ongoing projects and the strategic objectives of the company
* Drive digital innovation by leveraging innovative new technologies and approaches to renovate, extend, and transform the existing core technology
* base and IT estate
* Implement high-level migration plans to address the gaps between the current and future state solution
* Lead the analysis of the technology environment to detect critical deficiencies and recommend solutions for improvement
* Mentor team members in software development principles, patterns, processes and, practices
* Must be able to perform the essential job functions of this position with or without reasonable accommodation
3 to 5 years' experience in Data Engineering/Modelling and developing data architectures
3+ years with Snowflake for data modeling and engineering
Experience with Azure Data Factory (ADF) pipelines and developing Databricks
Experience design and maintaining data pipelines and data integration using snow pipe
Develop and maintain data quality and data governance processes, data warehouse monitoring and alerting solutions, and backup and recovery processes
Experience across data platforms such as Oracle and SQL
Experience in designing data solutions in Azure including data distributions and partitions scalability, disaster recovery and high availability.
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.