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 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.