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 holidays160 hours of PTO (sick or vacation) plus 2 floating holidays per year401(k) with a company match planHealth/dental/vision plansFree mental health resourcesand more. Essential Functions Migrate data from legacy systems to new solutionsDevelop and maintain a scalable data pipeline while integrating new data sources to support growing data volume and complexityManage data sources, including integrating, transforming, and cleaning data to ensure consistency and accuracyEstablish and perform data security, integrity and performance audits and work with the dev team on best practicesWork on all aspects of the data warehouse/BI environment including architecture, design, development, automation, caching, and performance tuningAct in an advisory capacity in data model reviews, architecture approach and solution designMigrate VOP database to new database schema and maintain transaction integrity between both databasesMaintain data pipelines according to established SLAs and data integrity practicesOnboard new targeted 3rd party data sources into data warehouseRequired to perform other duties as requested, directed, or assigned. Requirements 3+ years of professional experience in the data engineering field3+ years SQL and relational databases experience2+ years ETL design, implementation and maintenance experience2+ years Python or similar programming language development experienceExperience with conducting and managing database migrationsExperience managing database/data warehouse resourcesExperience with writing ETL pipelines in pythonExperience 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.