Azure Data Engineer | Artech LLC

Job Description: Azure Data Engineer

Experience: 2–3 Years

Employment Type: Full-Time

About Artech LLC

Artech LLC is a global workforce solutions and IT services company that connects businesses with skilled talent and technology expertise. Its offerings span workforce solutions, managed services, and project delivery, supporting organizations with flexible teams, operational efficiency, and innovation across markets including the United States, Canada, India, and the Philippines.

Role Overview

We are seeking an experienced Data Engineer to design, develop, and maintain enterprise-scale Data Warehouse solutions. The ideal candidate will be responsible for building robust data pipelines, optimizing data models, managing large-scale data platforms, and ensuring high-quality, trusted data assets that support analytics, AI, and business decision-making.

The candidate will be responsible for designing, developing, and maintaining scalable data pipelines, data warehouses, and data lakes. The role will involve working with cloud-based data platforms and collaborating with technical and business teams to deliver reliable, high-quality data solutions. Experience in AI-enabled data solutions is highly desirable.

Key Responsibilities

Data Warehouse Development

• Design, develop, and maintain enterprise Data Warehouse solutions.

• Build and manage dimensional data models including Fact and Dimension tables.

• Implement Star Schema designs.

• Define and maintain enterprise data architecture standards.

Data Engineering & ETL

• Design and build ETL/ELT pipelines for structured and unstructured data sources.

• Develop scalable data ingestion, transformation, and integration frameworks.

• Ensure data quality, integrity, reconciliation, and validation.

• Implement automated data processing and orchestration workflows.

• Support batch and near real-time data processing requirements.

SQL & Data Optimization

• Develop and optimize complex SQL queries, stored procedures, functions, and views.

• Perform database tuning, query optimization, and performance monitoring.

• Ensure efficient storage utilization and processing performance across data platforms.

Cloud Data Platform Engineering

• Develop and support cloud-based data ecosystems.

• Build and maintain solutions using:

o Azure Data Factory (ADF)

o Azure Synapse Analytics

o Azure Data Lake Storage Gen2

o Databricks

• Support migration and modernization of legacy data platforms.

Data Governance & Security

• Implement data governance, metadata management, lineage, and data quality standards.

• Ensure compliance with organizational security policies and regulatory requirements.

• Support audit readiness and data protection initiatives.

Collaboration & Solution Delivery

• Work closely with business stakeholders, architects, application teams, and data consumers.

• Participate in solution design, code reviews, testing, deployment, and production support.

• Create and maintain technical documentation and architectural artifacts.