Job Description
Insight Global is seeking a Data Engineer for a full-time opportunity, with a specialty Insurance Provider in the Conshohocken, PA area. This Data Engineer is an exciting new role in a growing Data team. The client is looking for a passionate Cloud data solution engineer with hands-on implementation experience within the following: Cloud (Azure) 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 this customers' niche programs. The Strategic Analytics Teams goal is to provide analytical insights to business stakeholders to drive data driven decisions. The team serves all departments across the company, including but not limited to, Marketing, Finance, and Underwriting.
This Data Engineer will 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). They will also assist and lead data discovery sessions with cross functional business teams to help develop requirements and data strategy roadmap. This is a hybrid role, and requires this person be on-site in Conshohocken, PA 2-3 times per week.
Required Skills & Experience
- Bachelors-degree in Computer science, Computer engineering, or any related area of focus
- Strong TSQL Development and debugging skills
- 2+ 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.
- Experience with 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.
- Proficiency in Python, R and/or Scala.
Nice to Have Skills & Experience
- Azure Synapse experience preferred
- Azure related certifications
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.