| Need -- Snowflake Data Engineer -- Okemos, MI at Snowflake, Arizona, USA |
| Email: [email protected] |
| 12-month contract, hybrid (address below), can pay up to $55/hr on c2c 4100 Okemos Rd, Okemos, Michigan, 48864-3215, United States Top Skills' Details Top 3 skills after qualifying with the manager: 1) SNOWFLAKE (this is by far the most important for this role), more specifically experience with StreamSets! 2) TSQL and PLSQL 3) Knowledge and experience for ETL of large data sets into Snowflake! - Database Platforms: Snowflake, Oracle, and SQL Server - OS Platforms: Linux OS and Windows Server - Languages and Tools: PL/SQL, Python, T-SQL, StreamSets, Snowflake Streams and Tasks, and Informatica PowerCenter, DBeaver - Drive and desire to automate repeatable processes. - Excellent interpersonal skills and communication, as well as the willingness to collaborate with teams across the organization. Secondary Skills - Nice to Haves Python Job Description The candidate will be a part of a team that creates data pipelines that use change data capture (CDC) mechanisms to move data to a cloud provider and then transform data to make it available to Customers to consume. The Data Engineering Team also does general extraction, transformation, and load (ETL) work, along with traditional Enterprise Data Warehousing (EDW) work. Additional Skills & Qualifications - Participates in the analysis and development of technical specifications, programming, and testing of Data Engineering components. - Participates creating data pipelines and ETL workflows to ensure that design and enterprise programming standards and guidelines are followed. Assist with updating the enterprise standards when gaps are identified. - Follows technology best practices and standards and escalates any issues as deemed appropriate. Follows architecture and design best practices (as guided by the Lead Data Engineer, BI Architect, and Architectural team). - Responsible for assisting in configuration and scripting to implement fully automated data pipelines, stored procedures, and functions, and ETL workflows that allow for data to flow from on-premises Oracle databases to Snowflake where the data will be consumable by our end customers. - Follows standard change control and configuration management practices. - Participates in 24-hour on-call rotation in support of the platform. Employee Value Proposition (EVP) The Data Engineering team at Delta Dental is working on some great projects! One in particular, that this person will be helping with, is the move from their on-prem data center environment to their cloud Data Warehouse (Snowflake). This is a long term role and no end in sight. Work Environment This position is required to be onsite at least 2 days/week in Okemos, MI (just outside Lansing) and DDMI corporate offices. They work in a collaborative environment and all SAFe Agile. This person will work on their Data Engineering team with a handful of other Engineers, Scrum Master and Product Owners. Business Drivers/Customer Impact DDMI finally got the approval to move their customer data to a cloud environment and that is the reason for this project. Why is the position open(provide details) New velocity needed to get this work done! -- Keywords: business intelligence information technology procedural language Michigan Need -- Snowflake Data Engineer -- Okemos, MI [email protected] |
| [email protected] View all |
| Tue Apr 30 23:59:00 UTC 2024 |