Senior Full-Stack BI Architect / Fabric Data Engineer

Proactive Technology Management

Ferndale (WA)

Remote

USD 140,000 - 190,000

Full time

8 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Competitive compensation

Shape data strategy and lead BI/ data‑

Professional development and training

Inclusive, innovative culture

Flexible remote work arrangements

Health, dental, and vision insurance

401(k) retirement plan with company‑匹

Job summary

Proactive Technology Management in the United States seeks a Senior Full-Stack BI Architect / Fabric Data Engineer to design enterprise-grade data solutions using medallion architecture and domain-driven design. You will build scalable ETL/ELT pipelines and dashboards that translate complex data into actionable insights.

The role requires expertise in the Microsoft Cloud Data Stack, DAX, Power Query M, SQL, Spark Python, and data modeling.

Qualifications

Bachelor's or Master's degree in Computer Science, Engineering, Data Science, or related field; advanced certifications in data engineering or BI are a plus.
7+ years of experience in data engineering, BI architecture, or related role, with enterprise-grade solutions.
Deep expertise in medallion architecture, data modeling (star/snowflake), and data warehousing best practices.
Proven ability to apply domain-driven design principles, ensuring data solutions reflect business domains and ubiquitous language.
Expert proficiency in Power BI, DAX, Power Query M, and SQL with a track record of scalable BI solutions.
Strong programming skills with Spark Python for advanced data processing and analytics.
Experience with Microsoft Cloud Data Stack (Azure Data Factory, Azure Synapse Analytics, Microsoft Fabric) and other cloud tech.
Ability to translate complex datasets into intuitive insights for technical and non-technical stakeholders.

Responsibilities

Lead ETL/ELT pipelines within a medallion architecture (Bronze, Silver, Gold) for data quality, scalability, and accessibility.
Architect and develop advanced data models reflecting domain-driven design and ubiquitous language.
Design and implement star and snowflake schemas with medallion schema practices for analytics.
Create dynamic, user-centric dashboards and reports in Power BI for real-time insights.
Leverage DAX and Power Query M for sophisticated calculations and transformations.
Build and optimize SQL-based data integration and database solutions.
Use Spark Python for processing large datasets and advanced analytics.
Collaborate with business leaders to define KPIs and align data solutions with goals.
Stay updated on BI/data engineering trends and mentor team members.

Skills

Medallion architecture

Domain-driven design

Ubiquitous language

Data modeling (star/snowflake)

Leadership & mentoring

Stakeholder collaboration

Problem solving

Education

Bachelor's or Master's 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'retransforming howbusinesses harness data to drive innovation and informed decision-making. As leaders in the SMB space, weleveragecutting-edgetechnologies to deliver actionable insights that give our clients a competitive advantage.We'reseeking aSenior Full-Stack BI Architect / Fabric Data Engineerto 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 designthrough the use ofubiquitous language and domain-driven principles.You willleveragedeepexpertisein medallion architecture, advanced data modeling, and visualization to ensure our clients receive intuitive, actionable insights. Your technicalexpertisein 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 amedallion architecture(Bronze, Silver, andGoldlayers) to ensure data quality, scalability, and accessibility across use cases.

Architect and develop advanced data models that reflectdomain-driven design principles, aligning with business domains and usingubiquitous languageto ensure clarity and usability for all stakeholders.

Design and implement star and snowflake schemas, along withmedallion 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 andoptimizeSQL-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 orMaster’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-depthexpertiseinmedallion architecture, data modeling (star schemas, snowflake schemas), and best practices for data warehousing.

Proven ability to implementdomain-driven design (DDD)principles, ensuring data solutions reflect business domains and are accessible through ubiquitous language.