Data Engineer

About Zeus Fire and Security

Zeus Fire and Security was established in 2022 to build a national network of fire protection and security providers recognized for execution excellence across a variety of service lines and end markets. Zeus addresses customers’ fire protection and security needs through a broad array of services from mission critical fire system installation, testing, and inspection to physical security system installation and video monitoring. Zeus was established with the purpose of partnering with industry-leading fire and security operators who are seeking a collaborative growth partner dedicated to inspiring and accelerating the long-term growth of business and team members. Zeus operates Alert Alarm and Security Resources Pacific of Hawaii, SMG Security of Illinois, national-account provider UAS, Independent Alarm of New Jersey, PASS Fire and Security of Missouri, Martin Systems of Wisconsin, Bayside Fire and Security and Absolute Security Group of Maryland, and Gallaher & Associates of Tennessee. For more information, please visit https://www.zeusfireandsecurity.com.

Role Overview

The Data Engineer occupies a pivotal position within our organization, responsible for extracting actionable insights from our data resources. This role necessitates a candidate with a strong foundation in SQL development, a discerning proficiency in data analysis, and a mastery of crafting persuasive visualizations using Power BI. Collaboration with diverse cross-functional teams is integral, involving the collection, analysis, and presentation of data, all in support of data-driven decision-making processes.

Key Responsibilities

• Design, construct, and manage the enterprise data warehouse and data architecture on the Azure platform.
• Develop and optimize data pipelines using Azure Data Factory, implementing CDC mechanisms for real-time data processing.
• Manage and enhance database solutions with SQL Server, leveraging T-SQL for complex data manipulation and extraction.
• Adept knowledge on DBT and leveraging that to create various data models.
• Utilize Azure Synapse for large scale data analytics solutions, optimizing data storage and performance.
• Create insightful, actionable PowerBI reports and dashboards to meet business analysis needs.
• Engage in data migration projects, ensuring accuracy and integrity of data transfers.
• Work directly with the product owner to understand and fulfill data requirements, ensuring that the data architecture supports and enhances business processes.
• Implement and maintain strict data governance practices to ensure data security, quality, and compliance with industry standards, particularly in financial environments.
• Document all systems, processes, and metadata to maintain transparency and sustainability of the data architecture.
• Other duties as assigned.

Qualifications

• Bachelor’s or Master’s degree in Computer Science, Information Systems, Data Science, or a related field.
• 3-5 Years experience with T-SQL and a proven track record in developing and managing large scale data warehouses.
• Experience using Data Build Tool (DBT)
• Strong experience with Microsoft Azure services, including Azure Data Factory, SQL Server, and CDC.
• Proficiency in creating and managing PowerBI reports.
• Experience with Fabric preferred.
• Demonstrable experience with data migrations and handling sensitive financial data.
• Deep understanding of data governance principles and practices.

Work Requirements:

• The position is considered sedentary and requires extended periods of telephone and PC exposure.

EEOC Statement

Zeus provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.