Job Url: https://www.remoterocketship.com/company/kingstoneinsurance/jobs/data-and-software-developer-united-states-remote Job Description: Kingstone Insurance Company Website LinkedIn All Job Openings Kingstone Insurance Company is a provider of specialized insurance products focused on protecting individual and business investments. With a commitment to customer service, they offer a variety of coverage options including homeowner policies, landlord policies, personal umbrella policies, and more. The company prioritizes policyholders' needs, ensuring access to a quick and efficient claims process and customizable insurance solutions. Property and Casualty Insurance β€’ Excellent personal service β€’ Competitive rates and commission levels 51 - 200 employees Founded 1886 πŸ’Έ Finance πŸ’³ Fintech Data and Software Developer 2 days ago πŸ‡ΊπŸ‡Έ United States – Remote πŸ’΅ $105k - $140k / year ⏰ Full Time 🟑 Mid-level 🟠 Senior πŸ§‘β€πŸ’» Full-stack Engineer Azure Cloud Entity Framework ETL MS SQL Server SQL Apply Now Receive Emails with Similar Jobs Report problem πŸ“‹ Description β€’ 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. πŸ–οΈ Benefits β€’ 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