Logo
Soteria Reinsurance Ltd.

Senior Data Engineer

Soteria Reinsurance Ltd., Westlake, Ohio, United States, 44145

Save Job

## ## Job Description:Position Description:Builds and optimizes clean, well-documented, and reusable data transformations in SQL, Python, and Cloud-based platforms to enable self-service analytics and data science. Supports dashboards and visualization platforms (Power BI and Tableau) by preparing optimized datasets and ensuring performance at scale. Works on data consulting projects using technical and analytical strengths and skills. Identifies, analyzes, and proposes solutions to support consulting projects and provide support to clients directly, using service category databases, data warehouses, and other technical applications (Python, SQL, and Snowflake). Designs, develops, and maintains robust, scalable data pipelines and analytics-ready data models to support business intelligence, reporting and advanced analytics use cases.Primary Responsibilities:* Architects and maintains enterprise data marts, semantic layers, and curated datasets, ensuring data consistency and accuracy for analytics consumption.* Implements data quality checks, validation rules, and lineage tracking to ensure trust in critical business metrics and reports.* Develops and automates data ingestion, enrichment, and aggregation workflows across structured and unstructured data sources.* Creates and maintains technical documentation, data dictionaries, and data mapping artifacts to support transparency and knowledge sharing across teams.* Applies data modelling techniques, statistical methods, and advanced tools to enable reporting, forecasting, and actionable insights.* Provides performance and operational insights.* Works with product owners, technical leads, and architects to influence technical platform improvements.Education and Experience:Bachelor’s degree in Analytics, Computer Science, Engineering, Information Technology, Information Systems, or a closely related field (or foreign education equivalent) and three (3) years of experience as a Senior Data Engineer (or closely related occupation) building and supporting scalable data warehousing and reporting platforms in hybrid Cloud environments (Snowflake, SQL, Python, and Power BI).Or, alternatively, Master’s degree in Analytics, Computer Science, Engineering, Information Technology, Information Systems, or a closely related field (or foreign education equivalent) and one (1) year of experience as a Senior Data Engineer (or closely related occupation) building and supporting scalable data warehousing and reporting platforms in hybrid Cloud environments (Snowflake, SQL, Python, and Power BI).Skills and Knowledge:Candidate must also possess:* Demonstrated Expertise (“DE”) implementing end-to-endExtract, Transform, Load (ETL) workflows usingAmazon Web Services (AWS) services (Glue, Simple Storage Service (S3), DynamoDB, Elastic Compute Cloud (EC2), and Jenkins); andbuilding dataingestion pipelines with SQL, Python andInformatica toprocess structured andunstructured dataacross distributed Cloud-nativeenvironments.* DE developing migration andreporting solutions usingAzure services (DataFactory, Logic apps, and Blob Storage), SQL, C#/.NET, anddashboarding tool (Power BI); and streamlining data availability andinsight delivery.* DE architecting automated datatransformation frameworks usingPython, Java, andadvanced SQLprocedures; and optimizing performance andenabling regulatory andanalytical data outputs forenterprise consumption, using Python, Java and SQL.* DE building andmaintaining observability andmonitoring frameworks, usingDatadog, Azure monitor, and CloudWatch; and performing database-levelauditing tovalidate dataquality, track job performance, andensure compliance withService Level Agreements (SLAs) across production pipelines, using Datadog, Azure monitor, and CloudWatch.#PE1M2#LI-DNI## ## Certifications:## ## Category:## Information TechnologyMost roles at Fidelity are Hybrid, requiring associates to work onsite every other week (all business days, M-F) in a Fidelity office. This does not apply to Remote or fully Onsite roles.Please be advised that Fidelity’s business is governed by the provisions of the Securities Exchange Act of 1934, the Investment Advisers Act of 1940, the Investment Company Act of 1940, ERISA, numerous state laws governing securities, investment and retirement-related financial activities and the rules and regulations of numerous self-regulatory organizations, including FINRA, among others. Those laws and regulations may restrict Fidelity from hiring and/or associating with individuals with certain Criminal Histories. #J-18808-Ljbffr