Senior Full-Stack BI Architect / Fabric Data Engineer

Proactive Technology Management • Ferndale, MI

15h • Remote

About The Position

At Proactive Technology Management, the Senior Full-Stack BI Architect / Fabric Data Engineer will lead the design and development of enterprise-grade data solutions that prioritize human-centric design through ubiquitous language and domain-driven principles. The role uses medallion architecture, advanced data modeling, and visualization to deliver intuitive, actionable insights for clients.

The position applies expertise in the Microsoft Cloud Data Stack, DAX, Power Query M, SQL, and Spark Python to build scalable, user-friendly solutions. It also involves collaborating with business leaders and cross-functional teams, translating business needs into data solutions, and mentoring team members in BI and data engineering practices.

Requirements

• Bachelor’s or Master’s degree in Computer Science, Engineering, Data Science, or a related field.
• 7+ years of experience in data engineering, BI architecture, or a related role, focused on enterprise-grade solutions.
• In-depth expertise in medallion architecture, data modeling—including star and snowflake schemas—and data warehousing best practices.
• Proven ability to implement domain-driven design principles so data solutions reflect business domains and are accessible through ubiquitous language.
• Expert-level proficiency in Power BI, DAX, Power Query M, and SQL, with demonstrated success delivering scalable BI solutions.
• Strong programming skills with Spark Python for advanced data processing and analytics.
• Experience with the Microsoft Cloud Data Stack, including Azure Data Factory, Azure Synapse Analytics, and Microsoft Fabric, as well as other cloud technologies.
• Ability to translate complex datasets into intuitive insights for technical and non-technical stakeholders.
• Strong problem-solving skills and attention to detail, and ability to thrive in a fast-paced, dynamic environment.
• Strong communication and leadership skills, with a focus on collaboration and stakeholder engagement.

Nice To Haves

• Advanced certifications in data engineering or business intelligence.

Responsibilities

• Lead the design and implementation of ETL/ELT pipelines within Bronze, Silver, and Gold medallion architecture layers to ensure data quality, scalability, and accessibility.
• Architect and develop advanced data models based on domain-driven design principles and ubiquitous language.
• Design and implement star and snowflake schemas, as well as medallion schema practices, for flexible, high-performance analytics.
• Create dynamic, user-centric Power BI dashboards and advanced reports that provide real-time insights and actionable metrics.
• Use DAX and Power Query M to develop calculations and transformations that improve data usability and business relevance.
• Build and optimize SQL-based database, query, and data integration solutions.
• Use Spark Python to process large datasets and perform advanced analytics.
• Collaborate with business leaders and cross-functional teams to understand data needs, define KPIs, and align solutions with organizational goals.
• Stay informed about advances in data engineering, business intelligence, and analytics, and drive innovation and improvement.
• Mentor team members in BI and data engineering best practices.

Benefits

• Competitive compensation tailored to senior-level expertise.
• Opportunities to shape data strategy and lead transformative BI projects.
• Ongoing professional development through advanced training and certifications.
• A supportive, innovative culture that values diversity, inclusion, and creativity.
• Flexible remote work arrangements to support work-life balance.
• Comprehensive health, dental, and vision insurance.
• 401(k) retirement plan with company match.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior