Data Analyst

AllianceIT Inc; Richmond (VA); Remote; USD 60,000 - 100,000; Full time

Job summary

An innovative firm is seeking a skilled Data Analyst to support the design and delivery of secure and scalable data pipelines in Azure. This role focuses on integrating and transforming sensitive datasets, ensuring data quality and auditability. The ideal candidate will have hands-on experience with Azure-native tools, strong ETL/ELT capabilities, and a commitment to responsible data use. Join a dynamic team in a remote work environment where your contributions will enhance transparency initiatives and support regulatory compliance. If you are passionate about data and eager to make an impact, this opportunity is for you.

Qualifications

• 3+ years of experience building ETL/ELT pipelines using Azure-native tools.
• Strong understanding of data quality, auditability, and responsible data use.

Responsibilities

• Support the design and delivery of secure, scalable data pipelines in Azure.
• Build ingestion workflows and transformation logic for reporting and analytics.

Skills

ETL/ELT pipelines

Azure Data Factory

SQL

Python

PySpark

Delta Lake

Data Lake Storage Gen2

Data quality frameworks

DevOps/DataOps practices

Data masking and encryption techniques

Education

Bachelor's degree in Computer Science or related field

Tools

Azure-native tools

Dataflows

Synapse Pipelines

Job description

Job Title: Data Analyst

Work Arrangement: Remote

Location: Local to VA only

Job Description

This position will support the design and delivery of secure, scalable, and traceable data pipelines in Azure, focusing on integrating and transforming sensitive, public-facing datasets. The candidate will build ingestion workflows and transformation logic to support reporting, analytics, and public transparency initiatives. This role requires experience with Azure-native tools, strong ETL/ELT capabilities, and a commitment to data quality, auditability, and responsible data use. The candidate will work with an existing software development team in an Agile/Scrum environment.

Skills & Experience

• At least 3 years of experience building and maintaining ETL/ELT pipelines using Azure-native tools.
• Hands-on expertise with Azure Data Factory, Dataflows, Synapse Pipelines, or similar orchestration tools.
• Proficiency in SQL, Python, or PySpark for transformation logic and data cleansing.
• Experience with Delta Lake, Azure Data Lake Storage Gen2, JSON, and Parquet formats.
• Ability to build modular, reusable pipeline components with metadata-driven approaches and robust error handling.
• Familiarity with public data sources, government transparency datasets, and publishing workflows.
• Knowledge of data masking, PII handling, and encryption techniques for sensitive data.
• Experience with data quality frameworks, including automated validation, logging, and reconciliation methods.
• Strong understanding of DevOps/DataOps practices, including versioning, testing, and CI/CD for data pipelines.
• Experience supporting data publishing for oversight, regulatory, or open data initiatives is highly desirable.
• Certifications such as DP-203 or Azure Solutions Architect are a plus.

Additional Details

• Seniority Level: Mid-Senior level
• Employment Type: Contract
• Job Function: Information Technology
• Industries: IT Services and IT Consulting

Referrals can double your chances of interviewing at AllianceIT Inc. Set job alerts for similar roles such as Associate Data Analyst, Business Intelligence Analyst, Business Analyst, and Business Performance Analyst.