Data Analyst with State of Virginia

Vinsys Information Technology Inc; Richmond (VA); Remote; USD 70,000 - 90,000; Full time

Job summary

A leading company in data solutions is seeking a Data Analyst to design and maintain ETL/ELT pipelines. The role involves working with Azure tools, implementing data transformation logic, and ensuring data quality. Ideal candidates will have strong experience in Azure Data Factory and SQL, along with a commitment to data integrity and compliance.

Qualifications

• 3+ years of experience in ETL/ELT pipelines using Azure-native tools.
• Proficiency in SQL, Python, or PySpark for data transformation.

Responsibilities

• Design, build, and maintain ETL/ELT pipelines using Azure-native tools.
• Implement complex data transformation logic and data cleansing workflows.

Skills

SQL

Python

Data Integration

Data Quality

Data Masking

Education

DP-203 Certification

Tools

Azure Data Factory

Synapse Pipelines

Delta Lake

Azure Data Lake Storage Gen2

Job description

Hope you are doing well. We have an open position for a Data Analyst at Richmond, Virginia. Please go through the below description and let me know your interest. If you are interested, kindly share a copy of your resume along with your rate/salary expectations and the best time to reach you.

Client:

Virginia Elect

Location:

Richmond, VA 23219 (Open for Remote)

Job Id:

762942

Responsibilities:

1. Design, build, and maintain ETL/ELT pipelines in enterprise data environments using Azure-native tools.
2. Develop and manage data integration solutions using Azure Data Factory, Dataflows, Synapse Pipelines, or equivalent orchestration tools.
3. Implement complex data transformation logic and data cleansing workflows using SQL, Python, or PySpark.
4. Work with Delta Lake and Azure Data Lake Storage Gen2, handling data in JSON, Parquet, and other modern formats.
5. Design and develop modular, reusable, and metadata-driven pipeline components with robust error handling and logging mechanisms.
6. Ensure responsible management of sensitive data using data masking, PII handling, and encryption techniques.
7. Establish data quality frameworks, including automated validation, reconciliation, and logging methods.
8. Apply DevOps and DataOps best practices such as versioning, automated testing, and CI/CD pipelines for data engineering workflows.
9. Support data publishing for oversight, regulatory compliance, and open data initiatives.
10. Collaborate with stakeholders to leverage public data sources and manage publishing workflows for transparency datasets.

Required Skills & Experience:

1. 3+ years of experience in building and maintaining ETL/ELT pipelines using Azure-native tools.
2. Hands-on expertise with Azure Data Factory, Dataflows, Synapse Pipelines, or similar orchestration platforms.
3. Proficiency in SQL, Python, or PySpark for data transformation and cleansing.
4. Experience with Delta Lake, Azure Data Lake Storage Gen2, and working with JSON, Parquet formats.
5. Expertise in building modular and reusable pipeline components using metadata-driven approaches and implementing robust error handling.
6. Strong understanding of data masking, PII handling, and encryption techniques.
7. Proven experience with data quality frameworks, including automated validation and data reconciliation.
8. Solid grasp of DevOps/DataOps practices, including version control, testing, and CI/CD for data pipelines.
9. Experience supporting data publishing for oversight, regulatory, or open data initiatives.

Highly Desired:

1. Familiarity with public data sources, government transparency datasets, and publishing workflows.
2. Certifications such as DP-203 (Azure Data Engineer Associate) or Azure Solutions Architect.