Join a data management and analytics team delivering modern data solutions for clients across a range of industries. As a Senior Snowflake Engineer, you will play a key role in building, optimizing, and maintaining robust data transformations and warehouse models using Snowflake.
Responsibilities
Build, develop, and optimize Snowflake SQL transformations across staging, curated, and conformed data layers
Implement tables, views, and transformation logic based on approved data models and source-to-target mappings
Develop restartable, testable, and maintainable data processing workflows with robust auditability and error handling
Implement patient and member identity matching logic, crosswalks, and exception handling for duplicate, unmatched, or conflicting records
Build and maintain dimensional models, including facts, dimensions, surrogate keys, and Slowly Changing Dimension Type 2 (SCD Type 2) history
Serve as a business partner to Universal Orlando leadership by supporting capacity management, admission access, and related planning across the destination.
Compensation
Your talent, skills and experience will be rewarded with a competitive compensation package.
Responsibilities
Manage and support capacity planning across key admission products and programs
Monitor demand, utilization, and available capacity
Develop forecasts and scenario analyses
Recommend capacity allocations and access controls
Collaborate with key stakeholders on block out dates
Develop advanced, dimensional models, calculations, hierarchies, and reusable business logic; develop and optimize Snowflake SQL supporting portfolio, position, transaction, security, benchmark, performance, and risk datasets; optimize Power BI solutions for performance, scalability, usability, and maintainability; troubleshoot complex reporting, data, semantic model, refresh, and performance issues; develop testing, reconciliation, monitoring, and data quality controls; support source control, automated deployment, and CI/CD practices for business intelligence solutions.
Responsibilities
Develop advanced, dimensional models, calculations, hierarchies, and reusable business logic.
Develop and optimize Snowflake SQL supporting portfolio, position, transaction, security, benchmark, performance, and risk datasets.
Optimize Power BI solutions for performance, scalability, usability, and maintainability.
Troubleshoot complex reporting, data, semantic model, refresh, and performance issues.
Develop testing, reconciliation, monitoring, and data quality controls to ensure reporting accuracy and reliability.
We are looking for a Senior Data Engineer with 4 to 5 years of experience to build data pipelines for an enterprise finance data platform on Azure, Databricks and Snowflake.
Responsibilities
Build ingestion pipelines from finance source systems using Azure Data Factory, change data capture, and API and event-driven feeds
Develop transformations in Databricks across the Bronze, Silver and Gold layers using PySpark and Spark SQL
Build conformed dimensions and fact tables to the agreed data model
Load certified Gold data into Snowflake and build the views used by reporting teams
Add data quality, reconciliation and logging checks to pipelines
This is a remote position.
Senior Data Engineer
Location: Eden Prairie, MN (100% Remote)
Employment Type: W2 Contract
Interview Process: Video Interview
Max Rate:$27/hr W2
Job Overview
We are seeking an experienced Senior Data Engineer with strong expertise in enterprise data warehousing, Azure Data Factory, Databricks, Snowflake, and healthcare data integration. The ideal candidate will have extensive hands-on experience developing ETL pipelines, designing data warehouse solutions, processing structured and unstructured data, and working with healthcare interoperability standards such as HL7 and FHIR.
Required Qualifications
8+ years of experience in Data Engineering, with a strong focus on data warehousing.
5+ years of hands-on experience with Azure Data Factory (ADF) and Databricks.
5+ years of ETL experience using Informatica PowerCenter, SSIS, or Azure Data Factory.
5+ years of experience with Oracle, Snowflake, or SQL Server.
5+ years of experience developing stored procedures using PL/SQL, T-SQL, or Snowflake SQL.
3+ years of Python programming experience.
3+ years of experience with Azure DevOps, GitHub, or SVN.
2+ years of experience working with structured and unstructured data.
Hands-on experience processing HL7 and FHIR files.
3+ years of experience preparing ETL specifications based on business and technical requirements.
3+ years of experience with batch scripting or PowerShell.
3+ years of experience in data warehouse modeling.
Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.