[Remote] Data Operations BI Developer

Note: The job is a remote job and is open to candidates in USA. 1st Central is a market-leading insurance company that focuses on utilizing smart data and technology. They are seeking a Data Operations BI Developer to maintain and monitor the performance of their data warehouse, develop new processes, and enhance existing ones for accurate reporting and informed decision-making across business areas.

Responsibilities

• You’ll produce timely and accurate information and reports for management decision-making purposes
• You’ll maintain SAS & SQL queries and Power BI Dashboards that can be utilised within the BI environments
• You’ll liaise with other departments to understand their requirements from the systems and BI reports, particularly in relation to live issues
• You’ll assist in the identification of root causes and fixes for major incidents where required
• You’ll create and update technical documentation and follow business processes
• You’ll work closely and engage directly with the business when needed for requirements gathering
• You’ll participate in designing system data models, data integrations and automated data management solutions
• You’ll performance monitor the data and reporting platforms
• You’ll identify and feedback any potential improvements to new and existing reporting BI solutions
• You’ll facilitate knowledge sharing and engage effectively with third party providers
• You’ll work effectively within the Data Governance and Data Quality Frameworks
• You’ll ensure compliance with company and other relevant standards / regulations at all times (Including TCF)
• You’ll adhere to all development and operational processes and standards within the team, identifying and proposing opportunities for improvement where appropriate

Skills

• Strong skills in PySpark, Python, SQL, Power BI and SAS
• Solid experience in cloud data technologies, preferably Azure
• Ability to work on own initiative with strong problem-solving skills
• Expert in data reporting and visualisation using Power BI with strong query and DAX skills
• Extensively familiar with ETL (Extraction, Transformation & Load), data warehousing and business intelligence tools
• Strong programming experience is required, particularly SQL
• Experience in Microsoft data components including Azure Analysis Services & Azure SQL Data Warehouse (Synapse Analytics)
• Working with a customer focus within a commercial environment
• Experience of working with large data sets in an enterprise environment
• Experienced working in a structured development environment (preferably Agile)
• Strong analytical skills, with the ability to adopt a logical approach to solving problems
• Data exploration, cleansing and preparation
• Strong knowledge of data structures and operational data sources
• Knowledge of Data Warehousing principles
• Understanding of the metrics used to analyse motor insurance
• An understanding of software development lifecycles
• Experience of testing tools and performance monitoring
• Excellent SQL and Power BI skills
• Solid experience in cloud data technologies preferably Azure
• Ability to work on own initiative
• Problem solving skills, especially the ability to develop efficient solutions to BI problems
• Good communication skills, both verbal and written
• Strong IT skills
• An organised and pro-active approach
• Logical thinker with solid reasoning ability
• Commercially and operationally focussed
• Ability to work on own initiative and as part of a team
• Self-motivated and enthusiastic
• A flexible approach and positive attitude
• Emphasis on attention to detail and accuracy
• Strives to drive business improvements to contribute to the success of the business
• Understanding or experience of Agile, Waterfall, and Software Development Life Cycles
• SAS programming skills
• Mathematical, Statistical or Computing qualification
• Microsoft Certified qualifications
• Insurance or Financial services background
• Good experience of motor insurance products
• Good general insurance knowledge
• Knowledge of FCA requirements (including TCF)

Company Overview

• 1st CENTRAL offer a 5 Star Defaqto rated car insurance product. It was founded in 2008, and is headquartered in Haywards Heath, West Sussex, GBR, with a workforce of 1001-5000 employees. Its website is https://www.1stcentralinsurance.com/.

Apply tot his job Apply To this Job