Technogen International Company
AWS Data Engineer
Technogen International Company, Boston, MA
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.