Azure Data Warehouse Developer

Ledgent Technology

Twin Cities (CA)

On-site

USD 100,000 - 140,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

A leading company is seeking an experienced Azure Data Warehouse Developer to join their Data & Analytics team. This role involves leveraging Delta Lake and the Medallion Architecture to manage and transform data efficiently. The ideal candidate will have strong expertise in SQL development, data warehousing, and cloud solutions, particularly within Azure. Responsibilities include designing data warehouses, developing robust data pipelines, and preparing infrastructure for AI projects. This is a full-time position requiring onsite presence in Mendota Heights, with a competitive salary range of $100,000 to $140,000.

Qualifications

5+ years in SQL development and data warehousing.
3+ years in architecting Azure solutions.

Responsibilities

Design and implement scalable data warehouses using Azure Fabric.
Develop data pipelines on Azure for various data types.
Prepare infrastructure for AI and machine learning projects.

Skills

SQL Development

Data Warehousing

Collaboration

Project Management

Data Modeling

Education

Bachelor's or Master's in Computer Science

Tools

Azure Data Factory

Azure Synapse

PySpark

Python

Job description

This range is provided by Ledgent Technology. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$100,000.00/yr - $140,000.00/yr

Direct message the job poster from Ledgent Technology

Technical Recruiter at Ledgent Technology

JOB SUMMARY: We are looking for an experienced Azure Data Warehouse Developer to join our Data & Analytics team. This role focuses on leveraging Delta Lake/OneLake and the Medallion Architecture (Bronze-Silver-Gold) to efficiently manage and transform data. The ideal candidate will have expertise in end-to-end SDLC, performance tuning, and governance to develop impactful data solutions, laying the foundation for AI-driven insights.

This is a direct hire position with an annual salary of up to $140,000. The role requires onsite presence five (5) days a week in the Mendota Heights area.

ESSENTIAL JOB DUTIES:

Data Warehouse Development: Design, develop, and implement a scalable and efficient data warehouse using Azure Fabric and Medallion Architecture.
Design & Development: Implement and maintain robust data pipelines on Azure (Data Factory, Synapse) to handle structured, semi-structured, and unstructured data.
Data Modeling: Develop and implement complex data models to support analytics, reporting, and future AI initiatives.
Collaboration: Work closely with reporting teams, data analysts, and business stakeholders to translate data needs into technical requirements.
AI Readiness: Prepare data warehouse infrastructure for AI and machine learning projects, ensuring structured and accessible data for advanced analytics.
Best Practices & Standards: Establish and enforce best practices for SQL development, data governance, and security.
Documentation: Maintain comprehensive documentation of data warehouse architecture, ETL processes, and data models.
Technical Leadership: Provide guidance, thought leadership, and mentoring to development teams to enhance cloud competencies.
Performance & Reliability: Ensure application scalability, performance, and uptime while maintaining strict code quality standards.
Security & Compliance: Manage cloud environments in accordance with organizational security policies.
Automation: Utilize cloud automation technologies to streamline processes.
SDLC & DevOps: Lead and improve CI/CD pipelines, version control, and automated testing strategies for reliable deployments and upgrades.

QUALIFICATIONS:

The qualifications listed below represent the requirements for the role. In some cases, an equivalent combination of education, training, certifications, and experience may meet job qualifications.

Education, Training, Certifications:

Bachelor's or master's degree in Computer Science, Information Technology, or a related field.
Cloud certifications in a specialized area.

Experience, Knowledge, Skills:

5+ years of experience in SQL development and data warehousing, with a track record of designing and delivering production-grade data pipelines in a cloud environment. Experience working with PySpark and Python is required.
3+ years of experience in architecting, designing, developing, and implementing cloud solutions using Azure data services (Data Lake Storage, Data Factory, Synapse, etc.).
Experience with transactionally consistent data lake solutions, ACID compliance, and time-travel features.
Proficiency in data integration and ETL tools, preferably within an Azure environment.
Strong knowledge of data modeling techniques, including star and snowflake schemas.
Experience with AI and machine learning technologies is a plus.
Expertise in database architecture, ETL, business intelligence, and advanced analytics.
Proven ability to collaborate with business analysts, developers, and SMEs.
Strong project management skills and the ability to prioritize effectively.

All qualified applicants will receive consideration for employment without regard to race, color, national origin, age, ancestry, religion, sex, sexual orientation, gender identity, gender expression, marital status, disability, medical condition, genetic information, pregnancy, or military or veteran status. We consider all qualified applicants, including those with criminal histories, in a manner consistent with state and local laws, including the California Fair Chance Act, City of Los Angeles' Fair Chance Initiative for Hiring Ordinance, and Los Angeles County Fair Chance Ordinance. For unincorporated Los Angeles county, to the extent our customers require a background check for certain positions, the Company faces a significant risk to its business operations and business reputation unless a review of criminal history is conducted for those specific job positions.

Seniority level