ETL Consultant

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.

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

This role is part of the consulting team and will be responsible for performing data migrations from legacy and third-party databases, as well as data changes and data corrections. This role is customer-facing and is expected to conduct customer phone calls and presentations. Verifying the accuracy and completeness of all projects, to ensure quality work, is a crucial part of this role. In addition, this role is expected to contribute to the maintenance and enhancement of Deltek's data migration tools and documents, as well as provide feedback and solutions to improve the scalability and overall implementation experience. The ideal candidate will be quality-focused while managing multiple priorities in a fast-paced environment to meet business and technical demands across a broad spectrum of customers from multiple industry verticals.

Job Duties:

• Performs data migrations, data changes, and data corrections.
• Develop and maintain extract, transform, and load processes (e.g. Python, Airflow, SSIS) that handle diverse source systems and high-volume datasets.
• Learn proprietary data tools for existing and new products. This includes understanding each product's concepts, methods, procedures, technologies, and systems.
• Build and govern a centralized repository of reusable, product-agnostic SQL queries, views, stored procedures, and functions.
• Drive Git-based version control, code reviews and CI/CD for database artefacts.
• Assists customers and consultants with cleaning up existing data and building substitution tables to prepare for data migrations and changes.
• Verifies accuracy and completeness of converted data.
• Lead root-cause investigations and collaborate on corrective actions with the broader team.
• Provides thorough and timely communication regarding issues, change requests, and project statuses to the internal and external project team, including customers, project coordinators, functional consultants, and supervisors.
• Displays excellent communication skills including presentation, persuasion, and negotiation skills required in working with customers and co-workers, including the ability to communicate effectively and remain calm and courteous under pressure.
• Author clear technical documentation (e.g. ETL designs, SQL library guidelines)
• Documents all data migrations, changes, and corrections accurately and completely in conversion delivery documentation.
• Works collaboratively in a team environment with a spirit of cooperation.
• Mentor colleagues on SQL techniques and ETL patterns, fostering a culture of continuous learning.
• Provides exceptional customer service.
• Estimates time and budget requirements for data migrations and changes.
• Works within budget and timeframe requirements for completion of each project.
• Handles changes in scope through documentation in conversion delivery documentation, statement of work, and change orders.
• Creates and maintains procedures manual for data migrations, changes, and fixes
• Files TFS tickets and communicates to the development team any bugs and enhancements needed for new and existing data tools to improve accuracy, timeliness, and profitability of work.

Qualifications

Essential Skills & Experience

• SQL Mastery: 5+ years crafting complex, high-performance T-SQL across platforms (e.g. SQL Server, PostgreSQL, Oracle).
• ETL Expertise: Demonstrated success designing, building and operating end-to-end ETL/ELT pipelines in enterprise environments.
• Scripting & Orchestration: Proficiency in at least one language (e.g. Python (preferable), PowerShell) and familiarity with orchestration tools (Airflow, Azure Data Factory, etc.).
• Version Control & CI/CD: Strong Git workflows experience and automated deployment pipelines for database objects.
• Client-Facing Experience: Comfortable engaging with clients to capture requirements, present technical options and deliver projects to schedule.
• 3+ years of hands-on experience working in a customer-facing role
• Advanced written and verbal communication skills using English
• Advanced conflict management and negotiation
• Advanced troubleshooting and problem-solving skills
• Basic functional knowledge of Deltek Vantagepoint – For validating purposes
• Basic understanding of accounting principles

Desirable Qualifications

• Degree in Computer Science, Information Systems, Mathematics or related discipline.
• Certifications in data platforms (Azure Data Engineer, AWS Big Data, Informatica, etc.).
• Experience with cloud data services (BigQuery, AWS Glue, Azure Synapse).
• Experience working with ERP software
• Must be knowledgeable in and utilise AI tools to help streamline tasks

Personal Attributes

• Excellent communicator: clear, concise and client focused.
• Collaborative team player with a proactive, can-do attitude.
• Driven by quality, automation and continuous improvement.
• Adaptable to evolving priorities and new technologies.

Travel Requirements

No

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.