Eccalon, LLC is looking for a Database Engineer with deep data warehousing expertise to design, build, and maintain large-scale analytical databases in Detroit, Michigan. The role supports reporting, business intelligence, and advanced analytics across the organisation, and it puts data correctness, performance, scalability, and reliability at the centre of the work. As Database Engineer, you’ll design and maintain enterprise data warehouse architectures; develop dimensional models with star and snowflake schemas and fact and dimension tables; translate business requirements into scalable data structures; support slowly changing dimensions and aggregations; write and tune complex SQL, views, materialised views, and stored procedures; apply partitioning, indexing, clustering, and distribution strategies; keep platforms highly available and ready for disaster recovery; support and optimise ELT and ETL pipelines; validate data quality and integrity; manage access controls and governance standards; keep schema and metric documentation current; and guide analysts and stakeholders on modelling and querying best practice. The role calls for at least five years of experience as a database, data, or data warehouse engineer, and expert-level SQL.
About Eccalon — Technology for Critical Challenges
Company: Eccalon, LLC
Location: Detroit, Michigan
Markets: Machine learning, cybersecurity, aerospace and defence, materials science, advanced manufacturing, sports science, biotechnology, and health and life sciences
Culture: Inclusion, teamwork, trust, and career advancement for all employees
Work: Cutting-edge technology and mission-critical projects
Database Engineer Role — Warehouse Design, Performance & Governance
Department: Data & Analytics Platforms
Primary Focus: Dimensional modelling, SQL performance, data pipelines, platform governance
Scope: Enterprise data warehouse platforms for reporting and analytics
Mission: Keeping analytical data correct, fast, and reliable for every team that depends on it
Database Engineer Position Overview
The Database Engineer role is about building the foundations that business intelligence and analytics depend on. A data warehouse is only useful if its numbers are correct, its queries are fast, and its structure can grow as the business does. This position owns those qualities across Eccalon’s enterprise data platforms. Architecture comes first. You’ll design and maintain the warehouse architecture and turn it into dimensional models built on star and snowflake schemas, with fact and dimension tables that reflect how the business measures itself. Requirements from analysts, product, and finance teams have to become schemas that scale, and you’ll handle historical data, slowly changing dimensions, and the aggregations that make reporting efficient. Performance is where much of the craft lies. You’ll write and refine complex SQL, views, materialised views, and stored procedures, and you’ll tune the database for large analytical workloads using partitioning, indexing, clustering, and distribution strategies. Reliability matters just as much, so you’ll help keep the platform highly available, with sound backup, recovery, and disaster recovery readiness. Data arrives from many sources, so you’ll support and improve the ELT and ETL pipelines that feed the warehouse, working with data engineers to make ingestion dependable and checking that data is consistent, complete, and fit for use. Governance runs throughout. You’ll implement access controls and security policies, maintain documentation for schemas, metrics, and definitions, and support audit and lineage needs. Finally, you’ll work closely with analytics, business intelligence, and business stakeholders, share best practice on modelling and querying, contribute to architecture discussions, and mentor junior engineers where appropriate.
As Database Engineer, you’ll deepen your command of data warehouse design, dimensional modelling, and performance engineering across cloud and on-premise platforms. The ideal candidate holds a bachelor’s degree in computer science, engineering, information systems, or a related field, or equivalent experience, and has at least five years of experience as a database, data, or data warehouse engineer. Expert-level SQL with large datasets is essential, as is strong experience designing and running data warehouses for analytics and business intelligence. Familiarity with cloud platforms such as Snowflake, Amazon Redshift, Google BigQuery, or Azure Synapse is valued, as is experience with on-premise and MPP systems such as Teradata, Oracle, SQL Server, Vertica, or Greenplum. Understanding of columnar storage, MPP architectures, and query optimisation is important, along with knowledge of Kimball and Inmon modelling methods. Experience with ELT and ETL tools and orchestration frameworks, and with partitioning, compression, and workload management, will help you succeed. Familiarity with BI tools such as Tableau, Power BI, or Looker, and experience with cloud cost optimisation and scaling, are also expected. Exposure to metadata management, data catalogues, and governance tools completes the picture. For data professionals in Detroit who want to build the analytical platforms that serve a diverse technology business, this role offers real depth and scale.
Why This Role Matters: As Database Engineer at Eccalon, you build the data warehouses that reporting and analytics rely on, make complex queries fast enough for large analytical workloads, keep pipelines feeding the warehouse dependable, protect data through governance and access controls, guide the teams who model and query data, and grow a career in data warehousing and analytics engineering in Michigan.
Key Responsibilities & Engineering Duties
Data Warehouse Architecture & Design
- Design and maintain enterprise-grade data warehouse architectures
- Develop star and snowflake dimensional models
- Define fact and dimension tables for analysis
- Translate business requirements into scalable data schemas
- Support historical data and slowly changing dimensions
- Design aggregations that speed up reporting
Database Development & Performance
- Write and optimise complex SQL queries
- Build and maintain views, materialised views, and stored procedures
- Tune performance for large analytical workloads
- Implement partitioning, indexing, and clustering
- Plan distribution strategies for scale
- Review query plans to find and fix slow processes
Reliability, Backup & Recovery
- Maintain high availability of the warehouse
- Manage backup and recovery processes
- Keep disaster-recovery plans ready and tested
- Monitor platform health and resilience
- Plan capacity for growth in data volume
- Respond to incidents that affect data availability
Data Integration & Pipelines
- Support and optimise ELT and ETL pipelines
- Work with data engineers on reliable ingestion
- Validate data quality, consistency, and integrity
- Check source data before it reaches the warehouse
- Partner with analytics and BI teams on data readiness
- Resolve pipeline issues that affect reporting
Platform Operations & Governance
- Monitor warehouse performance, cost, and usage
- Implement data access controls and security policies
- Apply governance standards across datasets
- Maintain documentation for schemas and metrics
- Keep data definitions consistent and current
- Support audit, compliance, and data lineage requirements
Collaboration & Leadership
- Work with analytics, product, finance, and business teams
- Advise on best practice for querying and modelling
- Contribute to architecture discussions and platform evolution
- Mentor junior database and data engineers
- Explain technical trade-offs clearly to non-specialists
- Help shape the long-term data platform roadmap
Qualifications & Requirements
Education
- Bachelor’s degree in Computer Science or Engineering
- Bachelor’s degree in Information Systems or a related field
- Or equivalent experience
Experience
- 5+ years as a database, data, or data warehouse engineer
- Expert-level SQL skills with large datasets
- Strong experience designing and operating analytical data warehouses
- Experience with ELT and ETL tools and orchestration frameworks
Platforms & Concepts
- Cloud warehouses such as Snowflake, Amazon Redshift, Google BigQuery, or Azure Synapse
- On-premise and MPP databases such as Teradata, Oracle, SQL Server, Vertica, or Greenplum
- Columnar storage, MPP architectures, and query optimisation
- Kimball and Inmon data modelling methodologies
- Data partitioning, compression, and workload management
Tools & Operations
- BI tools such as Tableau, Power BI, or Looker
- Cloud infrastructure, cost optimisation, and scaling strategies
- Metadata management, data catalogues, and governance tools (exposure)
Career Development & Growth Opportunities
Professional Advancement
- Pathway toward Principal Data Engineer or Data Architect roles
- Opportunity to lead platform evolution and architecture
- Growth through mentoring and technical leadership
- Career advancement opportunities for all employees
Learning & Development
- Work with cutting-edge data and cloud technologies
- Experience with mission-critical analytical systems
- Exposure to diverse markets from defence to life sciences
- Development in governance, lineage, and data quality
Benefits & Culture
- Extensive benefits package supporting employee and family wellness
- Inclusive, supportive, and collaborative team culture
- Opportunities to make a real impact on important projects
About Eccalon — Solving Tomorrow’s Technical Challenges
Eccalon provides global solutions to some of the most challenging technological issues of the twenty-first century. Its portfolio spans machine learning, cybersecurity, aerospace and defence, materials science, advanced manufacturing, sports science, biotechnology, and health and life sciences. The company’s culture rests on inclusion, teamwork, and trust, and it is committed to giving every employee room to advance.
Career Excellence in Data Warehousing: Join an innovative technology company in Detroit, design dimensional data warehouses, tune analytical SQL at scale, keep data pipelines reliable, protect data through governance, and build a career in database and data warehouse engineering.
Who Should Apply?
- Data Engineers: Moving into data warehouse design
- SQL Developers: Seeking a senior warehousing role
- Data Warehouse Engineers: Ready for enterprise platform work
- BI Developers: Looking to deepen modelling and performance skills
- Cloud Data Specialists: With Snowflake, BigQuery, or Redshift experience
- Detroit-Based Data Professionals: Seeking a technically demanding role
Recently Opening Job👇
