Senior BI Developer

KEY RESPONSIBILITY AREAS:

• Manage BI solutions (portals, dashboards, standard, and ad-hoc reporting) with a specific focus on data management and data warehouse architecture.
• Provide technical direction and mentoring to a team of developers who develop and build solutions using enterprise data tools (Access, SSRS, SSIS, SQL Server, Power BI, Power View, and Scribe).
• Ensure team members are following best practices within the SDLC structure while overseeing, planning, and estimating project needs.
• Maintain resource forecasts and resolve resource conflicts and risks.
• Ensure utilization of investment allocated to the team through the balance of projects, goals, and training.
• Design and develop dimensions, hierarchies, and cubes.
• Develop calculated measures using MDX.
• Design and deploy reports in SharePoint; Dynamics 365 is a plus.
• Provide oversight and mentoring to the BI Development team.
• Achieve and maintain relevant technical competencies and help foster an environment of continuous growth and learning among colleagues on existing and emerging technologies.
• Pass certification exams and strive to become a recognized expert on key technologies.

PREFERRED EDUCATIONAL BACKGROUND FOR THIS ROLE:

• Bachelor's degree in Computer Science, Information Systems, or a related field.

FOR ANYONE TO SUCCEED IN ANY ROLE, WITH THE TECHNICAL KNOWHOW, THE RIGHT KIND OF BEHAVIOUR IS MUST:

• Passion for technology with the knowledge of how to inculcate that in work.
• Enthusiasm and a positive outlook towards any undertaking.
• Adaptability and ability to cope with ambiguity and change.
• Ability to work independently on responsibility areas with minimal supervision and take ownership for the same.
• Collaborative skills to work in tune with team members when required for certain projects.
• Good client interface skills, which in turn require good communication skills.

SKILLS AND EXPERIENCE REQUIRED FOR THIS ROLE:

• Minimum 5 years of experience with enterprise-class ETL/BI tools (Microsoft SQL/SSRS/SSIS/SSAS/Power BI).
• Deep analytical experience and understanding of typical information technology processes.
• Experience in Azure Data Factory integration and Azure Integration Services.
• Experience with software testing, report writing, and database management.
• Experience with requirements gathering and documentation processes.
• Experience with FetchXML is a plus.
• Experience with designing packages in SSIS.
• Experience with Scribe, Dynamics 365, and Power BI is a big plus.

Skills

Azure Data Factory, BI, Power BI, SQL Server, SSAS, SSIS, SSRS