Kingstone Insurance Company

Compensation

Full Description

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.