Azure Data Engineer: Pipeline & Warehousing Expert

SmallArc Inc; Washington (District of Columbia); On-site; USD 120,000 - 160,000; Full time

Job summary

SmallArc Inc. is seeking a hands-on Data Engineer with strong Azure experience to design, develop, and maintain scalable data pipelines and datasets that support analytics and operations.

You will work with ADF, Azure SQL, and blob storage, implement data quality and governance, and collaborate with analytics and product teams to deliver secure, well-documented data products while following CI/CD and security best practices.

Qualifications

• Bachelor's degree with 5 years of experience or 4 years with equivalent.
• U.S. citizenship and ability to obtain Public Trust clearance.
• Strong hands-on experience with Azure Data Factory, Blob Storage, and SQL.

Responsibilities

• Design, develop, schedule, and monitor batch and near-real-time data pipelines using ADF.
• Manage Azure Blob Storage, including containers, access tiers, lifecycle policies, and data partitioning.
• Design and optimize Azure SQL databases with schema design and performance tuning.
• Develop dimensional data models using star/snowflake schemas, 3NF, and Data Vault 2.0 concepts.
• Implement data quality, governance, lineage, and schema evolution standards.
• Collaborate with analytics, product, and operations teams to deliver secure data products.
• Apply security best practices, including RBAC, encryption, data masking, and key management.
• Develop reusable components and CI/CD practices.

Skills

Azure Data Factory

Azure Blob Storage

Azure SQL

SQL

Python

ETL/ELT design

Data modeling

Git-based workflows

Azure DevOps

CI/CD practices

Education

Bachelor's degree

Tools

Azure Data Factory

Azure Blob Storage

Azure SQL

Python

Git

Azure DevOps

CI/CD

Data Vault 2.0

Star/Snowflake Schemas

3NF

Job description

SmallArc Inc. is seeking a hands-on Data Engineer with strong Azure experience to design, develop, and maintain scalable data pipelines and datasets that support analytics and operations.

You will work with ADF, Azure SQL, and blob storage, implement data quality and governance, and collaborate with analytics and product teams to deliver secure, well-documented data products while following CI/CD and security best practices.