Data Engineer [Remote/Hybrid]
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.
What’s In It for You?
- 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
- 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.
Top Skills
What We Do
Veracity Insurance Solutions is an international insurance brokerage firm specializing in the placement of Programs, General Liability, and Product Liability Insurance. The company was established on the basic principle of integrity in insurance, and that principle continues to permeate our business today. Innovation and knowledge are the cornerstones of Veracity’s business practices, giving our customers a leg up in what can be a confusing and hassle-filled industry.
With in-house underwriting authority and access to several key wholesale brokerage markets, Veracity stands out with its ability to customize insurance policies for all business sizes. This ability doesn’t stop at the oceans – Veracity has access to both domestic and foreign markets, opening doors that lead to only the best coverage options. Veracity prides itself on providing the highest level of customer service to everyone they work with. In over 30 years of experience, we have never forgotten the importance of the human side of doing business in this fast-paced industry.
.JPG)
_2.png)
