EDW Migration Specialist/Snowflake Data Engineer - ON SITE

Company and Role:

Dedicated Tech Services, Inc. (DTS) is an award-winning IT consulting firm based in Columbus, OH. We now have an opening for EDW Migration Specialists/Snowflake Data Engineers to work as our direct W2 salaried or hourly employees while working for our client in a potential long-term, multi-year contract position.

Highlights and Benefits:

• On site
• W2 hourly pay rate up to $72/hr or salaried equivalent
• Collaborative, customer-focused client culture
• Direct W2 hourly or salaried applicants only (no corp-to-corp subcontractors, third parties, or agencies)
• Paid time off and holidays for salaried employees
• 401K, billable bonus, and health, life, vision, dental and short-term disability insurance options for all
• DTS is a proud Women Business Enterprise (WBE) and Woman Owned Small Business (WOSB)!
• Check out our benefits and company information at !

Job Description:

We are hiring multiple EDW Migration Specialists/Snowflake Data Engineers. You will work for our client, a state government agency, and will be responsible for migrating the current data, framework and programs from the client's EDW IOP Big Data environment to the client's EDW Snowflake Cloud-Based Data Warehouse environment. You will also be involved in the client's Enterprise Data Warehouse design, development, implementation, migration, maintenance and operation activities. You will also:

• Serve as one of the key technical resources for ingesting the data to the client's EDW Snowflake environment and to build new or support existing data warehouses and data marts for data analytics and exchange with state government partners.
• Be a member of the client's ITS team and work closely with the Business Intelligence & Data Analytics team.
• Participate in team activities, design discussions, stand-up meetings and planning review with team.
• Provide Snowflake database technical support in developing reliable, efficient, and scalable solutions for various projects on Snowflake.
• Ingest the existing data, framework and programs from ODM EDW IOP Big data environment to the ODM EDW Snowflake environment using the best practices.
• Design and develop Snowpark features in Python, understand the requirements and iterate.
• Interface with the open-source community and contribute to Snowflake's open-source libraries including Snowpark Python and the Snowflake Python Connector.
• Create, monitor, and maintain role-based access controls, virtual warehouses, tasks, Snow pipe, and Streams on Snowflake databases to support different use cases.
• Perform performance tuning of Snowflake queries and procedures and recommend and document the best practices of Snowflake.
• Explore the new capabilities of Snowflake, perform POC and implement them based on business requirements.
• Create and maintain the Snowflake technical documentation, ensuring compliance with data governance and security policies.
• Implement Snowflake user /query log analysis, History capture, and user email alert configuration.
• Enable data governance in Snowflake, including row/column-level data security using secure views and dynamic data masking features.
• Perform data analysis, data profiling, data quality and data ingestion in various layers using Big Data/Hadoop/Hive/Impala queries, PySpark programs, and UNIX shell scripts.
• Follow the organization coding standard document, Create mappings, sessions and workflows as per the mapping specification document.
• Perform gap and impact analysis of ETL and IOP jobs for the new requirement and enhancements.
• Create mockup data, perform Unit testing and capture the result sets against the jobs developed in lower environment.
• Update the production support Run book, Control M schedule document as per the production release.
• Create and update design documents, provide detail description about workflows after every production release.
• Continuously monitor the production data loads, fix the issues, update the tracker document with the issues, Identify the performance issues.
• Performance tune long-running ETL/ELT jobs by creating partitions, enabling full load and other standard approaches.
• Perform quality assurance check, Reconciliation post data loads and communicate to vendor for receiving fixed data.
• Participate in ETL/ELT code review and design re-usable frameworks.
• Create change requests, workplan, test results, BCAB checklist documents for the code deployment to production environment and perform the code validation post deployment.
• Work with Snowflake Admin, Hadoop Admin, ETL and SAS admin teams for code deployments and health checks.
• Create re-usable framework for Audit Balance Control to capture reconciliation, map parameters and variables, and serve as single point of reference for workflows.
• Create Snowpark and PySpark programs to ingest historical and incremental data.
• Create SQOOP scripts to ingest historical data from EDW oracle database to Hadoop IOP, created HIVE tables and Impala views creation scripts for dimension tables.
• Participate in meetings to continuously upgrade the Functional and technical expertise.

Required Skills and Experience:

• Very strong proficiency and professional experience in data warehousing, data migration, and the Snowflake Cloud-Based Data Warehouse is essential for this role.
• Strong experience in the implementation, execution, and maintenance of data integration technology solutions.
• Minimum of 4-6 years of hands-on professional experience with cloud databases.
• Minimum 2-3 years of hands-on professional data migration experience from a Big Data environment to the Snowflake Cloud-Based data warehouse environment.
• Experience in using and working with Snowpark to build data pipelines and applications in Snowflake Cloud.
• Professional experience in creating PySpark programs.
• Professional experience in creating SQOOP scripts

Those authorized to work in the US are encouraged to apply. We are unable to sponsor at this time.

Dedicated Tech Services, Inc. is an Equal Opportunity Employer