Lead Data Engineer Analyst

As a Project Delivery Lead on the project, you will:

• Ingest and integrate client datasets by coordinating secure data transfers, profiling incoming files, and orchestrating end-to-end pipelines that resolve deconfliction and complex integration issues across sources.
• Clean, standardize, and transform raw data using repeatable routines for validation, deduplication, and business-rule application to deliver client-specified output formats and curated analytics-ready tables.
• Load and manage data in cloud database platforms by designing efficient schemas, executing scheduled loads/incremental updates, monitoring data quality controls, and troubleshooting pipeline failures to meet reporting SLAs.
• Build and maintain Tableau dashboards by translating stakeholder requirements into metrics, data models, and visualizations, and publishing governed dashboards that surface trends, KPIs, and operational insights.
• Own legacy reporting and statistics generation systems by rapidly understanding inherited codebases, debugging data anomalies via ad-hoc analysis, implementing enhancements with tests, and providing peer code reviews while partnering directly with clients and internal team members.

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.

• Bachelor’s degree.
• Must be legally authorized to work in the United States without the need for employer sponsorship, now or at any time in the future.
• Active public trust security clearance required.
• 5+ years of relevant experience in data engineering and/or analytics roles supporting production data pipelines, reporting, and stakeholder-driven analysis.
• 4+ years of relevant experience of development experience with Python and SQL proficiency to ingest, clean, transform, and validate datasets; build/maintain ETL/ELT workflows; and troubleshoot data anomalies end-to-end.
• 3+ years of relevant experience designing, building, and maintaining dashboards, including creating reliable data sources/models and translating requirements into actionable visual insights.
• Professional python certification such as PCPP1, PCAP, or PCEP.
• Ability to travel 10-15%, on average, based on the work you do and the clients and industries/sectors you serve.

Preferred:

• Master’s degree perferred.
• Active TS Security Clearance Perferred.
• Professional Tableau certification perferred.

Our Deloitte AI & Engineering team 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.