Database Engineer - onsite
EOE Statement
Eccalon provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.
EEO is the law.
Category
Software Engineer
Description
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
Data Integration & Pipelines
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
Collaboration & Leadership
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
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
Full-Time/Part-Time
-unspecified-
Exempt/Non-Exempt
Non-Exempt
About the Organization
Eccalon provides global solutions to the most challenging technological issues of the 21st-century, and our evolving portfolio spans five major markets: Machine Learning, Cybersecurity, Aerospace & Defense, Material Sciences, Advance Manufacturing, Sports Science, Biotechnology, and Health & Life Sciences.
Why Join Us?
Eccalon's Executives foster a supportive work environment allowing our teams to thrive, and have a fierce dedication to innovation, security, and people. Our culture is built on inclusion, teamwork, trust, and we are committed to offering career advancement opportunities to all employees. Encouraging a healthy and balanced life, we offer an extensive benefits package to support the wellness of our employees and their families. You will be joining a team of innovators, working with cutting edge technologies, supporting mission critical projects, and making an impact.
Apply today to advance your career!
This position is currently accepting applications.