SSAS Cube Developer
Posted 1 day ago by 1761720143
Negotiable
Outside
Remote
USA
Summary: The SSAS Cube Developer role involves designing and delivering scalable data solutions by building and maintaining SSAS cubes. The developer will integrate data from Salesforce and other systems to enable advanced analytics and reporting. This position requires a strong background in SSAS cube development and data modeling. The ideal candidate will possess problem-solving skills and effective communication abilities with both technical and business stakeholders.
Key Responsibilities:
- Design and develop SSAS cubes, including dimensions, hierarchies, and measure groups.
- Write and optimize MDX queries and calculations to support business reporting.
- Create star schema models (facts and dimensions) to organize and structure data.
- Build and maintain ETL processes (SSIS) to extract and transform data from Salesforce and other sources.
- Manage cube deployment, processing, security, and performance optimization.
Key Skills:
- Proven experience with SSAS cube development and MDX.
- Strong SQL skills and hands-on experience with SSIS/ETL pipelines.
- Solid understanding of dimensional modeling and data warehouse design.
- Experience integrating Salesforce or other enterprise data sources.
- Strong problem-solving skills and ability to communicate effectively with technical and business stakeholders.
Salary (Rate): undetermined
City: undetermined
Country: USA
Working Arrangements: remote
IR35 Status: outside IR35
Seniority Level: undetermined
Industry: IT
SSAS Cube Developer
About the Role
We are looking for a talented SSAS Cube Developer to join our team and help design and deliver scalable data solutions. In this role, you will build and maintain SSAS cubes, integrate data from Salesforce and other systems, and enable the business to unlock powerful insights through advanced analytics and reporting.
What You ll Do
- Design and develop SSAS cubes, including dimensions, hierarchies, and measure groups.
- Write and optimize MDX queries and calculations to support business reporting.
- Create star schema models (facts and dimensions) to organize and structure data.
- Build and maintain ETL processes (SSIS) to extract and transform data from Salesforce and other sources.
- Manage cube deployment, processing, security, and performance optimization.
What We re Looking For
- Proven experience with SSAS cube development and MDX.
- Strong SQL skills and hands-on experience with SSIS/ETL pipelines.
- Solid understanding of dimensional modeling and data warehouse design.
- Experience integrating Salesforce or other enterprise data sources.
- Strong problem-solving skills and ability to communicate effectively with technical and business stakeholders.
Bonus Points
- Performance Tuning aggregations, partitions, and query optimization/Experience tuning cubes and queries for large or complex datasets.
- Salesforce Data Understanding knowing which objects and relationships to pull (Accounts, Opportunities, etc.)
- Reporting Tools connecting Excel or Power BI to the cube for analysis