Data warehouse engineer • usa
Data Warehouse Engineer</b></p> <p style="text-align:start; text-indent:0px; -webkit-text-stroke-width:0px"><b>Location: </b><b>Phoenix, AZ / Wheeling,... Show more
Job Summary: <p>The Data Warehouse Architect (Level 5) role involves designing, implementing, and supporting modern enterprise data platforms and analytics solutions for the State of Michigan... Show more
Job Title: Data Warehouse Architect 5Job Location: Lansing, MI (Hybrid)Job Type: ContractJob Description/ Requirement:Minimum 12 years Teradata experience.Minimum 10 years SQL experience.Minimum 10... Show more
Join us as a Warehouse Engineer and make a tangible impact on operational excellence.You'll design strategies that improve safety, efficiency, and productivity while leading initiatives that transf... Show more
Data Platform Architect / Data Warehouse Architect </b><br /> <b>Lansing, MI</b> <b>Hybrid 2 days onsite </b></p> <p><b>Relocation works <... Show more
Title : Data Warehouse Architect 5 - Solutions Architect</p> <p>Location : Lansing MI</p> <p>Required Skills (Must haves):</p> <p>1.Minimum 5 years experience in... Show more
Our direct client has an opening for an Data Warehouse Developer 129720.This position is for up to 13 months with the option of extension, and the client is in Madison, WI.Alteryx experience... Show more
Job Title: Data Warehouse Architect 5.Responsible for complex Linux security model on DW ETL servers.Servers are administered by another group, but our team is responsible for the security structur... Show more
Profit Sharing & 401K, Paid Vacation & Holidays.Highly collaborative work environment.Monday – Friday work week.The Data Warehouse Developer is responsible for the design, development... Show more
The IT Director - Data Warehouse leads the enterprise data warehousing, reporting and analytics function, delivering accurate, timely and well-governed data to business, Finance and Risk partners.A... Show more
Months Contract on W2 Only, No C2C.Client s Server Automation team are currently seeking a highly skilled Data Warehouse Engineer to join our dynamic team.The ideal candidate will be instrumental i... Show more
Description We are recruiting for our client.Pointwest is seeking a highly skilled  Data Warehouse Analyst  to support the administration and optimization of the Informatica Intelligent D... Show more
Urgent Need For Data Warehouse PM.Has in-depth understanding of different processes and best practices of PM to find proactive solutions for complex situations and execute critical project.Knows st... Show more
Director, Data Warehouse Engineering.Mercury Insurance is looking for a Director, Data Warehouse Engineering to lead the strategy, architecture, and delivery of our enterprise data warehouse platfo... Show more
Provide senior subject matter expertise for Oracle data warehouse development and related technical strategies.Develop and support Oracle database objects, including PL/SQL, data views, triggers, a... Show more
Reporting and Data Warehouse Business Systems Analyst - Will support the data warehouse project manager, acting as a liaison between development team and users in gathering requirements, translatin... Show more
Tallahassee, Florida (5 days, onsite).This position does not support third-party submissions, subcontracting, or Corp-to-Corp (C2C) arrangements.Microsoft Power BI and Snowflake.This role is respon... Show more
The average salary range is between $ 110,443 and $ 168,875 year , with the average salary hovering around $ 128,644 year .
Data Warehouse Engineer
Location: Phoenix, AZ / Wheeling, WV - Hybrid
Job Type: Long Term Contract.
Role Overview
The Data Warehouse Engineer is responsible for developing, and supporting Snowflake-based data warehousing solutions. The role partners with Data Engineering, Analytics, and Reporting teams to build scalable data models, develop transformations, optimize performance, and support reporting requirements. The engineer contributes to platform stability, security, and operational support while following established architecture, governance, and development standards.
Key Responsibilities
Data Modeling & Architecture
Build enterprise level Snowflake models including conformed dimensions, fact tables, and semantic views.
Document ERDs, modeling assumptions, and physical/logical architectures.
Adhere to established data modeling standards, naming conventions, and performance optimization best practices.
Transformation & Automation
Develop, test, and support SQL transformations across Snowflake data warehouse layers using Snowflake SQL and dbt.
Develop and maintain dbt models and tests that support Informatica data pipelines, ensuring data quality, reliability, and successful deployment to Snowflake environments.
Implement and support Snowflake Tasks, Streams, stored procedures, and scheduled workflows.
Perform unit testing, integration testing, and validation of Snowflake objects and dbt deployments prior to production release.
Support schema changes, data integration activities, and production issue resolution in accordance with established standards.
Environment & Release Management
Participate in Snowflake schema and object deployments using established Git version control processes.
Perform testing and validation of models, views, stored procedures, and security changes prior to deployment.
Maintain source control, versioning, and change documentation for Snowflake database objects using Git.
Security, RBAC & Controls
Implement and maintain Snowflake security configurations, including role-based access controls (RBAC), object permissions, row-level security, and masking policies.
Support audit activities, compliance reviews, and evidence collection as directed by Director of Data Engineering.
Cost Management
Generate and maintain Snowflake consumption and usage reports to support cost monitoring and analysis.
Identify and communicate opportunities for improving warehouse utilization, storage efficiency, and query performance.
Cross Functional Collaboration
Work with Data Engineers to coordinate ingestion design, transformation logic, and schema updates.
Partner with BI teams to optimize datasets for Power BI, Qlik, and analytical tools.
Align with Platform Administrators on environment setup, migrations, and operational readiness.
Collaborate with Platform Administrators and the vendor to ensure reporting platform uptime and timely escalation of reporting issues.
Work with Data Governance teams to apply and validate data quality standards, data classifications, masking policies, and other governance requirements within Snowflake.
Skills & Tools Requirements
Snowflake SQL: 5+ years of advanced SQL development experience, including complex query optimization, data modeling, performance tuning, and ETL/ELT development within Snowflake environments.
Snowflake Administration: 3+ years of hands-on experience administering Snowflake platforms, including security, role-based access control (RBAC), warehouse management, monitoring, performance optimization, and cost governance.
dbt (Data Build Tool): 4+ years of experience designing, developing, and maintaining scalable data transformation frameworks using dbt, including testing, documentation, and CI/CD integration.
Git / Version Control: 5+ years of experience using Git-based source control systems (GitHub, GitLab, or Bitbucket) for collaborative development, branching strategies, code reviews, and release management.
CI/CD Pipelines & Deployment Automation: 5+ years of experience implementing and supporting CI/CD pipelines for data warehouse and analytics deployments, including automated testing, code promotion, release management, and deployment automation using Azure DevOps, GitHub Actions, GitLab CI/CD, or equivalent platforms
Financial services experience: Preferred.
Business Objects (SAP BO/Web Intelligence): Preferred.
