- Develop Power Automate workflows and integrations to automate business processes and improve delivery.
- Proven experience with RPA (robotic process automation) is a must.
- Develop stored procedures, scripts, and database views to automate manual and/or recurring processes.
- Develop database objects to optimize BI data structures and processes.
- Develop interfaces in Power Apps, as needed, to support BI applications.
- Developing and managing business intelligence solutions for the organization.
- Support Data Analysts in the development of advanced dashboard capabilities that may require programming/scripting, e.g. pulling in 3rd party/API data.
- Design, develop, and maintain complex T-SQL queries, stored procedures, packages, and other database objects to extract, transform, and load data from various sources into the data warehouse or data mart.
- Communicate internally and with clients externally to collect and validate data and answer questions regarding reports and data.
- Act as a subject matter expert on the BI Development processes and mentor less experienced colleagues.
- Apply advanced knowledge and understanding of concepts, principles, and technical capabilities to manage various projects.
- Recommends new practices, processes, and procedures.
- Provides solutions that may set a precedent or have a significant impact.
- Support the broader business team from the standpoint of ad-hoc reporting requests, complex queries, and evaluating the business.
- Assist in how we handle reporting or data requests.
- A bachelor's degree in a related field is preferred, but equivalent years' experience is considered.
- Must have experience building BI solutions in the Azure ecosystem with tools such as Power Automate, Power Apps, Data Flows, and Power BI
- Advanced SQL / T-SQL experience.
- Programing skills in PowerQuery, DAX, M preferred (python nice to have)
- At least five to seven years of data-related or analytical work experience.
- Ability to grasp database structures and understand the underlying relationships and dependencies.
- Comfortable compiling data integration from multiple sources; performing quality control on data sets; identifying and scrutinizing anomalies and/or outliers in the data; ability to manipulate data and complete required analysis.
Sr BI Developer - Norwich, United Kingdom - Baldwin Risk Partners
Description
When, Millennial Specialty Insurance ("MSI") partnered with Baldwin Risk Partners in 2019, we were a single-product tech-enabled renters insurance platform with only 18 colleagues. Today, MSI has grown to over 900 colleagues with more than 10 insurance products thru a combination of rapid organic growth and strategic, tech-enabled partnerships. Our goal is to produce proprietary products to our customers that are fast, easy to use, and customizable with a deep focus on the customer experience. We believe that through our scalable, tech-enabled, proprietary platform and products, we will fundamentally change the insurance industry. Internally, we are dedicated to a culture that has innovation at its core and providing a world class colleague experience. Since 2021, we have tripled our colleague headcount to support the growth of the business. MSI is looking for top talent to join our journey as we continue to grow. Come join us at Millennial Specialty Insurance, the MGA of the Future
Position Summary:
The Senior BI Developer will be responsible for expanding MSI's technical capability and automation practices within its Business Intelligence organization. This person will act as a developer, focused on helping the BI team to accelerate delivery of content through creating and maintaining BI-Focused database structures, scripts, stored procedures, automation/scheduling capabilities, and various programmatic methods to support data wrangling, visualization, and advanced Power BI capabilities. While this role will focus on the creation of visualizations, it will help drive reporting automation strategy and improving velocity of BI deliverables. The ideal candidate will have strong problem-solving skills, direct experience with Azure automation tools such as Power Automate, and advanced SQL skills.
Principal Responsibilities:
·Collaborating with colleagues for the purpose of collecting and structuring data.
·Collect, audit, compile, and validate data from multiple sources.
Education, Experience, Skills, and Abilities Requirements:
Special Working Conditions:
Fast-paced, multi-tasking environment.
Important Notice:
This position description is intended to describe the level of work required of the person performing in the role and is not a contract. The essential responsibilities are outlined; other duties may be assigned as needs arise or as required to support the organization. All requirements may be modified to reasonably accommodate physically or mentally challenged colleagues.
#LI-BM1
#LI-REMOTE
Click for some insight into our culture