Microsoft Analytics Developer
- Vancouver, BC, V5C 6E3, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Posting language
- English
- Posted
Original job description
Job Description:
We are seeking a Microsoft Analytics Developer to support the migration of existing Cognos reports and cubes to a Microsoft-based analytics platform and the development of new reports, dashboards, and data cubes. The successful candidate will work closely with business and technical stakeholders to understand reporting requirements, translate business needs into technical specifications, design and develop data models, and identify and monitor key performance indicators. The role will involve hands-on development and optimization of Power BI, DAX, SSAS, SSRS, SSIS, and SQL Server, including semantic models, dashboards, reports, data warehouses, security models, and performance optimization. The consultant will also be responsible for data validation, reconciliation, data quality, production support, troubleshooting, technical documentation, and user training. The role requires strong communication and stakeholder-management skills, the ability to work with users at different levels, and the flexibility to support infrastructure, data migration, and cloud migration activities as required.
Requirements
- Advanced Microsoft Power BI development, including DAX
- Strong data modeling, data design, management, and visualization
- Advanced SQL Server and complex SQL development
- Hands-on experience with SSAS (SQL Server Analysis Services)
- Hands-on experience with SSRS (SQL Server Reporting Services)
- Hands-on experience with SSIS (SQL Server Integration Services)
- Experience developing and managing data warehouses
- Experience with Tabular or Multidimensional Cubes
- Experience implementing Data/Row-Level Security
- Experience with data validation, reconciliation, and data quality
- Power BI semantic models, dashboards, reports, and performance optimization
- Ability to translate business requirements into technical specifications
- Experience working with BI business requirements, KPIs, and data models
- Strong business analysis, stakeholder communication, and client management skills
- Ability to provide technical documentation, training, and production support
- Experience with ETL tools such as SSIS or Informatica
- Experience with BI/reporting tools such as Cognos Report Studio, Tableau, or Cognos
- Ability to work effectively with both technical and business users
More about this job
Responsibilities
The developer will migrate existing Cognos reports to a Microsoft-based platform and develop new dashboards, data models, and cubes. They will also be responsible for data validation, performance optimization, and providing technical support and training to stakeholders.
Requirements
Candidates must have advanced experience with Power BI, DAX, and the SQL Server stack including SSAS, SSRS, and SSIS. Strong data modeling skills and the ability to translate business requirements into technical specifications are essential for this role.
Skills
- Power BI
- DAX
- SQL Server
- SSAS
- SSRS
- SSIS
- Data Modeling
- Data Warehousing
- ETL
- Cognos
- Data Validation
- Performance Optimization
- Business Analysis
- Stakeholder Management
- Technical Documentation
- Data Visualization
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Software
- Consulting
Keywords
- Microsoft Analytics
- Power BI
- DAX
- SSAS
- SSRS
- SSIS
- SQL Server
- Data Modeling
- Data Warehousing
- Cognos
- ETL
- Business Intelligence
- Data Validation
- Performance Optimization
- Semantic Models
- Dashboards
- Reporting
- Data Quality
- Stakeholder Management
- Technical Documentation
- Cloud Migration
- Tabular Cubes
- Multidimensional Cubes
- Row-Level Security
- Informatica
- Tableau
- Report Studio
- KPIs
- Data Migration
- Infrastructure