Skill Set
BI Stack – MS SQL, SSIS, SSAS, SSRS and PowerBI
T-SQL objects
PowerBI Dashboards
ETL components
Requirements analysis
Development and testing of BI solutions (Databases, queries, views, reports and Dashboards)
Data import and export
Job monitoring
Data validation
Responsibilities
Production Support
Ensures troubleshooting of BI tools, systems and software.
Ability to track performance and production issues.
Escalates production issues as appropriate.
Monitors and supports scheduled ETL and cube refresh jobs, ensuring successful completion and accurate data loads into reporting systems.
Takes ownership of job validation, proactively identifying and resolving failures or delays that may impact data availability or quality.
Participates in a rotational working shift schedule, which may include early mornings, evenings, weekends, and public holidays, to support critical business operations and ensure continuous system availability.
Documents production incidents, escalates issues as appropriate, and provides clear communication to stakeholders regarding the status and resolution of job-related issues.
Tracks and reports on system performance and production issues; may assist in performance tuning of BI applications for optimal efficiency.
Reporting and Implementation:
Ability to implement Business Intelligence (BI) solutions using Microsoft BI stack – MS SQL Server, SSIS, SSAS, SSRS and Power BI.
Responsible for the creation of Stored procedures, dashboards, reports and ETL processes.
Learn, use and maintain an established set of tools and technologies, as necessary.
Must be able to follow project Specifications, incorporate coding standards and policies.
Must be able to provide support on the report offerings.
Participates in or supports workstream planning processes.
Collaborates with the Business Analysts to understand customer needs.
Keeps customers informed about business intelligence tool problems and resolutions, timeously.
Develop and Implement
Responsible for collecting, analysing and sharing of data to help business teams drive improvement in key business metrics, customer experience and business results.
Utilizes database and web application technologies to investigate and evaluate processes and can suggest innovative ways of identifying errors.
Develops and tests BI solutions such as databases, queries, views, reports, and dashboards.
Assists in data conversions, imports, and exports of data within and between internal and external software systems.
Documents new and existing models, solutions and implementations.
Design and build reporting and analysis tools that help streamline the business and make reporting, analysing, planning and forecasting more efficient.
Supports and assists with the integration of BI platforms with enterprise systems and applications.
Quality Assurance
Responsible for Performing Quality checks on all work before giving approval to the stakeholder.
Ensures the collected data is within required quality standards.
May maintain the quality of Metadata Repository by adding, modifying, and deleting data.
Qualifications
Degree or diploma in IT or related technical discipline.
Minimum 1+ years proven experience in Microsoft BI Stack (SSIS, SSAS, SSRS, SQL).
Experience in end-user report development.
Experience with data staging (ETL) components.
Ability to support and update existing products, and debugging, monitoring, and troubleshooting BI solutions.
Ability to create efficient T-SQL objects and processes according to spec (databases, tables, stored procedures, business rules and functions).
Experience in T-SQL query optimization, troubleshooting and debugging.
Understanding of database management systems, online analytical processing and ETL framework.
Communicate with various departmental team members to understand the business requirements.
Knowledge of the Kimball data warehouse lifecycle.
Relevant Microsoft SQL certifications.
Apply Before 08/29/2025
go to method of application »
Apply via company website ( N / A ) or