Social network you want to login/join with:
* Solid hands-on experience with Microsoft Technology Stack (2022)
* Extensive experience of SQL/ data warehousing
* Proven experience of data engineering activities such as release management, environment controls, CICD pipeline orchestration.
* Experience working with Python and Power BI
* Proven ability of Microsoft BI software development including database / reporting development, full development cycle
* Strong data modelling, problem solving, information analysis, attention to detail, flexibility of approach.
* The ability to deal directly with business functions and interpret their thoughts into successful data & analytics solutions.
* The ability to design and develop complex BI/MI solutions in line with agreed architectural principles and toolsets.
* Capable of working closely with the business and delivering complex requirements to tight timescales.
* Strong interest in latest data engineering technologies, best practices, techniques and trends in the data industry
Required Toolsets:
* Kimball data modelling
* Microsoft SQL Server
* Python, MDX, DAX
Responsibilities
The Data Manager will be responsible for supporting the Head of Data and Analytics and the wider business to build and deliver components of an effective enterprise data management platform for WRBU, utilizing Microsoft Technology stack for data ingestion, transformation & storage, and Power BI for end-user data analytics and reporting. The role will play a critical part in the architectural design and implementation of these elements—capable of meeting a wide range of financial and underwriting reporting/analytics needs. It will involve a mix of hands-on technical leadership, team management, and stakeholder relations, supporting WRBU to develop its data platform on next-generation technology.
* Data Support: Assist the Head of Data and Technology as a Subject Matter Expert in Data. Act as a senior custodian of the WRBU Data Platform; administer ETL/ELT pipelines, conduct peer/code reviews, ensure data integrity and accuracy.
* Data Warehousing: Help manage the data warehousing landscape and data movements, assist with solution design for new and existing requirements. Collaborate with the business to understand needs. Design and develop ETL/ELT processes, data lake storage architecture, data warehouse, data marts, cubes, reports, and dashboards in line with the company data management framework and enterprise data strategy.
* MI Development and Maintenance: Support the development and maintenance of Management Information (MI). Gather requirements, develop specifications, develop, test, and roll out reports. Support ongoing report production and resolve production issues.
* Data Validation: Develop and implement validation checks for data entry based on business rules, in line with Solvency II, Sox, and business requirements. Collaborate with the wider business and manage data engineering activities to meet new data requirements using appropriate architecture components.
* Data Governance: Support the implementation and development of data governance policies. Manage data in line with Solvency II and Sox requirements. Prioritize and develop new reports or data extracts, and communicate progress and delivery timescales.
* Market Messages: Ensure timely processing of market messages and resolve issues promptly.
* MI Projects: Review and sign off on MI project requirements, support project lifecycle, assess requirements, and build data solutions. Develop WRBU-specific data management policies, processes, and standards.
J-18808-Ljbffr