Senior Data Warehouse Engineer for BI & Analytics

Eccalon, LLC; Detroit (MI); On-site; USD 120,000 - 160,000; Full time

Job summary

Eccalon, LLC in Detroit seeks a highly skilled Database Engineer to design, build, optimize, and maintain large-scale analytical databases for reporting, BI, and advanced analytics.

The role focuses on dimensional modeling, SQL performance tuning, ELT/ETL pipelines, data correctness, and governance across cloud and on-premises data warehouses. Collaboration with analytics, product, and finance teams is essential.

Qualifications

• Bachelor's degree or equivalent experience.
• 5+ years as Database/Data/Warehouse Engineer.
• Expert-level SQL for large datasets.
• Strong analytics and BI data modelling experience.
• Experience with Snowflake/Redshift/BigQuery/Azure Synapse.

Responsibilities

• Data Warehouse architecture, design and optimization.
• Develop and manage dimensional models (star/snowflake).
• Translate requirements to scalable schemas and pipelines.
• Tune performance of large analytical workloads.
• Manage ELT/ETL pipelines and data ingestion.
• Implement partitioning, indexing, and data governance.

Skills

SQL performance tuning

Data warehousing design

Dimensional modeling

Cloud data warehouses

Data governance

ETL/ELT tooling

BI tools familiarity

SQL strong programmer

Performance optimization

Education

Bachelor’s degree in Computer Science or related field

Tools

Snowflake

Amazon Redshift

Google BigQuery

Azure Synapse

Tableau / Looker / Power BI

ETL orchestration tools

Job description

Eccalon, LLC in Detroit seeks a highly skilled Database Engineer to design, build, optimize, and maintain large-scale analytical databases for reporting, BI, and advanced analytics.

The role focuses on dimensional modeling, SQL performance tuning, ELT/ETL pipelines, data correctness, and governance across cloud and on-premises data warehouses. Collaboration with analytics, product, and finance teams is essential.