As a global market leader, iPipeline combines technology, innovation, and expertise to deliver ground-breaking, award-winning software solutions that transform the life insurance, financial services, and protection industries. With one of the industry’s largest data sets, we help advisors/advisers and agents to transform paper and manual operations into a secure, seamless digital experience – from proposal to commission– so they can help better secure the financial futures of their clients. At iPipeline, you’ll play a major role in helping us to provide best-in-class, transformative solutions. We’re passionate, creative, and innovative, and together as a team, we continually strive to advance, accelerate, and expand the reach of our technology. We value different perspectives and are committed to creating an environment that embraces diverse backgrounds and fosters inclusion. We’re proud that we’ve been recognized as a repeat winner of various industry awards, demonstrating our excellence and highlighting us as a top workplace in both the US and the UK. We believe that the culture we’ve built for our nearly 900 employees around the word is exceptional and we’ve created a place where our employees love to come to work, every single day. Come join our team About iPipeline Founded in 1995, iPipeline operates as a business unit of Roper Technologies (Nasdaq: ROP), a constituent of the Nasdaq 100, S&P 500®, and Fortune 1000® indices. iPipeline is a leading global provider of comprehensive and integrated digital solutions for the life insurance and financial services industries in North America, and life insurance and pensions industries in the UK. We couple one of the most expansive digital and automated platforms with one of the industry’s largest data libraries to accelerate, automate, and simplify various applications, processes, and workflows – from quote to commission – with seamless integration. Our vision is to help everyone achieve lasting financial security by delivering innovative solutions that connect, simplify, and transform the industry. iPipeline is proud to be an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to gender, race, color, religious creed, national origin, age, sexual orientation, gender identity, physical or mental disability, and/or protected veteran status. We are committed to building a supportive and inclusive environment for all employees. This is an office-based position. As a Business Intelligence Analyst at iPipeline, you will work on new and existing data products that provide business insights to our customers, primarily using SQL and SSRS. Working as part of a scrum team, you are actively involved in the refining and planning of stories that are ready to be included in our sprint cycles, giving opinions on how we can approach them (where required) and providing estimates to the Data Product Manager. During development you work on change requests or creating new products, ensuring that they meet the acceptance criteria. You will work with a tester and other Bi Analysts and Developers to make sure the code is functioning correctly and meets our coding standards through a code review. In some cases, you will liaise with other departments outside the scrum teams to confirm requirements or you require their input to complete the goal; this can include the Data Delivery team, DBAs (Database Administrators). Once code has been tested, you oversee its deployment, ensuring that affected parties have been notified and are expecting the change, and that the deployment won’t affect any currently running reports and processes. Where necessary, you create process notes and other supporting documentation. Responsibilities: Developing and maintaining the suite of Data Analytics products and bespoke customer solutions. Building new and adapting existing SSRS Report RDLs. Developing, creating and maintaining SQL Server objects inside the Reporting database. Understanding the structure and utilisation of SQL Server objects inside the MiWarehouse and Quotatio databases. Maintaining the extraction procedures that transform the data from MiWarehouse into usable Reporting data. Creating supporting documentation for new and changing processes to be supplied to Data Delivery. Supporting the QA Tester with creating test plans, designing tests and generating test outputs for developed pieces of work. Refining backlog items by working with stakeholders to understand their requirements, and creating stories that are ready for a developer to begin working on. Responding to incidents by identifying the source of the problem and seeking a resolution. Reporting any bugs, mistakes in data, or data leaks to the relevant people and escalating where needed. Identifying, reporting and reducing technical debt. A to coding standards and code peer reviews. Supporting other developers with SQL-based code reviews. Identifying and escalating capacity and performance issues. Reducing performance issues wherever possible or required. Creating proof of concepts for new products and demonstrating them to the product owner and stakeholders to understand and analyse further requirements. Partaking in and delivering team training and knowledge sharing to enhance skills and knowledge. Providing appropriate support on queries raised by the Delivery team in the Data Development Teams Channel. SQL code development. Knowledge of relational database design. SSRS report building. Ability to work with others. Strong communication skills – including the ability to present complex technical specifications to non-technical users and stakeholders. Effective time management skills. Initiative to think of process innovations. We offer a competitive compensation and benefits package, opportunities for career growth, Pension plan with company-matched contributions, generous time off and flexible work/life balance, an employee wellness program, and an awards and recognition program – all in a creative, fast-growing, and innovative company.