PROJECT - Analytics and Insights Engineer III

PowerToFly; Georgia; On-site; USD 110,000 - 180,000; Full time

Job summary

Deloitte's AI & Data team is seeking a PROJECT - Data Engineer III to design, build, and optimize ETL workflows for complex client data integration projects. You will work within a high-caliber team delivering scalable data solutions across multiple environments.

The role emphasizes improving data quality, performance, and reliability while collaborating with analysts, engineers, and clients to meet requirements and timelines.

Qualifications

• Bachelor's degree in a technical field required.
• 8+ years of experience in ETL development, data integration, or data engineering.
• Experience with SQL, relational DBs, and stored procedures.

Responsibilities

• Design, develop, test, and maintain ETL processes and workflows supporting client data integration needs
• Develop and optimize data transformation logic, SQL queries, stored procedures, and database processes to improve performance and reliability
• Implement data validation, cleansing, and quality assurance processes to support data accuracy and consistency
• Automate data integration processes and identify opportunities to improve operational efficiency
• Monitor ETL jobs, troubleshoot failures, performance issues, and data discrepancies, and provide production support for data-related issues
• Develop and maintain technical documentation for ETL workflows, data processes, and support procedures

Skills

Independent work

Team collaboration

Effective communication

Detail oriented

Project leadership

Task prioritization

Interpersonal skills

Meeting deadlines

Guidance to others

Education

Bachelor's degree in Computer Science, Information Systems, Data Engineering, or another technical field

Tools

SSIS

Informatica

Job description

Our Deloitte AI & Engineering team works to transform technology platforms, drive innovation, and help make a significant impact on our clients' success. You'll work alongside talented professionals reimagining and reengineering operations and processes that are critical to businesses. Your contributions can help clients improve financial performance, accelerate new digital ventures, and fuel growth through innovation.

Work you'll do

As a PROJECT - Data Engineer III on the AI & Data team, you will be responsible for ...

• Design, develop, test, and maintain ETL processes and workflows supporting client data integration needs


• Develop and optimize data transformation logic, SQL queries, stored procedures, and database processes to improve performance and reliability


• Implement data validation, cleansing, and quality assurance processes to support data accuracy and consistency


• Automate data integration processes and identify opportunities to improve operational efficiency


• Monitor ETL jobs, troubleshoot failures, performance issues, and data discrepancies, and provide production support for data-related issues


• Develop and maintain technical documentation for ETL workflows, data processes, and support procedures

A successful candidate would possess these skills:

• Ability to work independently and collaborate as part of a team


• Effective written and verbal communication skills


• Meticulous attention to detail and quality of work product


• Ability to build and sustain professional relationships


• Ability to lead projects or workstreams


• Ability to manage and prioritize multiple tasks in a fast-paced and dynamic environment


• Strong interpersonal skills and professional demeanor


• Ability to meet deadlines


• Ability to provide clear guidance to others

The team

Deloitte's Government & Public Services (GPS) practice - our people, ideas, technology and outcomes - is designed for impact. Serving federal, state, & local government clients as well as public higher education institutions, our team of professionals brings fresh perspective to help clients anticipate disruption, reimagine the possible, and fulfill their mission promise.

Our AI & Data offering provides a full spectrum of solutions for designing, developing, and operating cutting-edge Data and AI platforms, products, insights, and services. Our offerings help clients innovate, enhance and operate their data, AI, and analytics capabilities, ensuring they can mature and scale effectively.

The Project Delivery Talent Model is designed for professionals with specialized skills that align to a current client need. Team members focus on delivering services to clients, without additional expectations related to business development or promotion. Their employment is tied to their role on a project, and they are eligible for a benefits package that is competitive for project delivery-focused professionals.

Qualifications

Required:

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, or another technical field


• 8+ years of experience in ETL development, data integration, or data engineering


• Experience using Structured Query Language (SQL), relational database management systems, and stored procedures


• Experience using ETL tools such as SQL Server Integration Services (SSIS) or Informatica


• Experience applying data integration, data transformation, and data quality principles in human services programs, systems, or environments


• Ability to travel 0-25%, on average, based on the work you do and the clients and industries/sectors you serve.


• Limited immigration sponsorship may be available.

Preferred:

• Experience supporting federal, state, local, or higher education clients


• Experience with cloud-based data platforms or analytics environments


• Experience developing dashboards or reporting solutions using Tableau or Power BI


• Experience working in Agile delivery environments


• Experience with root cause analysis and production support for enterprise data solutions