← Back to jobsJob ID col-cmwf6zu0b0an289hqwmv2uroo

Enterprise SoftwarePosted 8 days ago

Database Engineer

Full-time
On-site
5+ years
Competitive
Posted 8 days ago

Responsibilities 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 Write and optimize complex SQL queries, views, materialized views, and stored procedures Tun

Posted
8 days ago
Source
recruiting.myapps.paychex.com
Sector
Information Technology & AI

Opens the employer's application page in a new tab

Responsibilities

  • 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
  • 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
  • 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

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
  • On-Prem / MPP Databases: Teradata, Oracle, SQL Server, Vertica, Greenplum
  • OLAP / Analytics Concepts: Columnar storage, MPP architectures, query optimization
  • 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

Required skills

Amazon RedshiftAzure SynapseData WarehousingDimensional Data Modeling InmonDimensional Data Modeling KimballGoogle BigQueryGreenplumOracleSQLSQL ServerSnowflakeTeradataVertica

Full job description

Responsibilities

  • 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
  • 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
  • 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

Benefits

  • Career advancement opportunities for all employees
  • An extensive benefits package to support the wellness of employees and their families
  • A supportive work environment

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
  • On-Prem / MPP Databases: Teradata, Oracle, SQL Server, Vertica, Greenplum
  • OLAP / Analytics Concepts: Columnar storage, MPP architectures, query optimization
  • 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

Required skills

  • Amazon Redshift, Azure Synapse, Data Warehousing, Dimensional Data Modeling Inmon, Dimensional Data Modeling Kimball, Google BigQuery, Greenplum, Oracle, SQL, SQL Server, Snowflake, Teradata, Vertica

Experience

  • 5+ years

Company

  • Strategy, innovation, and technology services for defense and security.
  • Hanover, Maryland, USA
  • https://www.eccalon.com

Job details

Employment type

Full-time

Seniority level

5+ years

Date posted

Nov 13, 2026

Work mode

On-site

Job source

recruiting.myapps.paychex.com

Company

Enterprise Software

Information Technology & AI

Strategy, innovation, and technology services for defense and security.

See all 13 jobs from Enterprise Software →
  • Hanover, Maryland, USA
  • Information Technology & AI
  • eccalon.com

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Warehouse Engineer jobs in Detroit

Amazon

1d ago

New

Business Intelligence Engineer II, Amazon Global Logistics

Full-timeOn-siteBellevue, WA$100K – $160K/yr

Amazon hires a Business Intelligence Engineer II to support Sales, Marketing, and Pricing analytics for Global Logistics.

Why similarSame roleAmazon RedshiftData Warehousing

just now

1d ago

New

DBT Engineer with Airflow & SQL

Full-timeOn-siteUnited StatesCompetitive

NTT DATA is hiring a DBT Engineer with Airflow & SQL to build and maintain data transformation models and scalable ELT/ETL pipelines in Snowflake. The role focuses on data modeling, warehouse performance, and data quality and security.

Why similarSame roleData WarehousingSQL

NTT DATA North America

1d ago

New

DBT Engineer with Airflow & SQL

Full-timeHybridOaks, PACompetitive

NTT DATA is hiring a DBT Engineer with Airflow and SQL to build and maintain data transformation models and scalable ELT/ETL pipelines. The role focuses on Snowflake data modeling and performance, SQL development, and data quality and security.

Why similarSame roleData WarehousingSQL

Get new Data Warehouse Engineer jobs in Detroit by email

Create job alert

Database Engineer

Enterprise Software · Competitive

Apply on company site