Senior Data Warehouse Engineer - Cloud Analytics & BI

Appone; Detroit (MI); On-site; USD 110,000 - 170,000; Full time

Job summary

Eccalon is seeking a highly skilled Database Engineer with deep expertise in Data Warehousing to design, build, optimize, and maintain large-scale analytical databases that support reporting, BI, and advanced analytics. You will ensure data correctness, performance, and reliability across warehouse platforms.

The ideal candidate has strong experience with dimensional modeling, SQL performance tuning, ELT/ETL pipelines, and cloud or on-prem data warehousing technologies, collaborating with

Qualifications

• Bachelor’s degree or equivalent experience in a related field.
• 5+ years of experience as a Database Engineer, Data Engineer, or Data Warehouse Engineer.
• Expert-level SQL skills and experience with large datasets.
• Strong background designing and operating data warehouses for analytics and BI.
• Experience with cloud data warehouses: Snowflake, Redshift, BigQuery, Azure Synapse.
• Experience with ELT/ETL tools and orchestration frameworks.
• Familiarity with BI tools (Tableau, Power BI, Looker).
• Knowledge of data modeling methodologies (Kimball, Inmon).
• Understanding of data partitioning, compression, and workload management.

Responsibilities

• Data Warehouse Architecture & Design: design, implement, and maintain enterprise-grade data warehouse architectures.
• Data Development & Optimization: write and optimize SQL queries, views, and procedures; tune performance.
• Data Integration & Pipelines: support ELT/ETL pipelines and data ingestion from sources.
• Platform Operations & Governance: monitor performance, set access controls, and governance.
• Collaboration & Leadership: work with analytics, product, finance, and BI teams; mentor junior engineers.

Skills

SQL

Data Warehousing

ETL/ELT

Data Modeling

Cloud Platforms

Education

Bachelor’s degree in Computer Science or related field

Tools

Snowflake

Redshift

BigQuery

Azure Synapse

Teradata

Oracle

SQL Server

Vertica

Greenplum

Job description

Eccalon is seeking a highly skilled Database Engineer with deep expertise in Data Warehousing to design, build, optimize, and maintain large-scale analytical databases that support reporting, BI, and advanced analytics. You will ensure data correctness, performance, and reliability across warehouse platforms.

The ideal candidate has strong experience with dimensional modeling, SQL performance tuning, ELT/ETL pipelines, and cloud or on-prem data warehousing technologies, collaborating with