Sr Consultant

Job description

10542BRCompany 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

nnnnAuto req ID:10542BRExternal Job Title:Sr ETL Data AnalystPosition 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 position

What You'll Do

Requirements Gathering & Analysis

+ 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

Solution Design & Validation

+ 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

Quality Assurance & Stakeholder Management

+ 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

Continuous Improvement & Mentorship

+ 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

Work Location:US RemoteQualifications:

+ 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 Qualifications

+ 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.

Key Competencies

+ Analytical Thinking: Ability to break down complex data challenges and design systematic solutions

+ Stakeholder Management: Strong interpersonal skills to work effectively with both technical teams and business users

+ Quality Focus: Commitment to delivering high-quality, accurate data solutions

+ Collaboration: Experience working in cross-functional teams and mentoring other

+ Adaptability: Comfort working in dynamic project environments with evolving requirements

Travel Requirements:NoEEO 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 (https://education.deltek.com/web/du_internal/Recruitment/Applicant Privacy Notice.pdf) .

Additionally, we have not sold and do not sell Personal Data you provide to us through the job application process.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.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.Compliance Requirements:Certain roles may have additional privacy, security and compliance requirements to the extent they support Costpoint GCCM or similar product offerings.

Required Skill Profession

Other General