What are the responsibilities and job description for the ETL Data Engineer position at Vantage Risk Companies?
About the role:
At Vantage, the ETL Data Engineer is mainly responsible for transforming replicated source data into data products that are easily consumed by the Reporting team and other downstream users. The role requires an expertise in Data Modeling and Data Pipeline development within an Analytical, column-oriented data store. This role reports to our Data Engineering & ETL Lead and is a remote opportunity/hybrid opportunity where the candidate is in a commutable distance to one of Vantage’s office locations, with a preferred location in New York or Chicago.
The base salary expectation for this role is between $115,000 and $150,000. Additionally, Vantage 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 Data Built Tool (DBT) framework
Python knowledge for Data Built Tool (DBT) macros and data pipelines.
Debug and troubleshoot issues found during testing or production.
Communicate project status, issues, and blockers with the team.
Contribute to continuous improvement by identifying and addressing opportunities.
Ideal Candidate Profile:
Bachelor’s degree in computer science or equivalent required.
Minimum of 5 years of experience in ETL development within a Data Warehouse.
Minimum of 5 years working with Dimensional Data Modeling, such as Kimball, Data Vault, or Medallion Architecture.
Strong familiarity with Data Built Tool (DBT).
Expertise in column-oriented SQL modeling.
Experience in P&C Insurance or Financial Services Industry is a plus.
Strong understanding of test-driven development applied to Enterprise Data
Highly comfortable with git and change management best practices
Ability to process and adapt to change in a rapid growth new-company environment. Vantage associates are expected to be curious, thrifty, and resourceful to manage through the unknowns of growing a specialty (re)insurance business from the ground up.
Our Vantage 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 quo, look for ways to say YES, drive innovation, be opportunistic and disciplined.
We’re Better Together– 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, seek and provide alternative points of view, be true to yourself.
Make A Difference –focus on impact, embrace technology, leverage data and analytics as critical assets, act intentionally to deliver on our mission.
Salary : $115,000 - $150,000
