The Senior Consultant leads client engagements in data and AI solutions, focusing on Microsoft Fabric. Responsibilities include delivering workshops, optimizing data pipelines, and designing architectures with ample client interaction.
Atmosera empowers businesses to redefine what's possible with modern technology and human expertise. Our exceptional experience across Applications, Data & AI, DevOps, Security, and the Microsoft Azure platform enables organizations to accelerate innovation, enhance security, and optimize operational agility. As a Microsoft Partner with seven specializations, GitHub AI Partner of the Year, a member of the GitHub Advisory Board, and a member of the prestigious Microsoft Intelligent Security Association (MISA), Atmosera expertly delivers cutting-edge, integrated solutions that deliver business value.
We are hiring a Senior Consultant to deliver end-to-end data and AI solutions within the Microsoft ecosystem, with a primary focus on Microsoft Fabric. This role is a senior individual contributor operating at an architect-adjacent level, responsible for independently leading client engagements from discovery through production deployment.
This individual will combine deep technical expertise with strong consulting acumen to deliver high-quality outcomes across workshops, assessments, platform implementations, and migrations. After onboarding into our delivery methodology, this role is expected to execute with minimal oversight.
Key Responsibilities
- Independently lead and deliver billable client engagements (target: ~40 hrs/week)
- Execute Atmosera delivery frameworks, including:
- Data Workshops (visioning, requirements, stakeholder alignment)
- Assessments & Blueprinting (current state analysis, target architecture, roadmap)
- Fabric Foundations (platform setup, governance, baseline architecture)
- Production deployments and migrations
- Design and implement scalable, secure, and performant data solutions in Microsoft Fabric
- Own technical architecture decisions
- Communicate effectively with technical and non-technical stakeholders
- Identify risks, tradeoffs, and optimization opportunities during delivery
- Build and optimize data pipelines using Azure Data Factory and Fabric-native tooling
- Develop and tune Spark-based workloads (batch and/or streaming)
- Architect medallion/lakehouse patterns within Fabric
- Implement data modeling, transformation, and orchestration strategies
- Ensure alignment with Azure Well-Architected and data platform best practices
- Facilitate workshops and guide clients through ambiguous problem spaces
- Translate business requirements into technical solutions
- Influence client decisions through structured recommendations
- Maintain a high standard of professionalism and delivery quality
Client Delivery (Primary)
Proof of Value (PoV) engagements
Solution Architecture & Engineering
Consulting & Client Engagement
Required Skills & Experience
- Deep expertise in Microsoft Fabric (end-to-end platform capabilities)
- Strong experience with Azure Data Factory
- Advanced proficiency in Apache Spark (PySpark/Scala preferred)
- Experience designing modern data architectures (lakehouse, medallion, ELT/ETL patterns)
- Strong understanding of Azure data services and ecosystem integration
- Proven ability to independently deliver consulting engagements
- Strong client-facing communication and facilitation skills
- Experience leading workshops, assessments, and architecture design sessions
- Ability to operate with minimal oversight after onboarding
- Embodies Atmosera values:
- Hungry – proactive, driven, continuously improving
- Humble – collaborative, open to feedback, low ego
- Mindful – thoughtful, intentional, and client-aware
- High ownership mentality and accountability
- Strong problem-solving and decision-making capability
Core Technical Expertise
Consulting & Delivery
Professional Attributes
Preferred Qualifications
- Databricks (engineering and/or architecture experience)
- Power BI (modeling, semantic layer design, reporting integration)
- Azure Synapse Analytics (legacy or hybrid environments)
- DP-203: Azure Data Engineer Associate (or Fabric equivalent evolution)
- Microsoft Fabric Analytics Engineer certification
- Azure Solutions Architect Expert
Certifications Strongly Preferred
This is a contractor position in the United States with the ability to work from home but may require travel to a client site.
Atmosera is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. We do not discriminate based upon race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics. All employment is decided on the basis of qualifications, merit, and business need.
Top Skills
Spark
Azure Data Factory
Azure Synapse Analytics
Databricks
Microsoft Fabric
Power BI
Similar Jobs
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
Lead the design of a formal graph system for global infrastructure, ensuring high integrity of data and performance. Architect multi-layered evaluation logic and work cross-functionally with various teams. Mentors a multidisciplinary team and communicates updates to industry analysts.
Top Skills:
GoRust
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
As a Regional Sales Engineer, you'll collaborate with sales teams, maintain customer relationships, provide technical insights on NG-SIEM, and assist in go-to-market strategies.
Top Skills:
Cloud ConceptsKubernetesLinuxLog ManagementOrchestration ToolsSIEMWindowsXdr
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
The role involves designing scalable Kubernetes platforms, optimizing infrastructure reliability, mentoring engineers, and integrating open-source technologies.
Top Skills:
AlertmanagerAWSGCPGoKubernetesOciPrometheusThanos
What you need to know about the Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
