Kingstone Insurance Company

Develop and implement BI strategies, create dashboards, and collaborate across teams to enhance data reporting and analytics. | Requires at least 4 years in BI or data analysis, proficiency in SQL and BI tools, experience with data architecture and ETL, and industry knowledge in insurance preferred. | Job Summary: We are looking for a Senior Business Intelligence (BI) Data Analyst focused on data reporting and analytics to join our Business Intelligence team. This key technical role will support management in developing and executing BI strategies that drive data-driven decision-making across the organization. You will collaborate closely with cross-functional teams to enhance data processes and modernize our business reporting environment. The ideal candidate will have technical proficiency in data engineering, ensuring the efficient delivery of accurate, timely, and actionable insights through advanced BI tools and analytics. This is a remote position working under EST business hours. Salary Range: $100,000 - $130,000 per year Applicants must be legally authorized to work for ANY employer in the U.S.; Kingstone does not currently sponsor individuals for employment-based visas. What you will do: Develop and Implement BI Strategy: Support management in the development and execution of a BI and reporting strategy aligned with organizational goals to drive growth, profitability, and operational efficiency. Cross-Functional Collaboration: Partner with departments such as Claims, Underwriting/Operations, and Product Management to identify, assess, and prioritize business intelligence needs. Dashboard Development and Management: Design, develop, and deliver management dashboards and key performance indicators (KPIs) that provide actionable business insights. Ensure all reports and dashboards support business users' decision-making process. Analytical Dataset Development: Work alongside other analytical teams to build and maintain reliable analytical datasets that support broader business goals. Continuous Improvement: Drive enhancements in reporting processes and data quality to deliver accurate, timely, and actionable insights for decision-making. Regulatory Reporting: Perform quarterly and annual regulatory statistical reporting to ensure compliance and accuracy. What you will bring: Educational Background: A bachelor’s degree in business administration, Computer Science, Data Science, Statistics, Mathematics, or a related field is required. Professional Experience: At least 4 years of experience in business intelligence, data analysis, or a related role, with demonstrated growth in responsibilities. Industry Expertise: Experience working with a P&C insurance company, ideally with exposure to operational areas such as Underwriting and Claims. Work Authorization: Must be legally authorized to work in the United States now and in the future. Technical Expertise: Proficiency in SQL and BI tools such as Power BI or Tableau, and experience with advanced analytics tools like R or Python is strongly preferred. Data Management: In-depth knowledge of data architecture, data warehousing, and ETL processes. Advanced Analytics: Familiarity with predictive modeling, machine learning techniques, and AI applications is valuable. Industry Knowledge: Strong business acumen with a thorough understanding of the insurance industry's key metrics, challenges, and opportunities. Analytical Skills: Exceptional analytical and problem-solving abilities, focusing on delivering actionable insights that drive decision-making. Project Management: Proven ability to develop detailed project plans, including scope, timelines, and resource allocation, with a strong attention to detail to ensure accuracy and completeness. Collaboration: Strong ability to work collaboratively within a team and across departments, fostering a culture of teamwork and innovation. Adaptability: Flexibility to embrace change and implement new solutions effectively. Communication Skills: Exceptional verbal, written, and presentation skills to convey complex concepts clearly and effectively. What we offer: Comprehensive health benefits Life and disability insurance 401(k) with company match Paid parental leave Paid vacation, paid holidays, and birthday off Peer recognition program

Develop and maintain ETL processes, database queries, API integrations, and collaborate with business units for data reporting in a regulated environment. | Bachelor's degree or equivalent experience, advanced SQL Server skills, Azure Data Factory, Power BI, C# experience, source control, Agile familiarity, and regulated environment experience. | Job Summary: We are looking for an experienced and motivated Data and Software Developer who is ready to take their career to the next level. The perfect candidate would have a passion for building and maintaining high quality ETL processes, database queries and reports, and API integrations that help answer the demands of a fast-growing company, would have proven problem solving and organizational skills, and would enjoy working in a fast-paced environment with a tight-knit and talented team. This is a remote position with occasional visits to our New York office as needed. Salary range: $105,000 - $140,000 What you will do: • Create and maintain ETL/ELT processes for the Data Warehouse. • Design, create and maintain tables, views, and stored procedures in the Data Warehouse and other databases. • Develop and maintain data migration and import/export utilities. • Collaborate with business units to surface data for reporting and analysis. • Create and optimize SQL queries; create and maintain data transformation processes in Azure Data Factory, C#, and Power Query/Power BI. • Integrate with third-party API specifications to import and export data. • Participate in development practices subject to DFS regulations. • Create documentation and participate in code reviews. What you will bring: Required • Bachelor’s degree in computer science, software engineering, or equivalent work experience. • Intermediate to advanced experience in writing, troubleshooting, and optimizing complex SQL queries. • Extensive experience with developing, optimizing, and troubleshooting database queries and objects on the Microsoft SQL Server platform. • Experience with Azure Data Factory and Power BI. • Some professional experience with C#. • Experience using source control tools, preferably GIT with VS Database Projects. • Familiarity with Agile development practices and work-tracking tools, such as Jira. • Experience working in a regulated environment with secure development practices (Sarbanes Oxley, NY-DFS, etc.). • Solid communication skills and ability to communicate with non-technical business stakeholders. Preferred • Knowledge of P&C Insurance industry, product, and rating. • Experience working with cloud data tools such as Azure Synapse and Data Lake Storage. • Experience working with CI/CD tools and processes. • Experience with ADO.Net, Dapper, and Entity Framework. What we offer: • Comprehensive health benefits • Life and disability insurance • 401(k) with company match • Paid parental leave • Paid vacation, sick time, holidays, and birthday • Peer recognition program Please note that Kingstone does not accept unsolicited resumes from recruiters or employment agencies. In the event of a recruiter or agency submitting a resume or candidate without a signed agreement being in place, we explicitly reserve the right to pursue and hire such candidates without any financial obligation to the recruiter or agency. Any unsolicited resumes, including those submitted directly to hiring managers, are deemed to be the property of Kingstone.