Data Engineer, Berxi

Job Opportunity :

As a Data Engineer, you will be part of a cross-functional, largely autonomous data engineering team. You should have excellent problem-solving skills, strong attention to detail, and the technical know-how to independently build solutions from start to finish.

We are looking for a true expert on ETL development / data modeling, who is comfortable working with datasets of varying latencies and size sourcing data from various disparate data providers and platforms.

Duties & Responsibilities :

• Collaborate closely with application engineers, data analysts, data engineers, and stakeholders in building and maintaining Berxi data warehouse to support the operations and analysis of a direct-to-consumer small commercial insurance business.
• Contribute to the development, maintenance, and evolution of our platform.
• Deeply involved with working on SQL Server, developing Kimball dimensional modeling-based data marts & build new models or data marts and supporting data analyst teams in further assessing available data.
• Play a significant part in augmenting the data platform as we implement a new policy administration system data into Azure cloud-based data platform leveraging all the latest tools available anchoring on Azure resources.

Qualifications, Skills, and Experience :

• 2+ years of hands-on data engineering experience with ETL processing, data modeling and Business Intelligence.
• Relevant Work Experience with Microsoft SQL Server (2016+), SQL Server Integration Services (SSIS), ETL and Transact-SQL.
• Experience with Microsoft Azure cloud platform and Azure resources.
• Familiarity with data engineering concepts, languages, and tools; ability to develop on multiple platforms.
• Experience using sophisticated data transformation tools and cleansing methods, such as windowing functions in Transact-SQL.
• Experience with relational modeling, star schemas and Kimball Data Warehousing.
• Experience with contemporary data file formats such as JSON and unstructured data.
• Familiarity modeling for BI visualization tools such as Power BI / SSRS.
• Familiarity with Spark SQL / C# / Python is a plus.
• Experience with NoSQL / Non-relational databases are a plus, especially blob storage and Azure file tables.
• Experience with Agile data engineering concepts and processes, such as CICD, pipelines, backlog tracking, burndown metrics, and incremental delivery a plus.
• Solid collaboration, prioritization, and adaptability skills required.
• Excellent interpersonal and communication skills.
• Proactive and self-driven, demonstrated initiative and be a logical thinker.

BHSI Offers :

• A competitive package and exciting growth opportunities for career-oriented teammates.
• A dynamic, action oriented, and thoughtful environment centered on always doing the right thing for our customers, teammates, and our other stakeholders.
• A purposely non-bureaucratic organization that embraces simplicity over complexity and emphasizes individual excellence in a team framework.
11 days ago