Data Engineer - Veracity Insurance Solutions, LLC

Data Engineer (Hybrid) (Utah County, Pleasant Grove, UT)

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

Salary: $100,000

Equal Opportunity Statement

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 other legally protected characteristics. Please let us know during the interview process if you need accommodations.