Overview
Remote
$60 - $80
Full Time
Skills
SSAS
Cube
DAX
MDX
Data
Architect
Job Details
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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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