Data Engineer
Data Engineer [Remote]
The Data Engineer is responsible for data migration and data pipeline maintenance. They aid in designing a data framework that conforms to data governance, quality, and security standards. They will partner with development, product leaders, data analysts, and key business stakeholders to improve the quality of the data used to drive critical business decisions.
About Veracity
Penicillin changed medicine. The Beatles changed music. And Veracity Insurance Solutions is changing insurance (hey, we can’t all be doctors and musicians). What GEICO did for home and auto insurance, well, we’re doing that for the world of business insurance. We make small business insurance simple, affordable, and buyable online without talking to an agent. We’re growing FAST, and we want you to be a part of it.
Why Veracity?
Here at Veracity, you’ll be part of a team of trailblazers and visionaries. We’re not just revolutionizing the way people “do” insurance; we are creating a whole new paradigm. Here, you will experience a vibrant and inclusive workplace where your ideas matter! With us, you have a chance to:
- Engage in groundbreaking projects that are reshaping the insurance landscape.
- Collaborate with a group of dedicated, like-minded professionals.
- Experience a culture that prioritizes growth and development.
What’s In It for You?
- We pay for your time and materials to obtain and maintain your Property and Casualty License
- Paid holidays
- 160 hours of PTO (sick or vacation) plus 2 floating holidays per year
- 401(k) with a company match plan
- Health/dental/vision plans
- Free mental health resources
- and more.
Essential Functions
- Migrate data from legacy systems to new solutions
- Develop and maintain a scalable data pipeline while integrating new data sources to support growing data volume and complexity
- Manage data sources, including integrating, transforming, and cleaning data to ensure consistency and accuracy
- Establish and perform data security, integrity and performance audits and work with the dev team on best practices
- Work on all aspects of the data warehouse/BI environment including architecture, design, development, automation, caching, and performance tuning
- Act in an advisory capacity in data model reviews, architecture approach and solution design
- Migrate VOP database to new database schema and maintain transaction integrity between both databases
- Maintain data pipelines according to established SLAs and data integrity practices
- Onboard new targeted 3rd party data sources into data warehouse
- Required to perform other duties as requested, directed, or assigned.
Requirements
- Bachelor's Degree in computer science or engineering-related field
- 3+ years of professional experience in the data engineering field
- 3+ years SQL and relational databases experience
- 2+ years ETL design, implementation and maintenance experience
- 2+ years Python or similar programming language development experience
- Experience with conducting and managing database migrations
- Experience managing database/data warehouse resources
- Experience with writing ETL pipelines in python
- Experience in Snowflake Data Warehouse (preferred) or similar (Redshift, Big Query, etc.)
- Experience in cloud platforms such as AWS (preferred)
- Experience with cloud services such as S3, Nat Gateways, Glue are a bonus
Veracity is proud to be an equal-opportunity employer. We are committed to providing equal opportunities to all qualified applicants, regardless of race, color, religion, sex, national origin, disability, or any other legally protected characteristics.
Please let us know during the interview process if you need accommodations.