Data Engineer II

NSM Insurance Group is the nation’s leading specialty insurance provider with more than $1 billion in premium across 25+ specialty insurance programs and brands in the U.S. and U.K. For more than 30 years, the company has been exclusively focused on building successful insurance programs and continually seeks new opportunities to grow and expand through strategic mergers and acquisitions.

Relationships are paramount at NSM because we know that’s what drives mutual, long-term success. We maintain an entrepreneurial spirit and startup mindset within an established organization that continues to redefine what specialty insurance means and how it impacts everyday lives. Employee are given endless opportunities to expand their interests and skillsets, push breakthrough ideas and take risks. Our open, supportive environment gives employees the confidence to take ownership of their work as if the business was their own.

At NSM, we Build Success every day for our people, carrier partners, agents and insureds — because we know our success is built on yours.

The Data Engineer is an exciting new role in a growing Data team. We are looking for a passionate Cloud data solution engineer with hands-on implementation experience within the following: Cloud Data Analytics, Data Modernization, Data Warehousing, Data Lake, and Data Governance. In addition to designing, building, and enhancing data marts, data ETL pipelines and data warehouses, you will have the opportunity to work with new technology and truly impact the digital transformation of NSM Insurance Group’s niche programs. NSM Insurance Group’s Strategic Analytics Teams goal is to provide analytical insights to business stakeholders to drive data driven decisions. The team serves all departments across NSM Insurance Group, including but not limited to, Marketing, Finance, and Underwriting. 

• Develop an understanding of the business and system processes to build future target-state data and analytics roadmap, in collaboration with key business and technology leaders.
• Work with Architect and other team members to solution applications that enable reporting, analytics, data science, and data management and improve accessibility, efficiency, processing, and quality of data.
• Solve business and data engineering problems by utilizing best practices to create and enhance Datalake, using Azure Storage, Azure SQL, ETL pipelines using ADF/Synapse, cloud data models (AAS).
• Assist and lead data discovery sessions with cross functional business teams to help develop requirements and data strategy roadmap.
• Recommend emerging technological solutions to support digitalization transformation initiative.
• Coordinate and build strong working relations with various internal stakeholder groups, including IT, Marketing, and Underwriting.

• Bachelors-degree in Computer science, Computer engineering, or any related area of focus.
• Strong TSQL Development and debugging skills, with a good understanding of SQL Administration.
• 5+ years of experience, building data solutions in SQL server/Warehouse.
• 2+ years of experience of working in any Cloud environments, with preference to Azure stack including:
  • Azure SQL, Data warehouse, serverless pool, noSQL.
  • Azure Data factory/SSIS or similar ETL. Azure Synapse experience preferred.
  • CI/CD using Azure Devops.
  • Proficiency in reporting tools like PowerBI, Tableau or Qlikview.
  • Good understanding of dimensional modeling, using Azure Analysis services or SSAS.
  • Basic understanding of cloud principles, certification(s) preferred.
• Proficiency in Python, R and/or Scala.
• Good understanding of concepts for Data warehouse, MDM, Big Data, Machine learning and AI.
• High attention to detail, demonstrable critical thinking, with an eye towards continuous process improvement.
• Ability to understand business requirements and be able to create a Work Breakdown Structure/user story, to include dates and milestones.
• Team-oriented, results-drive and Self-Motivated to work independently on assignments.
• Previous Insurance experience preferred.
• Strong organizational, problem-solving, and critical thinking abilities.
• Excellent oral presentation and written communication skills.