Business Intelligence analyst

Business Intelligence analyst

HCM Nexus Consulting Inc
3-6 years
Not Specified

Job Description

About the job Business Intelligence analyst
The Business Intelligence Analyst is responsible for designing, developing, and maintaining the company's data warehouse architecture. In addition, he/she will also handle report and visualization creation in order to meet the business analysis and reporting needs.

Duties and Responsibilities:
. Design, develop and maintain data models in line with the company's data warehouse architecture. This includes:
o Designing, building and implementing ETL procedures using SSIS, from both internal and outside sources as well as ensure data is verified and quality is checked.
o Designing, developing or extending existing data models using SSAS and DAX.. Collaborate with business and technology stakeholders in ensuring the application and consumption of information from the Data Warehouse.
. Create and maintain reports and visualizations using PowerBI.


. Bachelor's degree in Computer Science, Information Technology, Engineering, or related technical degree.
. 3 years 6 years experience in data warehouse architecture development and management using Microsoft technologies (SQL Server, SSIS, SSAS, Microsoft Azure Data).
. In depth understanding of Data Warehousing concepts, dimensional data models and experience in creating data warehouse schemas.
. Extensive experience in SQL development (preferably in MS SQL Server), creating complex queries to meet desired output or results.
. At least 2 years working experience with Power BI or other reporting and analytical tools like Tableau, QlikView, BOBJ, COGNOS, MicroStrategy, etc.
. Strong analytical, consultative, and communication skills with the ability to make good judgment and effectively communicate with both business and technical users and team members.
. Ability to work effectively within a team environment.
. Ability to work with business users to translate business requirements into technical specifications.

Similar Jobs

People Also Considered

Career Advice to Find Better