Job description
Data Architecture SME
Location: Remote
SweetRush has an exciting opportunity for a talented professional to join our Custom Learning Project team! This is a fully remote position with the flexibility to work from anywhere, as long as you are available during US business hours.
Who We Are
SweetRush is a consulting, design, and staffing firm specializing in HR-related services that help foster life-centered businesses and organizations. Our work includes designing unique learning experiences using agency-level graphics and leading-edge technology; creating high-performing cultures, leaders, and teams; and helping our clients grow their learning teams with qualified professionals.
Many of our clients are household names with large international operations, while others are small nonprofits whose work we value as essential to the world. We try to balance the work we do for profit with the work we do to spread good things in the world.
SweetRush is a leader in the field of learning and development, making use of emerging technologies (like VR and AR), games, storytelling, chatbots, interactive virtual and in-person experiences, and so on, all while grounding our work in vibrant and impactful human-centered design. The many awards we win every year reflect the care we put into our craft and our collaborations with clients. We’ve been grateful to have won awards with Hilton, Google, Bridgestone, Adidas, SHRM, and numerous others.
We are a completely virtual, tight-knit, talented community that spans the globe, a culture-forward team that values diversity, respect, and caring. Our folks tend to stick around, as do our clients.
We like to think we stand apart from competitors for the uniqueness and innovation of everything we create—and for who we are. And we’re committed to hiring talent that’s as creative, innovative, and caring as everyone on our team. This is where you come in…
About the Role
We are seeking a dynamic and knowledgeable Subject Matter Expert (SME) to play a key role in the development and delivery of a certification program focused on Microsoft Data Architecture for Modern Data Stacks. The successful candidate will leverage their deep expertise in designing, implementing, and managing modern data architecture using Microsoft Fabric, Azure, and Power Platform tools to shape the curriculum, create training materials, and empower learners with practical skills in areas such as unified data lakes, lakehouse and data warehousing patterns, data ingestion, transformation, orchestration, and advanced data governance. This role requires a strong passion for education, excellent communication skills, and the ability to effectively convey complex technical information to support beginner, intermediate, and advanced architects.
This is a 6-month freelance contract, offering up to 30 hours per week. We’re targeting a start date in mid to late June 2025. Onboarding will be compensated at $275.00 USD, not to exceed 10 hours.
As this is a freelance position, we’re seeking individuals with a proven track record of successfully managing freelance engagements and multiple client relationships.
Responsibilities:
- Collaborate with a team of learning experience designers to help create and validate training materials.
- Review a skills task or job task analysis for accuracy and completeness, providing feedback on essential vs. nice-to-know tasks and suggesting improvements.
- Review a high-level program outline and provide feedback on the order and complexity of topics for the intended audience.
- Review a detailed program outline, ensuring alignment with the high-level program outline, and helping to confirm that content is presented in the correct order and format.
- Validate AI-generated content to ensure it conforms to learning objectives and is technically accurate.
- Support creation of content-specific graphics such as tables, flow charts, screen captures, etc.
- Create any assets required to make demonstrations that showcase specific procedures and skills.
- Create recordings of software demonstrations and related audio scripts.
- Coordinate with learning experience designers to build out the assets, steps, and technical elements needed for hands-on projects such as exercises, labs, and projects.
- Be available during US business hours, M-F, for content reviews, questions, and occasional meetings.
- Work on Sweetrush systems for all work, including email, messaging platform, and cloud-based file storage systems.
- Log time weekly and invoice time monthly.
Essential Tools & Platforms
- Microsoft Fabric
- OneLake
- Fabric Lakehouse
- Fabric Data Warehouse
- Data Factory (Fabric)
- Dataflows Gen2
- Event Streams
- Data Activator
- Microsoft Purview
- Power BI
- Copilot in Fabric
- Copilot Studio
- Azure Monitor
- Azure Stream Analytics
- Microsoft Entra ID (formerly Azure AD)
- SQL Server / T-SQL
- Visual Studio Code (for development, if applicable for notebooks/scripts)
Required Skills & Experience
- Proven hands-on experience designing, building, and optimizing modern data architectures using Microsoft Fabric, including OneLake, Fabric Lakehouse, Fabric Data Warehouse, Data Factory (Fabric), Dataflows Gen2, Event Streams, Data Activator, Microsoft Purview, and Power BI.
- Demonstrated ability to architect and implement unified data lakes with OneLake, leveraging open data formats (Delta, Parquet, Iceberg), and medallion architectures (bronze/silver/gold zones). Skilled in building and managing Lakehouse solutions using Delta tables, managed folders, and notebooks.
- Expertise in designing, deploying, and querying Fabric Data Warehouses with advanced T-SQL, including schema design (star, snowflake, data vault), partitioning, indexing, and compute scaling. Experience with distributed and replicated tables, and DirectLake mode for high-speed analytics.
- Practical experience creating robust ETL/ELT pipelines using Data Factory (Fabric), mapping dataflows, notebooks, and SQL transformations. Skilled in handling schema evolution, parameterization, error handling, and performance tuning. Experience with real-time data processing using Event Streams and Data Activator.
- Deep understanding of data governance using Microsoft Purview, including data cataloging, classification, sensitivity labeling, lineage visualization, and compliance mapping (GDPR, HIPAA). Ability to define domain ownership, stewardship, and glossary terms within Purview.
- Proficiency in enforcing identity and access control with Microsoft Entra ID, configuring row-level and column-level security, and applying RBAC and service principal authentication across Lakehouse, Warehouse, and Power BI. Experience with auditing, monitoring, and securing data architectures.
- Strong experience building reusable Power BI semantic models, defining DAX measures, implementing incremental refresh, and leveraging DirectLake connectivity. Skilled in designing and publishing secure, interactive dashboards and embedded analytics solutions.
- Ability to recognize and apply Lakehouse, Warehouse, Mesh, and hybrid patterns based on business needs. Experience with performance optimization, cost control, modular design, and decentralized domain architectures.
- Familiarity with Copilot in Fabric, Data Agents, and AI-powered automation in Power BI for pipeline generation, natural language querying, and workflow optimization. Demonstrated success designing, reviewing, and delivering hands-on labs, real-world projects, and portfolio artifacts (architecture diagrams, pipeline configs, governance plans, BI reports) for intermediate data professionals.
- Exceptional ability to articulate complex technical concepts clearly for diverse audiences. Experience creating technical documentation, screencasts, and video tutorials. Strong understanding of adult learning principles and instructional best practices.
- Experience in reviewing training materials for technical accuracy and clarity.
- A strong understanding of adult learning principles is a plus.
- Essential experience in training, learning, and development, or teaching.
- Proven ability to create and deliver effective screencasts and video tutorials.
- Strong ability to articulate complex technical concepts in an accessible manner.
- Availability to work during the US time zones’ business hours.
Qualifications
- Bachelor’s or Master’s degree in Computer Science, Data Engineering, Information Systems, or a related technical field.
- 5+ years of hands-on experience designing, building, and deploying complex data solutions specifically on Microsoft Fabric, Azure data services, and Power Platform, covering areas like data lakes, lakehouses, data warehouses, ETL/ELT, and governance.
- Demonstrable expertise with key Microsoft data services and tools, including, but not limited to, Microsoft Fabric, OneLake, Fabric Lakehouse, Fabric Data Warehouse, Data Factory (Fabric), Microsoft Purview, Power BI, Event Streams, and Data Activator.
- Proven experience in technical training, learning & development, or teaching, with a strong ability to create, review, and deliver high-quality, technically accurate training materials (e.g., course outlines, hands-on exercises, video tutorials).
- Exceptional technical communication skills, including the ability to articulate complex concepts clearly to diverse audiences and a strong understanding of adult learning principles.
- Strong problem-solving, debugging, and communication skills.
SweetRush Is an Equal Opportunity Employer
We are committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment. All employment decisions are based on business needs, job requirements, and individual qualifications, without regard to race, color, religion, or belief; national, social, or ethnic origin; sex (including pregnancy); age; physical, mental, or sensory disability; HIV status; sexual orientation, gender identity, and/or expression; marital, civil union, or domestic partnership status; past or present military service; family medical history or genetic information; family or parental status; or any other status protected by the laws or regulations in the locations where we operate. SweetRush will not tolerate discrimination or harassment based on any of these characteristics. We encourage applicants of all ages.
Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.
Call to Action:Submit Your Resume!
Team chemistry is everything to us, so our ultimate goal is to find the right fit. If the above describes your interests and experience, and you believe this will be a dream job, please submit your resume. We are excited to hear from you!
Please note: We’re all about remote work and have collaborators based all around the world; however, SweetRush is a US-based company, and English is our primary language. If you’d like to be considered for this opportunity, please submit your resume in English.
SweetRush believes in transparency and fairness. And for that reason, all of our active searches are available on the SweetRush “Join Us” page athttps://www.sweetrush.com/join-us/. You can also find a handful of openings posted on our LinkedIn company page under the “Jobs” tab athttps://www.linkedin.com/company/sweetrush/jobs/.
Unfortunately, cybercriminals take advantage of good people. Please know that SweetRush would never ask for your personal information such as SSN, banking information, credit cards, etc. during the application or interview process. Always be mindful to protect your personal and financial information, and use careful judgment when providing information to recruiters or talent acquisition professionals.
