Ernst and Young

Government and Infrastructure - AI and Data - Data Engineer - Top Secret Clearance

Ernst and Young
Apply
1 month ago
McLean, VA, USAEntry Level / Mid Level
H1B sponsor

Base Salary

$76k - $143k/yr

Responsibilities

  • Analyze large datasets to identify trends, anomalies, and actionable insights.
  • Develop dashboards, scorecards, reports, and self-service analytics solutions using Power BI.
  • Conduct ad hoc analyses supporting audits, operational assessments, and leadership inquiries.
  • Design, maintain, and optimize ETL/ELT data extraction, transformation, and loading processes.
  • Develop and optimize SQL queries, views, and stored procedures.
  • Integrate data from multiple enterprise systems and data sources.
  • Support cloud-based data platforms and analytics environments.
  • Troubleshoot data pipeline, data quality, and reporting issues.
  • Build analytical products and improve the accessibility, quality, and usability of enterprise data.
  • Collaborate with stakeholders, analysts, and technical teams in a client-facing consulting environment.
  • Write tests, participate in code reviews, and learn emerging methodologies and technologies.

Requirements

  • Bachelor's degree required.
  • Active Top Secret clearance required.
  • 1–3 years of related experience with SQL, Power BI, data modeling, data integration and transformation, data visualization, relational databases, and large datasets.
  • Experience with ETL/ELT pipeline development, Azure Data Factory or similar technologies, and Python for data processing and automation is preferred.
  • Experience optimizing database and reporting performance, managing data quality, and developing dashboards and KPI reporting is preferred.
  • Bachelor's degree or above in mathematics, information systems, statistics, computer science, or a related discipline is preferred.
  • Must be comfortable working in person in the Washington, DC area.
  • Must be willing to travel 20–30% or more.

Benefits

  • Medical and dental coverage, pension, and 401(k) plans.
  • Paid time off under a flexible vacation policy, plus EY-paid holidays, winter/summer breaks, personal/family care, and other leave options.
  • Work may occur at client, EY, or contractor sites, with assignments generally within a commutable distance and additional travel based on project needs.

Tech Stack

Categories

Data Engineering
Ernst and Young

About Ernst and Young

10,000+ employees

Ernst & Young (EY) provides audit/assurance, tax, consulting, strategy and transactions services to enterprises, financial institutions, and public‑sector clients. Structured as a global network of partner‑owned member firms, it sells professional services on a fee basis, including a dedicated Financial Services Organization for banking, insurance, and capital markets. Headquartered in London, EY was formed in 1989 from the merger of Ernst & Whinney and Arthur Young, and operates in 150+ countries.

Contact me