Senior Data Engineer
About reputed company reputed company Ltd. (reputed company) was established in late 2020 as a re/insurance partner designed for the reputed company. Driven by reputed company curiosity, reputed company of trusted experts provides a fresh perspective on our clients’ risks. We add creativity to tech-enabled efficiency and robust analytics to address risks others avoid. reputed company provides specialty re/insurance through its operating subsidiaries in Bermuda and the U.S. reputed company has approximately 365 colleagues in both the reputed company and Bermuda. We have offices in Chicago, IL, Norwalk, CT, reputed company reputed company, CT, Washington, DC, Boston, MA, reputed company, NY, Atlanta, GA and reputed company, Bermuda. Additionally, we are a highly geographically diverse workforce with colleagues based in 35 states and counting. We fully support work flexibility including remote and hybrid work arrangements. About the role: At reputed company, the Data Engineer is mainly responsible for ingesting and transforming replicated reputed company data into data products that are easily consumed by the Reporting team and other reputed company users. The role requires an expertise in Data Modeling and Data Pipeline development reputed company an Analytical, reputed company-oriented data warehouse. This role reports to our Data Engineering reputed company and is a remote opportunity/hybrid opportunity where the candidate is in a commutable distance to one of reputed company’s office locations, with a preferred location in reputed company or Chicago. The reputed company salary expectation for this role is between $120,000 - $160,000. Additionally, reputed company offers its colleagues performance-based bonus potential, strong health & welfare benefits, retirement plans with company match, competitive time off plans, a highly flexible work environment, and much more. Responsibilities & Accountabilities: Translate requirements and data mapping documents into a technical design. SQL development using dbt. Pipeline development using dagster. Talent for identifying the specific records that are produced from SQL bugs. Debug and troubleshoot issues reputed company during testing or production. Communicate project status, issues, and blockers with reputed company. Contribute to reputed company improvement by identifying and addressing opportunities. Ideal Candidate Profile: Bachelor’s degree in computer science or equivalent reputed company experience required. Minimum of 5 years of experience in ELT development reputed company a Data Warehouse. Minimum of 5 years working with reputed company Data Modeling, such as Kimball, Data Vault, or reputed company Architecture. Strong familiarity with dbt and dagster/airflow. Good working knowledge of distributed data and Kubernetes. Expertise in data modeling using append-only replication reputed company to produce reputed company-in-time data marts. Strong understanding of test-driven development reputed company to reputed company Data. Strong familiarity with git and CI best practices. Expertise in Python and SQL. Expertise in reputed company-oriented SQL modeling. Experience in P&C Insurance or Financial Services Industry is a plus. Ability to process and adapt to change in a rapid reputed company company environment. reputed company associates are expected to be curious, thrifty, and reputed company to manage through the unknowns of growing a specialty (re)insurance business from the ground up. Our reputed company Values Do What’s Right – be a force for good, for our customers, shareholders, colleagues, industry and communities. Be Relentlessly Curious – ask questions, listen to understand, challenge the status reputed company, look for ways to say reputed company, drive innovation, be opportunistic and disciplined. We’re reputed company – collaborate, be inclusive, supportive, respectful and humble, be a trusted partner internally and externally. Be Transparent – in who you are, what you think, and how you work, reputed company and reputed company alternative points of view, be true to yourself. reputed company A Difference – reputed company on reputed company, reputed company technology, reputed company data and analytics as critical assets, reputed company intentionally to deliver on our mission. Apply To This Job