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.
Requirements
- Experience with SQL and data profiling tools
- Experience with requirements gathering and functional specification documentation
- Understanding of data quality principles and validation methodologies
- Experience with Apache Airflow or similar workflow orchestration tools
- Knowledge of various database platforms and data integration patterns
- Familiarity with Deltek software solutions
- Must be knowledgeable in and utilize AI tools to help streamline tasks.
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
Other
- 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
- Excellent communication skills with ability to translate technical concepts for business stakeholders
