Database Engineer - onsite

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

Job summary

Eccalon, LLC in Detroit seeks a Database Engineer to design and maintain large-scale data warehouses supporting reporting, BI, and analytics. You will ensure data correctness, performance, and reliability across platforms.

Ideal candidates have expertise in dimensional modeling, SQL tuning, ELT/ETL pipelines, and cloud or on‑prem warehousing technologies, collaborating with data engineers and BI teams to enable data-driven decisions.

Qualifications

• Bachelor’s degree or equivalent experience in CS/Engineering/IS or related field.
• 5+ years as Database/Data/ Warehouse Engineer.
• Expert SQL skills for large datasets.
• Experience designing data warehouses for analytics/BI.
• Cloud or on-prem data warehousing platforms.

Responsibilities

• Design, build, and maintain enterprise‑scale data warehouse architectures.
• Develop and manage dimensional data models (star, snowflake, fact tables).
• Write and optimize complex SQL queries, views, and stored procedures.
• Tune performance for large analytics workloads; implement partitioning and indexing.
• Ensure high availability, backup, DR readiness, and data governance.
• Support and optimize ELT/ETL pipelines; ensure reliable data ingestion.
• Collaborate with analytics/BI teams and stakeholders to enable data readiness.

Skills

SQL

Data warehousing

Dimensional modeling

Performance tuning

ELT/ETL

Education

Bachelor’s degree in Computer Science, Engineering, Information Systems, or related field (or equivalent experience)

Tools

Snowflake

Amazon Redshift

Google BigQuery

Azure Synapse

Job description

We are 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, business intelligence, and advanced analytics use cases. This role is responsible for ensuring data correctness, performance, scalability, and reliability across enterprise data warehouse platforms. The ideal candidate has strong experience with dimensional modeling, SQL performance tuning, data pipelines, and modern cloud or on‑prem data warehousing technologies.

Responsibilities

• Data Warehouse Architecture & Design
• Design, implement, and maintain enterprise‑grade data warehouse architectures
• Develop and manage dimensional data models (star, snowflake, fact and dimension tables)
• Translate business and analytical requirements into scalable data schemas
• Support historical, slowly changing dimensions (SCD), and aggregations
• Database Development & Optimization
• Write and optimize complex SQL queries, views, materialized views, and stored procedures
• Tune database performance for large‑scale analytical workloads
• Implement partitioning, indexing, clustering, and distribution strategies
• Ensure high availability, backup, recovery, and disaster‑recovery readiness
• Support and optimize ELT/ETL pipelines feeding the data warehouse
• Collaborate with data engineers to ensure reliable ingestion from source systems
• Validate data quality, consistency, and integrity across datasets
• Partner with analytics and BI teams to ensure data readiness and usability
• Platform Operations & Governance
• Monitor and maintain warehouse performance, cost, and usage efficiency
• Implement data access controls, security policies, and governance standards
• Maintain documentation for schemas, metrics, and data definitions
• Support audit, compliance, and data lineage requirements
• Work closely with analytics, product, finance, and business stakeholders
• Provide guidance on best practices for querying and modeling
• Contribute to architectural discussions and platform evolution
• Mentor junior database or data engineers when applicable

Required Qualifications

• Bachelor’s degree in Computer Science, Engineering, Information Systems, or related field (or equivalent experience)
• 5+ years of experience as a Database Engineer, Data Engineer, or Data Warehouse Engineer
• Expert‑level SQL skills with experience handling large datasets
• Strong experience designing and operating data warehouses for analytics and BI
• Cloud Data Warehouses: Snowflake, Amazon Redshift, Google BigQuery, Azure Synapse
• Strong knowledge of data modeling methodologies (Kimball, Inmon)
• Experience with ELT/ETL tools and orchestration frameworks
• Understanding of data partitioning, compression, and workload management
• Familiarity with BI tools (Tableau, Power BI, Looker, etc.)
• Experience with cloud infrastructure, cost optimization, and scaling strategies
• Exposure to metadata management, data catalogs, and governance tools