Senior Full-Stack BI Architect / Fabric Data Engineer

Proactive Technology Management

full-time

Posted on: 1/16/2026

Location Type: Hybrid

Location: Ferndale • Missouri • United States

✨ AI Apply

About the role

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.

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

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

ETLELTdata modelingstar schemassnowflake schemasDAXPower Query MSQLSpark Pythondata warehousing

Soft Skills

problem-solvingattention to detailcommunicationleadershipcollaborationstakeholder engagement

Certifications

Bachelor’s degreeMaster’s degreeadvanced certifications in data engineeringadvanced certifications in BI