Kingstone Insurance Company

Data and Software Developer

Kingstone Insurance Company

full-time

Posted on:

Origin:  • 🇺🇸 United States

Visit company website
✨ AI Apply
Manual Apply

Salary

💰 $105,000 - $140,000 per year

Job Level

Mid-LevelSenior

Tech Stack

AzureCloudEntity FrameworkETLMS SQL ServerSQL

About the role

  • 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.

Requirements

  • 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.