Job description

We are seeking a seasoned Solution Architect to lead the design and delivery of analytics solutions built on Microsoft Fabric and Power BI. This role is ideal for a strategic thinker with deep experience in business intelligence who can translate complex business questions into actionable insights, architect scalable solutions, and guide clients through the modern Microsoft data stack. While this is not a hands-on data engineering role, a strong understanding of the Fabric ecosystem and a proven track record of enabling data-driven decision-making through Power BI are essential. About JourneyTeam Founded in 1993, JourneyTeam has grown from a small software consulting shop into an award-winning, business technology consulting firm. JourneyTeam is a Microsoft Gold Certified Partner and serves needs of large public and private organizations, including many of the world’s best-known brands. JourneyTeam’s expert level consultants dive deep into the dynamics of an organization to solve complex issues that improve a company’s sales, marketing, productivity, collaboration, accounting, and security. The company provides consulting and implementation services specifically for Microsoft Dynamics 365 and Office 365 solutions, including Microsoft Dynamics CRM, Microsoft Dynamics Financials, Dynamics GP, Microsoft’s Enterprise Mobility and Security Suite, SharePoint, Okta and more. Key Responsibilities Analytics & Insight Leadership • Engage with clients to understand business objectives and translate them into high-impact analytics solutions. • Design semantic data models and reporting strategies that uncover trends, enable KPIs, and drive strategic decisions. • Apply domain expertise to help clients frame the right questions, select effective visualizations, and craft compelling data narratives. Solution Architecture & Delivery • Architect scalable analytics solutions using Microsoft Fabric and modern, cloud-native data architecture principles. • Optimize Power BI datasets, reports, and dashboards for performance, usability, and alignment with business goals. • Establish frameworks for reusability, self-service analytics, and governance in enterprise BI environments. Technical Project Leadership & BI Development • Lead technical workstreams across multiple BI projects, ensuring adherence to architectural standards and best practices. • Collaborate with consultants, developers, and data engineers to ensure accurate and efficient implementation. • Contribute hands-on to BI development as needed, particularly in semantic model design, DAX optimization, workspace management, and performance tuning. • Own the technical success of projects from kickoff to deployment, managing risks and ensuring high-quality deliverables. Client Engagement & Thought Leadership • Facilitate workshops, discovery sessions, and roadmap planning with business and technical stakeholders. • Provide expert guidance on Power BI adoption and data strategy. • Educate clients on the evolving Microsoft Fabric ecosystem and how to maximize its business value. Qualifications • 5+ years of experience in analytics and BI roles, with Power BI as the primary delivery tool. • Deep knowledge of Power BI architecture, including advanced DAX, Power Query, RLS, and semantic modeling. • Experience leading enterprise BI initiatives and building analytics programs. • Familiarity with data governance, security models, workspace architecture, and deployment pipelines. • Strong client-facing skills with the ability to uncover insights, tell data stories, and guide decision-making. • Understanding of data engineering and modeling principles (hands-on pipeline development not required). • Microsoft Certification: PL-300 Power BI Data Analyst. • Microsoft Certification: DP-600 Fabric Analytics Engineer, preferred. • Strong grasp of Microsoft Fabric concepts — including OneLake, Direct Lake, Lakehouse architecture, Dataflows Gen2, Pipelines, Notebooks, and Power BI integration, preferred. • Exposure to Azure Synapse, SQL, Data Factory, Azure Data Lake, and Azure SQL Database, preferred. • Experience with Python and/or R for data analysis, statistical modeling, and automation — including tasks such as data cleaning, exploratory analysis, visualizations, and integrating with BI platforms for advanced analytics, preferred. • Embrace and live the JourneyTeam Values: • A Caring Mindset • Exceptional Performance • Making and Keeping Commitments • Being OneTeam • Taking Ownership • Effective Communication • A Growth Mindset Compensation Base salary range of $100,000 – $120,000, + performance-based bonus program. Eligibility and payout are tied to individual contributions, team performance, and company success. This is the established pay range for the Solution Architect role on the Business Intelligence and Analytics practice at JourneyTeam. Actual compensation is dependent on demonstrated skills, relevant experience, and alignment with the role’s responsibilities. In general, new employees can expect to start at the lower end of the range (with opportunity to grow and expand within the organization). Benefits JourneyTeam offers a wide range of excellent benefits, including comprehensive healthcare and dental coverage, as well as a 401(k) with an approximate 4% employer match—with immediate vesting. We offer flexible time off, with employees averaging 3.75 weeks per year, and provide paid maternity and paternity leave. Additional perks include a monthly phone stipend (or the option to join our corporate phone plan) and a monthly gym membership reimbursement of up to $200. JourneyTeam is an Equal Opportunity Employer. This position is not open to C2C, H1B sponsorships, or third-party agencies. JOB CODE: 1000060

Requirements