Sr Consultant at Deltek, Inc.

03-Nov-2025 Sr ETL Consultant US Remote 10542BR 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 Business Summary Deltek Professional Services' mission is to deliver solutions that help our customers connect and automate the project lifecycle that fuels their business. Our group is responsible for assisting our global clients as they become new members of Deltek's Project Nation by applying professional services proven methodology in areas such as systems design, configuration, testing, training and solution documentation. We are a group of passionate, driven and collaborative individuals who pride ourselves on delivering best-in-class services to a diverse set of customers. Position Responsibilities Join Deltek as a Data Analyst and become the functional leader of data migration engagements that drive transformational outcomes for our clients. In this critical role, you'll bridge the gap between complex business requirements and technical implementation, ensuring that data migrations are not only technically sound but strategically aligned with client objectives.You'll serve as the primary interface between business stakeholders and technical teams, translating intricate business needs into clear, actionable specifications while partnering closely with Data Developers to deliver successful project outcomes.US Citizen or Green Card Holder required for this positionWhat You'll DoRequirements Gathering & AnalysisConduct comprehensive source system analysis and data profiling to understand data structures, quality patterns, and embedded business rulesFacilitate stakeholder meetings to gather detailed requirements, clarify business logic, and validate transformation rulesPerform thorough gap analysis between source and target systems to proactively identify data conversion challengesCreate detailed functional specifications and comprehensive source-to-target mapping documentsSolution Design & ValidationDesign sophisticated data transformation logic and business rules for technical implementationDevelop robust test scenarios and validation frameworks to ensure data integrity throughout migration processesReview and approve Data Developer SQL implementations against your functional specificationsCollaborate on Airflow DAG configuration and setup, providing essential business context for proper orchestrationQuality Assurance & Stakeholder ManagementLead comprehensive data reconciliation efforts and coordinate user acceptance testing with client stakeholdersInvestigate and resolve data discrepancies, partnering with Data Developers to implement targeted correctionsMaintain clear communication channels with clients throughout the engagement lifecycleContinuous Improvement & MentorshipLeverage and enhance reusable function libraries, providing actionable feedback on usability and suggesting improvementsChampion the adoption of standardized tools and templates across the broader team Qualifications Bachelor's degree in Data Analytics, Computer Science, Information Systems, or related field5+ years of experience in data analysis, preferably in data migration or ETL projectsStrong analytical and problem-solving skills with attention to detailExperience with SQL and data profiling toolsExcellent communication skills with ability to translate technical concepts for business stakeholdersExperience with requirements gathering and functional specification documentationUnderstanding of data quality principles and validation methodologiesPreferred QualificationsExperience with Apache Airflow or similar workflow orchestration toolsBackground in enterprise software implementations or data migration projectsExperience with data reconciliation and user acceptance testing coordinationKnowledge of various database platforms and data integration patternsProject management or team leadership experienceFamiliarity with Deltek software solutionsMust be knowledgeable in and utilize AI tools to help streamline tasks.Key CompetenciesAnalytical Thinking: Ability to break down complex data challenges and design systematic solutionsStakeholder Management: Strong interpersonal skills to work effectively with both technical teams and business usersQuality Focus: Commitment to delivering high-quality, accurate data solutionsCollaboration: Experience working in cross-functional teams and mentoring otherAdaptability: Comfort working in dynamic project environments with evolving requirements Compensation Information The U.S. salary range for this position is $68500.00 - $119750.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. Travel Requirements No 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.