Analytics Data Engineer I

AlexandriaVAGov; Alexandria (VA); Hybrid; USD 50,000 - 80,000; Full time

Job summary

Join an innovative city government in Alexandria as an entry-level Analytics Data Engineer. This unique role offers the chance to shape a new citywide data strategy focused on enhancing transparency and decision-making through data integration. You'll collaborate with a dynamic team, utilizing your skills in data management and analytics to support city leaders and residents. With a commitment to work-life balance and a hybrid work model, this position provides an exciting opportunity to contribute to impactful projects that improve community services. If you're passionate about using data for public service, this role is for you!

Benefits

Work-life balance

Professional development opportunities

Collaborative team culture

Flexible working hours

Qualifications

• Bachelor's degree in a related field with two years of experience.
• Familiarity with ELT/ETL processes and data management best practices.

Responsibilities

• Clean and prepare raw data for analytics using ELT and ETL best practices.
• Collaborate with departments to implement data governance policies.

Skills

ELT and ETL processes

Microsoft Data Factory

AWS Glue

Tableau Prep

R

Python

SQL

Data Management

Attention to Detail

Creative Problem Solving

Strong Communication

Public Service Motivation

Education

Bachelor's degree in public policy

Bachelor's degree in statistics

Bachelor's degree in data science

Bachelor's degree in public administration

Tools

Microsoft Data Factory

AWS Glue

Tableau Prep

Job description

Nestled along the Potomac River and bordered by Washington, D.C., Arlington, and Fairfax counties, the City of Alexandria is a historic and vibrant community. With a population of around 150,000, Alexandria offers a unique blend of rich history and modern amenities.

About the Role

The City of Alexandria is seeking an entry-level Analytics Data Engineer to join the Office of Performance Analytics (OPA). This role is ideal for someone excited to help shape a new citywide data strategy focused on centralizing and integrating data for better decision-making and public transparency.

As part of our small, dynamic team, you'll help build foundational data practices to ensure Alexandria’s data is accurate, accessible, and valuable for city leaders and residents alike.

This is a unique opportunity to be part of transformative efforts that will define the future of data in Alexandria, supporting analytics, transparency, and emerging technologies like AI.

Key Responsibilities

1. Clean, transform, and prepare raw data to be analytics-ready using ELT and ETL best practices.
2. Deliver and manage internal and public open data to provide transparency and access to the City’s data.
3. Collaborate with departments to develop and implement data governance policies that support quality, security, and access.
4. Maintain consistency and accuracy of data throughout the data lifecycle by collaborating within the City government and applying best practice approaches.
5. Support business intelligence tools by organizing indicators, monitoring dashboards, and managing user access.
6. Build data literacy by training staff on data as an organizational asset.
7. Assist analysts by developing high-quality datasets for use in citywide analytics projects.

What You Should Bring

1. Foundational Technical Skills: Familiarity with ELT and ETL processes and tools including GUI-based platforms like Microsoft Data Factory, AWS Glue, or Tableau Prep and/or coding languages such as R, Python, or SQL.
2. Data Management Mindset: Eagerness to learn and apply best practices in organizing, centralizing, and enriching datasets.
3. Attention to Detail: Ability to transform raw data into accurate, curated datasets for analysis and decision-making.
4. Team-Oriented and Curious: Comfortable collaborating across departments and learning on the job in a fast-evolving space.
5. Creative Problem Solving: A thoughtful, analytical approach to addressing challenges with practical, data-driven solutions.
6. Strong Communication: Ability to explain technical issues to both technical and non-technical audiences.
7. Public Service Motivation: Passion for using data to improve services and benefit the Alexandria community.

Why Join Us?

1. Be part of building a new citywide data strategy that will shape the future of data-driven decisions, public transparency, and AI in Alexandria.
2. Work on impactful, citywide projects that will improve the services provided to the Alexandria community.
3. Contribute to a collaborative, team-oriented culture that values growth, learning, and professional development.
4. Join an award-winning data and analytics organization, nationally recognized for innovation and excellence in the public sector.
5. Flexibility – the City is committed to work/life balance; this opportunity is hybrid, with the potential to work up to two days a week remotely.

Minimum Qualifications

Bachelor's degree in public policy, statistics, data science, public administration, or a related field, along with two years of relevant experience; or any equivalent combination of experience and training that provides the required knowledge, skills, and abilities.

About the company

Alexandria is an independent city in the Commonwealth of Virginia in the United States.