About Business Intelligence Consultant Role
The ideal candidate will possess experience in Microsoft technologies such as SSIS, SSRS / Power BI, and SSAS.
Our team is expanding its expertise in business intelligence solutions and seeks a skilled professional to contribute to the organization's growth. The successful candidate will have excellent technical skills, strong analytical abilities, and effective communication skills.
Key Responsibilities
- Design and Develop BI Solutions : Design, develop, and maintain business intelligence solutions using Microsoft technologies.
- Present Insights : Present insights through reports and visualizations.
- Technical Expertise : Work with Microsoft technologies, developing solutions using the SQL suite (SSIS, SSRS / Power BI, SSAS).
- Requirements Gathering : Translate business needs into technical specifications.
- Data Analytics : Develop and implement ETL processes (SSIS packages, process auditing, notifications, MDS, T-SQL).
- System Maintenance : Maintain and support data analytics platforms.
- BI System Evaluation : Evaluate and improve existing BI systems.
- DWH Layer Development : Create the DWH layer (DWH layer, staging layer, BI relational models).
- Integration : Collaborate with teams to integrate systems.
- Database Queries : Develop and execute database queries and perform analytics (analytical databases : cubes, dimensions, measures, KPIs, actions, MDX, partitions, role security).
- Visualization and Reporting : Create visualizations and reports for requested projects (Reporting Services reports, Power BI, and / or Excel pivot tables).
- Documentation : Develop and update technical documentation.
- Functional Analysis : Perform functional analysis and requirements gathering.
- Client Interaction : Maintain direct client interaction and follow Agile methodologies.
- Power BI Administration : Administer Power BI Service and generate reports.
- Cloud Environment : Work in a Cloud environment (Azure) and its components.
#J-18808-Ljbffr