Deltek · 21 hours ago
Sr ETL Consultant
United States
Full-time
Remote
Mid, Senior Level
$72K/yr - $127K/yr
5+ years expDeltek, Inc. is a leading provider of software and information solutions for project-based businesses. As a Sr ETL Consultant, you will lead data migration engagements, ensuring alignment between business requirements and technical implementation while collaborating with stakeholders and Data Developers to achieve successful project outcomes.
Enterprise SoftwareConsultingSoftwareInformation Technology
No H1B
U.S. Citizen Only
Responsibilities
Conduct comprehensive source system analysis and data profiling to understand data structures, quality patterns, and embedded business rules
Facilitate stakeholder meetings to gather detailed requirements, clarify business logic, and validate transformation rules
Perform thorough gap analysis between source and target systems to proactively identify data conversion challenges
Create detailed functional specifications and comprehensive source-to-target mapping documents
Design sophisticated data transformation logic and business rules for technical implementation
Develop robust test scenarios and validation frameworks to ensure data integrity throughout migration processes
Review and approve Data Developer SQL implementations against your functional specifications
Collaborate on Airflow DAG configuration and setup, providing essential business context for proper orchestration
Lead comprehensive data reconciliation efforts and coordinate user acceptance testing with client stakeholders
Investigate and resolve data discrepancies, partnering with Data Developers to implement targeted corrections
Maintain clear communication channels with clients throughout the engagement lifecycle
Leverage and enhance reusable function libraries, providing actionable feedback on usability and suggesting improvements
Champion the adoption of standardized tools and templates across the broader team
Qualification
Required
US Citizen or Green Card Holder required for this position
Bachelor's degree in Data Analytics, Computer Science, Information Systems, or related field
5+ years of experience in data analysis, preferably in data migration or ETL projects
Strong analytical and problem-solving skills with attention to detail
Experience with SQL and data profiling tools
Excellent communication skills with ability to translate technical concepts for business stakeholders
Experience with requirements gathering and functional specification documentation
Understanding of data quality principles and validation methodologies
Preferred
Experience with Apache Airflow or similar workflow orchestration tools
Background in enterprise software implementations or data migration projects
Experience with data reconciliation and user acceptance testing coordination
Knowledge of various database platforms and data integration patterns
Project management or team leadership experience
Familiarity with Deltek software solutions
Must be knowledgeable in and utilize AI tools to help streamline tasks
Benefits
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
Tuition reimbursement
Company
Deltek
Deltek is an enterprise software and information solutions provider for professional services firms and government contractors.
1001-5000 employees
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
Washington Technology
2026-01-22
2025-12-10
Company data provided by crunchbase