Senior Full-Stack BI Architect / Fabric Data Engineer

Proactive Technology Management; United States; Remote; USD 140,000 - 210,000; Full time

Benefits offered by this job

Competitive compensation

Lead BI projects

Professional development

Diversity & inclusion

Flexible remote work

Health insurance

401(k) plan

Job summary

Proactive Technology Management is seeking a Senior Full-Stack BI Architect / Fabric Data Engineer to design and implement enterprise-grade data solutions that prioritize domain-driven design and human-centric analytics. You will lead medallion architecture, star/snowflake schemas, and scalable pipelines in the Microsoft Cloud Data Stack, delivering intuitive dashboards in Power BI for senior stakeholders.

This role requires 7+ years in data engineering or BI, deep SQL, Spark Python, DAX, Power

Qualifications

• Bachelor’s or Master’s degree in Computer Science, Engineering, Data Science, or related field.
• 7+ years of experience in data engineering, BI architecture, or related role with enterprise-grade solutions.
• In-depth expertise in medallion architecture, data modeling (star/snowflake), and data warehousing best practices.
• Proven ability to implement domain-driven design (DDD) principles with ubiquitous language.
• Expert-level proficiency in Power BI, DAX, Power Query M, and SQL with scalable BI solutions.
• Strong programming skills with Spark Python for data processing and analytics.
• Experience with the Microsoft Cloud Data Stack (Azure Data Factory, Azure Synapse Analytics, Microsoft Fabric).
• Track record translating complex datasets into intuitive insights for technical and non-technical stakeholders.
• Excellent problem-solving, attention to detail, and fast-paced environment adaptability.
• Strong communication and leadership skills with stakeholder engagement.

Responsibilities

• Lead ETL/ELT pipeline design within medallion architecture (Bronze-Silver-Gold) ensuring quality and scalability.
• Architect and develop advanced data models reflecting domain-driven design and ubiquitous language.
• Design star and snowflake schemas and medallion schemas for analytics performance.
• Create dynamic Power BI dashboards and reports delivering real-time insights.
• Utilize DAX and Power Query M for sophisticated calculations and transformations.
• Build SQL-based data solutions for management, queries, and integration.
• Use Spark Python for large-scale data processing and analytics.
• Collaborate with business leaders to define KPIs and align with goals.
• Stay current with data engineering and BI advancements to drive innovation.
• Mentor team members to elevate BI and data engineering practices.

Skills

ETL/ELT design

Domain-driven design

Data modeling

Stakeholder collaboration

Mentoring

Education

Bachelor’s or Master’s degree in CS/Engineering/Data Science

Tools

Power BI

DAX

Power Query M

SQL

Spark Python

Azure Data Factory

Azure Synapse Analytics

Microsoft Fabric

Job description

About Us

At Proactive Technology Management, we're transforming how businesses harness data to drive innovation and informed decision-making. As leaders in the SMB space, we leverage cutting-edge technologies to deliver actionable insights that give our clients a competitive advantage. We're seeking a Senior Full-Stack BI Architect / Fabric Data Engineer to design and implement innovative, domain-driven data solutions that humanize data and empower decision-makers. If you have a passion for making data meaningful and impactful, we want to hear from you!

Role Summary

As a Senior Full-Stack BI Architect / Fabric Data Engineer, you will lead the design and development of robust, enterprise-grade data solutions that prioritize human-centric design through the use of ubiquitous language and domain-driven principles. You will leverage deep expertise in medallion architecture, advanced data modeling, and visualization to ensure our clients receive intuitive, actionable insights. Your technical expertise in the Microsoft Cloud Data Stack, DAX, Power Query M, SQL, and Spark Python will drive success in building scalable, user-friendly solutions.

Key Responsibilities

• Lead the design and implementation of ETL/ELT pipelines within a medallion architecture (Bronze, Silver, and Gold layers) to ensure data quality, scalability, and accessibility across use cases.
• Architect and develop advanced data models that reflect domain-driven design principles , aligning with business domains and using ubiquitous language to ensure clarity and usability for all stakeholders.
• Design and implement star and snowflake schemas, along with medallion schema practices , to provide flexible, high-performance data structures for analytics.
• Create dynamic, user-centric dashboards and advanced reports in Power BI, empowering stakeholders with real-time insights and actionable metrics.
• Leverage DAX and Power Query M to craft sophisticated calculations and transformations that enhance data usability and business relevance.
• Build and optimize SQL-based solutions for database management, queries, and data integration, ensuring efficiency and scalability.
• Use Spark Python for processing large datasets and performing advanced analytics to meet complex business requirements.
• Collaborate with business leaders and cross-functional teams to understand data needs, define key performance indicators (KPIs), and ensure alignment with organizational goals.
• Stay informed on advancements in data engineering, business intelligence, and analytics, continuously driving innovation and improvement.
• Mentor team members to build organizational capacity in BI and data engineering best practices.

Requirements

Qualifications

• Bachelor’s or Master’s degree in Computer Science, Engineering, Data Science, or a related field; advanced certifications in data engineering or BI are a plus.
• 7+ years of experience in data engineering, BI architecture, or a related role, with a focus on enterprise-grade solutions.
• In-depth expertise in medallion architecture , data modeling (star schemas, snowflake schemas), and best practices for data warehousing.
• Proven ability to implement domain-driven design (DDD) principles, ensuring 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, impactful BI solutions.
• Strong programming skills with Spark Python for advanced data processing and analytics.
• Experience with the Microsoft Cloud Data Stack (Azure Data Factory, Azure Synapse Analytics, Microsoft Fabric) and other cloud technologies.
• A track record of translating complex datasets into intuitive insights, creating value for both technical and non-technical stakeholders.
• Exceptional problem-solving skills, 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.

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

If you're ready to lead the next evolution of business intelligence—harnessing the power of medallion architecture, domain-driven design, and user-centric modeling—apply today. Help us transform data into a powerful, humanized tool for business success.