AWS Data Engineer
Apply NowCompany: Technogen International Company
Location: Boston, MA 02115
Description:
Data Engineer
Boston, MA-onsite
6 Months
Job description:
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.
Boston, MA-onsite
6 Months
Job description:
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.