SSAS Data Architect NO SUBS/NO Sponsorship Must be clearable Federal Contract

NO SUBS/NO SPONSORSHIP-Must be clearable-Federal Contract

NO H-1B

SSAS SME-Data Architect

Best practices when developing and architecting SSAS and all SQL Development.

Knows coding inside and out, break/fix, performance tuning, troubleshooting and these additional requirements.

• Gathered user requirements.
• Analyzed and implemented database changes requested by users.
• Developed reports using efficient data retrieval techniques.
• Updated functional specifications and technical design documents.
• Designed and developed SSAS databases and OLAP cubes, MDX queries for ad-hoc analytic research and automated reporting using Snowflake and Star Schemas.

• Excel in data migration, database administration, and query optimization techniques.

1. Designing and Developing Cubes:
• SSAS developers create multidimensional and tabular cubes to organize and aggregate data for efficient querying and reporting.
• They design dimensions, hierarchies, measures, and calculate members within the cubes.
• These cubes serve as the foundation for business intelligence (BI) applications and reporting tools.
2. Data Modeling and ETL (Extract, Transform, Load):
• SSAS developers work closely with data architects and business analysts to understand requirements.
• They model data by defining relationships, aggregations, and calculations.
• ETL processes are set up to extract data from various sources, transform it into the desired format, and load it into SSAS cubes.
3. Query Optimization and Performance Tuning:
• Developers optimize MDX (Multidimensional Expressions) and DAX (Data Analysis Expressions) queries for efficient cube processing.
• They fine-tune cube performance by adjusting aggregation levels, partitioning, and indexing.
4. Security and Access Control:
• SSAS developers implement security measures to control access to data within cubes.
• They define roles, permissions, and user access levels to ensure data confidentiality and integrity.
5. Integration with Reporting Tools:
• SSAS cubes are integrated with reporting tools like SQL Server Reporting Services (SSRS) or other BI platforms.
• Developers create reports, dashboards, and visualizations based on the cube data.
6. Troubleshooting and Maintenance:
• When issues arise, SSAS developers troubleshoot cube processing errors, query performance bottlenecks, and data inconsistencies.
• Regular maintenance tasks include processing cubes, updating dimensions, and monitoring server health.
7. Collaboration and Documentation:
• Effective communication with stakeholders, data modelers, and business users is crucial.
• Documentation of cube designs, data lineage, and best practices ensures knowledge transfer and smooth operations