Company Summary As the recognized global standard for project-based businesses, Deltek delivers software and information solutions to help organizations achieve their purpose. Our market leadership stems from the work of our diverse employees who are united by a passion for learning, growing and making a difference. At Deltek, we take immense pride in creating a balanced, values-driven environment, where every employee feels included and empowered to do their best work. Our employees put our core values into action daily, creating a one-of-a-kind culture that has been recognized globally. Thanks to our incredible team, Deltek has been named one of America's Best Midsize Employers by Forbes, a Best Place to Work by Glassdoor, a Top Workplace by The Washington Post and a Best Place to Work in Asia by World HRD Congress. www.deltek.com Position Responsibilities We're seeking a Data Engineer to join our Enterprise Data & Intelligence team during an exciting transformation from a legacy SQL Server enterprise data warehouse to Snowflake as our Enterprise-wide intelligent data platform. You'll play a critical role in building and maintaining data pipelines that not only power today's analytics but also lay the foundation for tomorrow's unified trusted data foundation, self-service analytics, semantic layers, and AI/ML capabilities to enable strategic data capabilities.
This position requires someone who combines strong technical skills with deep understanding of data warehousing fundamentals and the ability to translate complex technical concepts for diverse stakeholders. You'll work on everything from pipeline development to transformation logic in dbt, ensuring our intelligent data platform delivers reliable, well-structured data that empowers both traditional reporting and advanced analytics use cases.
- 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
Qualifications Technical Skills
- 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
Professional Skills
- 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 Qualifications
- 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
Compensation Information The U.S. salary range for this position is $81500.00 - $142750.00. This range is subject to change as Deltek takes a number of factors into consideration when determining individual base pay, such as location, job-related knowledge, skills and experience. Certain roles are eligible for additional rewards, including incentive compensation and equity.
Benefits and perks listed here may vary depending on the nature of employment with Deltek. Employees have access to healthcare benefits, a 401(k) plan and company match, paid vacation time and holidays, well-living programs, short-term and long-term disability coverage, basic life insurance and tuition reimbursement. Compliance Requirements Certain roles may have additional privacy, security and compliance requirements to the extent they support Costpoint GCCM or similar product offerings. EEO Statement Deltek, Inc. is an Equal Opportunity / Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, or protected veteran status. E-Verify Statement Deltek, Inc., utilizes the E-Verify program with every potential new hire. This makes it possible for us to make certain that every employee who works for Deltek is eligible to work in the United States. To learn more about E-Verify you can call 1-800-255-7688 or visit their website by clicking the logo below. E-Verify is a registered trademark of the United States Department of Homeland Security. Applicant Privacy Notice Deltek is committed to the protection and promotion of your privacy. In connection with your application for employment with us at Deltek, it is necessary for us to collect, store and use information about you ("Personal Data") to administer and evaluate your application. We are the "controller" of the Personal Data you provide us and will process any such Personal Data in accordance with applicable law and the statements contained in this Employment Candidate Privacy Notice. Additionally, we have not sold and do not sell Personal Data you provide to us through the job application process. |
Deltek, Inc.
life insurance, tuition reimbursement, 401(k)
Jan 07, 2026