Azure Data Warehouse Developer

JOB SUMMARY:

The Azure Data Warehouse Developer will leverage Delta Lake/OneLake and Medallion Architecture (Bronze-Silver-Gold) to manage and transform data efficiently. Your background in end-to-end SDLC, alongside your expertise in performance tuning and governance, will drive impactful data solutions for our organization and setting the foundation for future AI-driven insights.

ESSENTIAL JOB DUTIES:

• Data Warehouse Development: Help design, development, and implementation of a scalable and efficient data warehouse using Azure Fabric using the Medallion Architecture.
• Design & Development: Implement and maintain robust data pipelines on Azure (Data Factory, Synapse), handling structured, semi-structured, and unstructured data. Data Modeling: Develop and implement complex data models that support data analytics, reporting, and future AI initiatives.
• Collaboration: Work closely with reporting, data analysts, and business stakeholders to understand data needs and translate them into technical requirements.
• AI Readiness: Prepare the data warehouse infrastructure to support future artificial intelligence and machine learning projects, ensuring data is structured and accessible for advanced analytics.
• Best Practices & Standards: Establish and enforce best practices for SQL development, data governance, and security within the data warehouse environment.
• Documentation: Maintain comprehensive documentation of data warehouse architecture, ETL processes, and data models.
• Give development teams advice, thought leadership, and mentoring to help them enhance their cloud competencies.
• Ensure application size, performance, and up time while upholding strict code quality criteria.
• Manage cloud environments in compliance with the organization's security policies.
• Utilize Cloud's automation technology possibilities.
• SDLC & DevOps: Lead and improve CI/CD pipelines, version control, and automated testing strategies for reliable deployments and upgrades.
• Other duties as assigned.

QUALIFICATIONS:

The qualifications listed below are representative of the elements required to perform the job successfully, however in some cases, an equivalent combination of Education, Training, Certifications and Experience may meet the job qualifications.

Education, Training, Certifications:

• High school Diploma, or equivalent, required.
• Bachelor's or Master's degree in computer science, information technology, or relevant discipline, strongly preferred.
• Cloud certifications in the specialized area, strongly preferred.

Experience, Knowledge, Skill Requirements:

• 5+ years of experience in SQL development and data warehousing with a proven 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 in Azure data services (Data Lake Storage, Data Factory, Synapse, etc.).
• Proven experience with transactionally consistent data lake solutions, ACID compliance, and time-travel features.
• Experience with data integration and ETL tools, preferably in an Azure environment.
• Proficient in data modeling techniques, including star and snowflake schemas.
• Experience with AI and machine learning technologies is a plus.
• Experience in several of the following areas: database architecture, ETL, business intelligence, advanced analytics.
• Proven ability to collaborate with teams of business analysts, developers, and SMEs.
• Excellent project management skills and strong ability to prioritize, preferred.

Communication Skills:

• Must have the ability to effectively read, write and communicate in English with employees and customers.

Other Qualifications:

• Valid driver's license with acceptable driving record required.
• Must be able to comply with SFPH's Drug and Alcohol policy and Background screening requirements, which may also include customer-specific requirements based on contractual agreement.

PHYSICAL & WORK ENVIRONMENT REQUIREMENTS:

Reasonable accommodations may be made to enable individuals with disabilities to perform Essential Job Duties.

Physical Requirements:

While performing the duties of this job, the employee is required to sit for long periods. Employees will occasionally be required to bend, kneel, balance, lift <20lb, walk, stand, ascend/descend stairs, drive, twist, and reach above and below shoulders.

Work Environment:

Employee will consistently be required to work indoors in an office setting, work alone and with others. Office settings are mild to moderate temperatures.

We are fully committed to equal opportunities for employment to all individuals regardless of race, national origin, gender, religion, sexual orientation, disability, familial status, and any other classification protected under the law. We are an Equal Opportunity, Affirmative Action employer.
While this job description is intended to be an accurate reflection of the position, management reserves the right to modify, add, or remove duties and to assign other duties as necessary.