Analytics Data Engineer I

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

Job summary

An established industry player is seeking an entry-level Analytics Data Engineer to join its Office of Performance Analytics. This role offers a unique opportunity to shape a citywide data strategy focused on transparency and decision-making. You'll work with a dynamic team to build foundational data practices, ensuring data accuracy and accessibility for city leaders and residents. If you're passionate about using data to improve public services and eager to learn in a collaborative environment, this position is perfect for you. Join us in making a lasting impact on the Alexandria community through innovative data solutions.

Benefits

Work/life balance

Professional development opportunities

Collaborative team culture

Flexible work schedule

Qualifications

• Familiarity with ELT and ETL processes and tools.
• Eagerness to learn and apply best practices in organizing datasets.

Responsibilities

• Clean, transform, and prepare raw data for analytics.
• Collaborate with departments to implement data governance policies.

Skills

ELT processes

ETL processes

SQL

Python

R

Attention to Detail

Creative Problem Solving

Strong Communication

Data Management Mindset

Team-Oriented

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

About the City of Alexandria

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'llhelp build foundational data practices to ensure Alexandria’s data isaccurate, accessible, and valuable forcity 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

• Clean, transform, and prepare raw datato be analytics-readyusing ELTandETL best practices.

• Deliverand manageinternal and public open datatoprovidetransparency and accessto the City’s data.

• Collaborate with departmentsto develop and implement data governance policies that support quality, security, and access.

• Maintainconsistency and accuracy of data,throughoutthedata lifecycle by collaborating within theCitygovernment and applying best practice approaches.

• Support business intelligence toolsby organizing indicators,monitoringdashboards, and managing user access.

• Build data literacyby training staff on data as an organizational asset.

• Assistanalystsby developinghigh-quality datasets for use incitywide analytics projects.

What You Should Bring

• Foundational Technical Skills:Familiarity with ELTandETL processes and toolsincludingGUI-based platforms like Microsoft Data Factory, AWS Glue, or Tableau Prepand/or coding languagessuch as R, Python, or SQL.

• Data Management Mindset: Eagerness to learn and apply best practices in organizing, centralizing, and enriching datasets.

• Attention to Detail: Ability to transform raw data intoaccurate, curated datasets for analysis and decision-making.

• Team-Oriented and Curious: Comfortable collaborating across departments and learning on the job in a fast-evolving space.

• Creative Problem Solving: A thoughtful, analytical approach to addressing challenges with practical, data-driven solutions.

• Strong Communication: Ability to explain technical issues to both technical and non-technical audiences.

• Public Service Motivation: Passion for using data to improve services andbenefitthe Alexandria community.

Why Join Us?

• Be part of building a new citywide data strategy that will shape the future of data-driven decisions, public transparency, and AI in Alexandria.

• Work on impactful, citywide projects thatwill improvethe services provided to the Alexandria community.

• Contribute to a collaborative, team-oriented culture that values growth, learning, and professional development.

• Join an award-winning data and analytics organization, nationally recognized for innovation and excellence in the public sector.

• Flexibility – theCityis committed to work/life balance, as such thisopportunity is hybrid,providing the potential to work up totwo days a week remotely

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