Azure Data Warehouse Developer

Are you interested in working for the nation’s leading fire protection company and beginning a rewarding and satisfying career that helps save the lives of thousands each year? Do you want to be a part of a growing and expanding team of industry experts? If so, exploring career opportunities with Summit Companies may be right for you!

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 uptime 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. Employee 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.

Summit Companies, through its subsidiaries, is a full-service provider for fire detection, suppression, and security with a full suite of capabilities that includes design, installation, testing, inspections, and maintenance. We serve customers across many verticals on a local, regional, and national scale. We’re proud of our well-deserved reputation for quality work that’s completed by our talented and experienced installation workforce. Summit Companies is a dynamic organization with endless growth opportunities spanning over 100 locations in more than 30 states.

Our company is consistently recognized for service excellence in the fire protection industry. Summit Companies supports trade skills and workforce development by hosting Recognized Apprenticeships and on-the-job training (OJT) programs for new career-seekers. Many members of our leadership team serve as chair on NFPA code compliance committees, serve on regional safety boards, and support technical education in local schools. Summit Companies supports employees in their professional development by offering continued development, training, and education by encouraging NICET and other career-advancing certifications. We continually strive to be the Employer of Choice for highly motivated team members who want to succeed in a high-growth environment. We encourage initiative, independence, diversity, and personal career growth.

The combination of experience, knowledge, and customer service is the key to our performance and helps us achieve our goal of providing the highest quality of fire protection services to protect lives and property.

Benefits

Summit Companies offers extensive training opportunities, career advancement, competitive pay, bonus opportunities, along with an industry leading and affordable benefits package for eligible employees. Our benefits package includes:

• Paid Vacation and Holidays
• Medical Insurance
• Dental Insurance
• Vision Insurance
• 401(k) Plan with Company Match
• Flexible Spending Accounts
• Long-Term Disability – Employer Paid
• Short-Term Disability – Employer Paid
• Additional Voluntary Ancillary Benefits such as Accident and Hospital Indemnity
• Life Insurance for Team Members and Dependents
• Employee Assistance Program
• Employee Referral Program

Our Core Values

PIPE

• We are PASSIONATE about life safety
• We have INTEGRITY (Do the right thing)
• We work in PARTNERSHIP with our customers and community
• We constantly strive for OPERATIONAL EXCELLENCE (Do things right)

Summit Companies participates in E-Verify & in alignment with our commitment to safety, we promote a drug-free workplace. Summit Companies is an equal-opportunity employer committed to diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, gender, gender identity, sexual orientation, age, status as a protected veteran, among other things, or status as a qualified individual with a disability.

#LI-NF1