Data Engineer

Zeus Fire and Security • Paoli, PA

6d

About The Position

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.

Requirements

• 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.
• Demonstrable experience with data migrations and handling sensitive financial data.
• Deep understanding of data governance principles and practices.

Nice To Haves

• Experience with Fabric preferred.

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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 11-50 employees