Data Warehouse Engineer Job at Ledgent Technology, Mendota Heights, MN

dXJLM0QzR2JrV090N0ExaU91Wi85a2RrWFE9PQ==
  • Ledgent Technology
  • Mendota Heights, MN

Job Description

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 $135,000. The role requires onsite presence four 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.

· 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.

Desired Skills and Experience

Azure, Data Warehouse, Azure Data Warehouse, Medallion Architecture,

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.

Job Tags

Local area,

Similar Jobs

Ascendo Resources

Organizational Development - Change Management Job at Ascendo Resources

 ...enhance team cohesion and effectiveness. Develop and deliver executive-level presentations and communications (in both English and Spanish), offering strategic insights and progress updates on OD and change management initiatives. Continuously monitor and refine... 

Medisys Health Network, Inc.

Epic Clindoc Analyst Job at Medisys Health Network, Inc.

 ...Job Description This position is a full-time/salaried-hybrid schedule opportunity based in Hicksville, Long Island. The EPIC System Clindoc Lead System Analyst is responsible for the development, building, implementation, and ongoing maintenance of all aspects... 

The HRT Club

Sales & Marketing Account Manager Job at The HRT Club

 ...hormone replacement therapy (HRT) more accessible, affordable, and stigma-free. As we scale, we need a results-driven Sales & Marketing Account Manager to optimize and accelerate our online and offline healthcare professional marketing efforts. About Us: At The HRT... 

TalentPlug LLC

Elementary School Teacher Job at TalentPlug LLC

 ...Brightest Companies to Work For. Duties and Responsibilities: Teacher in Residence (TIR) is a great way to bring your passion for...  ...of this position/LICENSURE REQUIREMENTS? Elementary education, that includes grades 1-6 (there are several combinations of WI... 

Prosum

Office Associate Job at Prosum

 ...is seeking an Office Associate to join their team on a part time basis. This will be working 2 days a week onsite (8-5PM) Tuesdays and Thursdays Role...  ...for the restrooms etc. ~ Help putting food out for evening events when needed. ~ Help people print and socially interact...