Data and Analytics Engineer

About this role

Data and Analytics Engineer

ABOUT THE ROLE

Digital Strategy LLC is seeking a Data and Analytics Engineer to design, deliver, and operate end-to-end data products for a U.S. Department of Energy client. The engagement is migrating from an on-premises SQL Server and SSIS data warehouse to a centralized enterprise cloud data platform built on AWS-hosted Databricks, and this role will help modernize the legacy estate while developing for the target platform going forward.

This is a hands-on engineering role that balances rapid-turnaround data requests with the development of governed, reusable analytics solutions. The work may range from an urgent data call one day to a multi-release pipeline, dimensional model, dashboard, natural-language analytics experience, or data application the next. The successful engineer will respond pragmatically to immediate needs while identifying when recurring requests should become tested, documented, and maintainable data products. The mix of rapid-response analysis, data engineering, and analytics-product development will shift with client priorities, but maintainable production data products remain the role's consistent core.

Disciplined engineering provides the structure for this work; AI accelerates it. You will apply source control, modular design, automated testing, CI/CD, living documentation, observability, and clear ownership as standard practices, while using AI-assisted development where it improves coding, analysis, testing, metadata, documentation, or incident response. Use AI-assisted development responsibly, validating outputs and applying appropriate security controls, engineering review, and human accountability.

This is an individual-contributor position with notable technical leadership responsibilities; it does not require direct personnel management. You will help analysts, BI developers, engineers, and citizen developers adopt practical data-as-code techniques, including Git-based collaboration, reusab...