Brandt is seeking a highly skilled and motivated Data Engineer to join our dynamic team. The ideal candidate will have a strong background in designing, implementing, and optimizing data solutions using PowerBI, Azure, and AI technologies. As a Data Engineer, you will play a crucial role in developing and maintaining efficient data pipelines, ensuring data accuracy, and contributing to business intelligence initiatives.
Duties and Responsibilities
*Data Architecture & Strategy
-Data Solution Design: Lead the architectural design, data modeling, and implementation of highly scalable data processing systems within the Azure Data ecosystem.
*Data Engineering & Optimization
-Advanced SQL & Performance Tuning: Act as the team's primary SQL authority. Proactively identify, troubleshoot, and optimize inefficient queries, fine-tune execution plans, and ensure optimal database performance.
*Business Intelligence & Security
-Data Security & Governance: Implement strict data security measures, including encryption, robust access controls, and data masking to safeguard sensitive enterprise information.
Required Skills:
-Deep SQL Mastery: Expert-level proficiency in SQL (T-SQL preferred). Must have hands-on experience with query optimization, execution plan analysis, indexing strategies, complex joins, window functions, and CTEs.
-Data Modeling: Strong background in relational and dimensional data modeling (Kimball/Inmon methodologies), data warehousing, and data dependencies across enterprise systems.
Required Experience:
-510 years of proven experience in Data Architecture, with a heavy emphasis on Microsoft Azure technologies.
-Bachelor's degree in Computer Science, Information Technology, or a related field (or equivalent enterprise experience).