Senior Solution Architect for Azure, Fabric and Power BI
Apply NowCompany: Frontend Arts
Location: Acton, MA 01720
Description:
Job Description
Senior Solution Architect Microsoft Azure, Fabric & Power BI
The Senior Solution Architect is an experienced Microsoft Azure data and analytics professional with deep expertise in delivering modern analytics platforms using Microsoft Fabric and its predecessor technologies such as Azure Synapse Analytics. The ideal candidate has strong hands-on capabilities, a proven project delivery track record, and holds relevant certifications in Microsoft Azure and Power BI.
This is primarily a delivery role where the candidate will lead implementation teams deploying Microsoft Fabric and Power BI solutions for a wide range of clients. The role demands excellent technical, communication, and people management skills. The candidate will also support pre-sales activities by providing architecture guidance and demonstrating subject matter expertise.
While this is a primarily technical architect role, we highly value the following additional qualifications:
- Functional, data, and business process knowledge in at least one of the following analytics domains: Financial Analytics, Procurement Analytics, Supply Chain Analytics, HR Analytics, Sales, Marketing and CX Analytics, or Manufacturing Analytics.
- Experience extracting and integrating data from Oracle ERP, SCM, and HCM systems such as Oracle EBS, Oracle Fusion ERP, Oracle Fusion SCM, and Oracle Fusion HCM, JD Edwards and Peoplesoft with familiarity in their underlying data models.
Core Technical Expertise:
- Microsoft Fabric (Data Factory, Data Warehouse, Data Engineering, OneLake, Direct Lake, Real-Time Analytics, Power BI, Lakehouse)
- Power BI (data modeling, DAX, report development, Row-Level Security, Power BI Service)
- Azure Data Factory, Azure Data Lake Storage Gen2
- Data engineering (data pipelines, ELT/ETL processes, orchestration)
- Semantic model development and analytics layer design
- SQL, T-SQL, Python
- Performance tuning, optimization, and data governance principles
- Familiarity with medallion architecture concepts
- Basic familiarity with Azure infrastructure and ability to perform platform sizing for Azure, Fabric, and Power BI
- Experience with Azure/Fabric DevOps and Azure/Fabric Security including Entra ID
Preferred Skills:
- Microsoft certifications in Azure and Power BI (e.g., DP-500, DP-600, DP-700, PL-300, DP-203)
- Knowledge of Microsoft Purview, Azure Databricks, Azure Analysis Services
- Experience integrating data from ERP systems such as Oracle, Workday, or SAP
- Familiarity with data governance and MDM platforms (e.g., Informatica, Collibra)
Roles and Responsibilities:
- Lead delivery of modern data architecture solutions leveraging Microsoft Fabric and Power BI
- Serve as technical lead and solution architect for complex client projects
- Collaborate with clients to define data strategy and anaytics requirements aligned with business goals
- Architect scalable and secure solutions for data ingestion, transformation, and visualization
- Provide subject matter expertise during pre-sales cycles including presentations, architecture workshops, and estimates
- Support development of reusable solution accelerators, templates, and go-to-market assets
- Mentor junior team members and provide technical leadership throughout project lifecycles
- Create technical documentation, statements of work, and contribute to client proposals
- Promote internal and external thought leadership through blogs, webinars, and social media
Required Qualifications:
- 10+ years of experience in data architecture and analytics with at least 5 years on Microsoft Azure
- 3+ years of hands-on experience with Power BI and Azure Synapse Analytics
- 1+ years of experience working with Microsoft Fabric
- Strong experience designing and implementing end-to-end Azure-based analytics platforms
- Demonstrated client-facing experience and leadership in delivery roles
- Excellent communication and presentation skills
- Holds relevant Microsoft certifications or willingness to achieve them quickly
Education:
Bachelors Degree in Computer Science, Information Systems, or related field; or equivalent combination of education and experience
Why Apps
Apps Associates has a culture of extreme expertise built on trust and collaboration. Our people are passionate and talented professionals who make a significant and positive difference in our customers lives. We offer excellent benefits, career growth opportunities, training, and certification support so our team can stay ahead of the curve while delivering high-impact client solutions.
*** Equal Opportunity Employer Veterans/Disabled
Senior Solution Architect Microsoft Azure, Fabric & Power BI
The Senior Solution Architect is an experienced Microsoft Azure data and analytics professional with deep expertise in delivering modern analytics platforms using Microsoft Fabric and its predecessor technologies such as Azure Synapse Analytics. The ideal candidate has strong hands-on capabilities, a proven project delivery track record, and holds relevant certifications in Microsoft Azure and Power BI.
This is primarily a delivery role where the candidate will lead implementation teams deploying Microsoft Fabric and Power BI solutions for a wide range of clients. The role demands excellent technical, communication, and people management skills. The candidate will also support pre-sales activities by providing architecture guidance and demonstrating subject matter expertise.
While this is a primarily technical architect role, we highly value the following additional qualifications:
- Functional, data, and business process knowledge in at least one of the following analytics domains: Financial Analytics, Procurement Analytics, Supply Chain Analytics, HR Analytics, Sales, Marketing and CX Analytics, or Manufacturing Analytics.
- Experience extracting and integrating data from Oracle ERP, SCM, and HCM systems such as Oracle EBS, Oracle Fusion ERP, Oracle Fusion SCM, and Oracle Fusion HCM, JD Edwards and Peoplesoft with familiarity in their underlying data models.
Core Technical Expertise:
- Microsoft Fabric (Data Factory, Data Warehouse, Data Engineering, OneLake, Direct Lake, Real-Time Analytics, Power BI, Lakehouse)
- Power BI (data modeling, DAX, report development, Row-Level Security, Power BI Service)
- Azure Data Factory, Azure Data Lake Storage Gen2
- Data engineering (data pipelines, ELT/ETL processes, orchestration)
- Semantic model development and analytics layer design
- SQL, T-SQL, Python
- Performance tuning, optimization, and data governance principles
- Familiarity with medallion architecture concepts
- Basic familiarity with Azure infrastructure and ability to perform platform sizing for Azure, Fabric, and Power BI
- Experience with Azure/Fabric DevOps and Azure/Fabric Security including Entra ID
Preferred Skills:
- Microsoft certifications in Azure and Power BI (e.g., DP-500, DP-600, DP-700, PL-300, DP-203)
- Knowledge of Microsoft Purview, Azure Databricks, Azure Analysis Services
- Experience integrating data from ERP systems such as Oracle, Workday, or SAP
- Familiarity with data governance and MDM platforms (e.g., Informatica, Collibra)
Roles and Responsibilities:
- Lead delivery of modern data architecture solutions leveraging Microsoft Fabric and Power BI
- Serve as technical lead and solution architect for complex client projects
- Collaborate with clients to define data strategy and anaytics requirements aligned with business goals
- Architect scalable and secure solutions for data ingestion, transformation, and visualization
- Provide subject matter expertise during pre-sales cycles including presentations, architecture workshops, and estimates
- Support development of reusable solution accelerators, templates, and go-to-market assets
- Mentor junior team members and provide technical leadership throughout project lifecycles
- Create technical documentation, statements of work, and contribute to client proposals
- Promote internal and external thought leadership through blogs, webinars, and social media
Required Qualifications:
- 10+ years of experience in data architecture and analytics with at least 5 years on Microsoft Azure
- 3+ years of hands-on experience with Power BI and Azure Synapse Analytics
- 1+ years of experience working with Microsoft Fabric
- Strong experience designing and implementing end-to-end Azure-based analytics platforms
- Demonstrated client-facing experience and leadership in delivery roles
- Excellent communication and presentation skills
- Holds relevant Microsoft certifications or willingness to achieve them quickly
Education:
Bachelors Degree in Computer Science, Information Systems, or related field; or equivalent combination of education and experience
Why Apps
Apps Associates has a culture of extreme expertise built on trust and collaboration. Our people are passionate and talented professionals who make a significant and positive difference in our customers lives. We offer excellent benefits, career growth opportunities, training, and certification support so our team can stay ahead of the curve while delivering high-impact client solutions.
*** Equal Opportunity Employer Veterans/Disabled