Deltek · 12 hours ago
Data Engineer
United States
Full-time
Remote
Mid LevelDeltek is undergoing a transformation to enhance its data capabilities, and they are seeking a Data Engineer to join their Enterprise Data & Intelligence team. The role involves building and maintaining data pipelines for their Snowflake platform, ensuring data quality and enabling advanced analytics and AI/ML capabilities.
ConsultingEnterprise SoftwareInformation TechnologySoftware
Responsibilities
Design, develop, and maintain data pipelines that feed our Snowflake intelligent data platform using Python, Fivetran, and other modern ETL/ELT tools
Build and maintain transformation logic in dbt, converting SQL Server stored procedures to modular, testable dbt models on Snowflake
Develop dimensional data models following best practices, creating the foundation for semantic layers and self-service analytics
Translate complex SQL Server stored procedures and SSIS packages from our legacy EDW database to dbt models and cloud-native solutions
Implement proper grain definition, ensure additivity of facts, and maintain dimensional consistency across data marts to support both BI and future ML workloads
Create dbt tests, documentation, and lineage to ensure data quality and transparency
Partner with analytics teams, business stakeholders, and subject matter experts across the enterprise to understand requirements, validate business logic, and translate them into robust technical solutions that scale with our platform’s intelligence capabilities
Develop and enforce data quality standards that ensure our platform remains trustworthy for both human and AI consumers
Contribute to our migration strategy from traditional EDW database to intelligent data platform architecture through analytical problem-solving and strategic thinking
Containerize data applications using Docker and deploy to Kubernetes environments
Facilitate knowledge transfer sessions and documentation to ensure the entire team understands new patterns and approaches
Qualification
Required
Strong SQL expertise with ability to write complex, optimized queries and understand execution plans
Snowflake experience including understanding of virtual warehouses, micro-partitions, and cloud data warehouse best practices
dbt proficiency including: Building modular, reusable data models, Writing custom tests and macros, Understanding materializations (tables, views, incremental models), Documentation and lineage best practices, Converting stored procedure logic to dbt models
Python proficiency for data engineering tasks (pandas, SQLAlchemy, pipeline orchestration)
Deep understanding of dimensional modeling and data warehousing fundamentals including: Fact and dimension table design patterns, Slowly changing dimensions (Type 1, 2, 3), Grain declaration and consistency, Additivity and semi-additive measures, Conformed dimensions and bus matrix design
Experience building production data pipelines with proper error handling, logging, and monitoring
Understanding of modern data stack concepts (ELT vs ETL, data lakehouse, streaming vs batch)
Version control proficiency with Git
Strong analytical mindset with the ability to break down complex problems and evaluate multiple solution approaches
Clear communication skills to articulate technical decisions, trade-offs, and recommendations to both technical and non-technical audiences
Demonstrated ability to work effectively across teams and business units, building consensus around enterprise data standards and driving solutions forward
Experience mentoring others and sharing knowledge to elevate team capabilities
Preferred
Fivetran experience or comparable tools
SQL Server and SSIS background to aid in stored procedure to dbt migration
Container orchestration with Docker and Kubernetes
Azure DevOps and CI/CD pipeline development
Building and maintaining deployment pipelines for dbt projects
Automated testing and validation of data transformations
DataOps practices and principles
Understanding of data governance and data quality frameworks essential for platform intelligence
Experience with federated BI approaches and semantic layer design
Familiarity with Power BI
Knowledge of availability groups, failover clusters, or similar HA/DR concepts
Company
Deltek
Deltek is an enterprise software and information solutions provider for professional services firms and government contractors.
Founded in 1983
1001-5000 employees
H1B Sponsorship
Deltek has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (2)
2024 (7)
2023 (2)
2022 (1)
2021 (7)
2020 (5)
Funding
Current Stage
Public CompanyTotal Funding
$2M2016-12-06Acquired
2012-01-01Private Equity
2009-12-11Post Ipo Equity· $2M
Leadership Team
Dinakar Hituvalli
Chief Technology Officer and SVP of Product Development
Ed Hutner
SVP and Chief Human Resource Officer
Recent News
2025-12-10
2025-11-13
Company data provided by crunchbase