Overview
On Site
BASED ON EXPERIENCE
Contract - Independent
Contract - W2
Skills
Information Technology
Computer Science
Data Analysis
Finance
SAP BASIS
Data Engineering
Analytics
Data Warehouse
Cloud Computing
Migration
Collaboration
Data Architecture
WebFOCUS
Mainframe
FOCUS
Transact-SQL
SQL
ELT
Extract
Transform
Load
Streaming
Informatica
Orchestration
Reporting
Microsoft Power BI
Tableau
Data Governance
Access Control
Caching
Clustering
Instructional Design
Knowledge Transfer
Snow Flake Schema
Job Details
Education:
Bachelor's Degree in a field of study related to Information Technology, Computer Science, Data Analytics, or Finance. Work experience may substitute on a year-for-year basis for the degree.
Experience:
Candidate must have a minimum of 3 years of experience in data engineering, analytics, or cloud data warehousing, with at least 2 years of hands-on experience designing and implementing solutions using the Snowflake Data Cloud platform.
Primary Job Duties/ Tasks:
The submitted candidate must be able to perform the following duties and/or tasks. Duties of the selected candidate will include, but not be limited to:
- Analyze the current data environment, including data sources, pipelines, and legacy structures, to determine required transformations and optimal migration strategies into Snowflake.
- Collaborate with stakeholders and data architects to design and implement scalable, secure, and cost-effective data architecture using Snowflake.
- Re-engineer legacy reporting logic (e.g., WebFOCUS, Mainframe FOCUS, and T-SQL) by translating them into Snowflake SQL and optimizing performance.
- Develop and automate ELT/ETL data pipelines using Snowflake's native features and tools such as Snowpipe, Streams, Tasks, Informatica, and integration with external orchestration tools (e.g., dbt, Airflow).
- Partner with analysts and business users to build efficient, reusable data models and secure views within Snowflake that support downstream reporting (e.g., Power BI, Tableau, or Looker).
- Optimize query performance and data governance by implementing best practices in Snowflake for security, access control, caching, clustering, and cost monitoring.
- Support training, documentation, and knowledge transfer to internal teams, ensuring smooth adoption and use of Snowflake-based solutions.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.