Senior Business Intelligence Developer at Progressive Edge

Join a financial services provider with a strong focus on the African continent. They offer a diverse range of insurance and investment solutions that are tailored to meet the unique needs of their clients. Committed to transforming lives and securing a brighter future, they are dedicated to making a positive impact in the communities they serve.

As a potential candidate or employee, joining this company means becoming part of a team that values unity and collaboration. With a solid foundation built on trust, transparency, and integrity, they have earned a reputation as a trusted partner in the financial industry. Their commitment to excellence, combined with a supportive and inclusive work environment, provides employees with opportunities for professional growth and development. Embracing technological advancements and continuous innovation, this company is at the forefront of the industry, ensuring that employees have the tools and resources needed to thrive in a dynamic and evolving landscape.

The Senior Developer is responsible for enhancing the Power-BI reporting solution, the company's data model in its SQL database, and the intermediary engagement platform. The Senior Developer plays a crucial role in designing, developing, and maintaining Power-BI reports. The role requires expertise in Power-BI development, data modelling, data integration, and data visualization, in order to formulate insightful and user-friendly reports and dashboards in conjunction with the Data team.

Core Responsibilities:

Data Storage / Data Warehouse:

• Determine the data storage needs of the company.
• Apply data warehousing concepts to build a data warehouse for internal departments of the organization.
• Create and enhance data solutions enabling seamless delivery of data and is responsible for collecting, resolving, managing, and analysing large sets of data.
• Lead the design of the logical data model and implements the physical database structure and constructs and implements operational data stores and data marts.
• Design, develop, automate, and support complex applications to extract, transform, and load data.
• Ensure data quality.
• Develop logical, and physical data flow models for ETL applications.
• Translate data access, transformation, and movement requirements into functional requirements and mapping designs.

Business Intelligence:

• Collaborate with stakeholders, including business users and senior developers, to gather requirements, and translate them into effective Power-BI reports and dashboards.
• Develop and maintain Power-BI reports, dashboards, and data visualizations using Power-BI Desktop and Power-BI Service.
• Design and implement data models using Power-BI Desktop, ensuring optimal data organization and relationships for efficient reporting.
• Create and optimize DAX (Data Analysis Expressions) queries and calculations to support complex data transformations and aggregations in Power-BI.
• Extract, transform, and load data from various data sources into Power-BI using Power Query or other data integration techniques.
• Collaborate with data analysts to ensure data quality, accuracy, and availability for Power-BI
• Apply data visualization best practices to create visually appealing and user-friendly reports.
• Maintain dashboards to identify reporting issues or gaps and drive timely resolution.
• Monitor and optimize the performance of Power-BI reports and dashboards to ensure efficient data loading and responsiveness.
• Identify opportunities for improvements.
• Implement the best practices in collaboration with other team members.
• Incorporate advanced analytics features, such as forecasting, clustering, or custom R/Python scripts, into Power-BI reports to provide deeper insights.
• Perform data analysis and exploration to identify trends, patterns, and key insights for business.
• Remain updated with the latest Power-BI features, updates, and industry trends to leverage new capabilities and enhance the Power-BI solution.

General:

• Translate business needs to technical specifications.
• Design, build, and deploy BI solutions (e.g., data warehousing models).
• Evaluate and improve existing BI systems.
• Collaborate with teams to integrate systems.
• Develop and execute database queries and conduct analyses.
• Create visualizations and reports for requested projects.
• Develop and update technical documentation.
• Maintain and support data analytics platforms.
• Conduct unit testing and troubleshooting.

Requirements:

• Bachelor's degree in Computer Science or related field.
• Experience as a Senior Developer or similar role.
• Very strong SQL skills with experience in dimensional modelling, design, data mining, online analytical processing (OLAP), ETL (Extract, transform, load) framework.
• Expertise in Power BI development including DAX formulas.
• Experience with Microsoft SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Microsoft BI Stack, Storage Blob, Azure Synapse Analytics Service (formerly known as Azure SQL Data Warehouse), Azure Analysis Service (AAS), Azure SQL Database (Azure SQL DB), Azure Data Factory (ADF) Integration Runtime (IR).
• programming skills using C# language for MVC Applications & Web Jobs.

Core Competencies:

• Analytical skills: Develop and execute complex database queries and conduct analyses to identify trends and patterns in data.
• Problem-solving skills: Troubleshoot issues with data analytics platforms and conduct unit testing to ensure the accuracy of reports.
• Communication skills: Competently translate business needs into technical specifications and collaborate effectively with cross-functional teams.
• Attention to detail: Display a keen eye for detail when creating visualizations and reports for requested projects.
• Adaptability: A Senior Developer should be able to adapt quickly to changing technologies and business needs.
• Teamwork & Collaboration: Work effectively as part of a team and contribute to a positive team environment, as well as be able to collaborate effectively with cross-functional teams.
• Leadership skills: A Senior Developer may be required to lead a team of developers or work independently on complex projects, so leadership skills are essential for success in this role.