We are looking for a Business Intelligence (BI) Specialist to design, develop, maintain, and monitor data warehouse and analytics architecture that leading the dashboards and reports. As a BI specialist, you will be creating data architecture and presentation layer within the Microsoft BI Platform to respond to business requirements.
Responsibilities:
Design, optimize, and monitor data infrastructure (data warehouse, OLAP, etc.).
Design and implement ETL pipelines from multiple data sources.
Conduct appropriate data validation and quality checks.
Monitoring query and ETL pipeline performance and ensuring to meet acceptable performance criteria.
Collaborate with business and technology stakeholders to implement best practices for reporting and visualizations.
Create dashboards and reports to answer key business questions, define and monitor KPIs and measures, and support organization members in decision-making.
Creating and maintaining documentation that includes the design, requirements, and user manuals for the organization.
Requirements
Experience in Microsoft BI Stack: SQL Server, SSIS, SSAS (Tabular), and SSRS.
Experience in developing T-SQL.
Proficiency in dimensional modeling techniques.
Strong analytical, consultative, and communication skills.
Practical experience with Power BI or other reporting tools.
Fairly skilled in query and database performance tuning.
Familiar with SQL Server administration tasks.
Familiarity with Python data packages (PyData tools such as Pandas, NumPy, Matplotlib, etc.) is a plus.