Full Stack BI Developer MMH250304-3
Summary
Build and tune ETL pipelines, data warehouses, and Power BI dashboards using Azure Synapse, SSIS, and SQL Server to deliver insurance-focused business intelligence solutions.
Design and develop ETL processes, data integration, data warehousing, performance tuning, data modelling, and business intelligence reporting modules to deliver high-quality Business Intelligence solutions.
Role Purpose
Design and develop ETL processes, data integration, data warehousing, performance tuning, data modelling, and business intelligence reporting modules to deliver high-quality Business Intelligence solutions.
Requirements
- Appropriate 3/4 year IT qualification
- Relevant Microsoft certification within the Data Space
- Exposure to the full BI development life cycle
- At least 4 – 6 year experience in the BI / Data Engineering Data / Analytics Field
- Experience managing Data Projects
- Data Engineering Experience in Azure preferred
- Azure Data Factory/Synapse Pipelines experience essential
- The successful candidate should have experience with SSRS, SSIS and SSAS, SQL Server, Synapse Pipelines, Physical & Logical Database architecture knowledge.
- Power BI required
- Proficiency in SQL
- Experience with Big Data and Data Science beneficial
- Understanding of insurance / accounting principles will be highly beneficial
- Knowledge of Data Transformation Services, File Transfer Protocol
- Good understanding of Data Warehouse architectures and supporting areas (Data Transformation, Modelling and Reporting)
- Intensive troubleshooting and problem-solving skills
- Comfort with managing business stakeholders
- Experience in developing business intelligence solutions in large or midsize companies
- Development experience with the Microsoft BI stack (including SSIS, SSRS, SSAS, Data Management)
- Experience using Power BI to analyze data and report conclusions
Duties & Responsibilities
- Participate in the analysis, design, development, troubleshooting, and support of the enterprise reporting and analytics platform.
- Design, construct, test, and implement reporting, visualization, and dashboard processes that present summary-level reporting with functionality to drill down into details.
- Develop BI solutions using SQL, ETL scripting with ADF/Synapse Pipelines, business intelligence tools, database programming, and reporting tools on the Microsoft BI Stack.
- Integrate with diverse source systems, including in-house, vendor-based, on-premises, cloud-based, and Office 365 systems.
- Collaborate with the DevOps team and participate in testing all database-related changes and application updates.
- Handle day-to-day database development/administrative tasks, including the development of queries, views, and other database schema objects.
- Maintain data model schema, hierarchy within the data warehouse, and reporting systems.
- Apply database tuning techniques to improve the performance of current solutions.
- Ensure business continuity documentation through Azure DevOps.
- Enforce database security standards and ensure adherence by team members.
- Review code implementations by the Data team.
- Oversee the quality of BI solutions developed by team members.
- Mentor junior and intermediate team members.
- Drive the implementation of innovative and latest technology solutions related to the data space through collaboration with the Lead Developer and Enterprise Architecture team.
- Utilize junior members in achieving large-scale project developments and implementations in consultation with the lead developer.
Additional Skills
- Ability to manage multiple tasks simultaneously and react quickly to problems
- Skill in translating concepts and directions into practical solutions
- Proficiency in reporting and business intelligence solutions
- Development experience with relational database structures, multi-dimensional databases, and data warehouse design architecture
- Experience with mobile deployment of business intelligence (desired)
- Ability to develop, maintain, review, and explain data models
- Excellent verbal and written communication skills
- Strong team player
- Understanding of the financial services industry, especially insurance (desired)
- Experience with dashboard design and delivery