Specialist, Data Engineer - Snowflake and Python
About The Position
The Data Engineer will design, build, and support scalable data pipelines and data products for analytics, reporting, operational insights, and AI-driven solutions across Nationwide Pet. The role partners with business teams, analytics, product owners, software engineers, and data scientists to deliver reliable, governed, high-quality data solutions in cloud and hybrid environments. The position acquires, curates, and publishes data in ready-to-use form for analytical and operational purposes, creating a single version of the truth for business users, data scientists, and Technology. Data may support real-time or batch processes and may include unstructured data. The role covers the software engineering lifecycle, including requirements translation, design, development, testing, deployment, and production maintenance, using technologies such as big data platforms, relational and SQL databases, unstructured data technology, and programming languages. This hybrid role requires in-office presence two days per week in Columbus, Ohio; Des Moines, Iowa; or Scottsdale, Arizona. Current remote associates will also be considered. The role supports Nationwide Pet and Pacific Time Zone hours. It reports to a Manager/Director of Data Management and is exempt from overtime eligibility.
Requirements
- Four to six years of relevant experience with data quality rules, data management standards and practices, and software development.
- One to three years of experience with cloud technology and infrastructure, including security and access management.
- Experience with data warehousing, statistical analysis, data models, and queries.
- Experience architecting data solutions using modern platforms such as AWS, Snowflake, or Databricks.
- Experience with AWS, APIs, and SaaS integrations.
- Experience building and supporting batch and event-driven pipelines, API-based integrations, data ingestion frameworks, and data quality validation frameworks.
- Experience enabling AI/ML and analytics use cases through scalable data platforms, data observability frameworks, monitoring tools, and Power BI reporting solutions.
- Familiarity with data governance, metadata management, lineage, and security controls.
- Moderate to advanced skills with modern programming and scripting languages such as SQL, R, Python, Spark, UNIX shell scripting, Perl, or Ruby.
- Strong problem-solving and critical-thinking skills, and good communication and collaboration skills.
- Undergraduate studies in computer science, management information systems, business, statistics, math, a related field, or comparable experience and education are strongly preferred.
- Certifications are not required.
- Must not require employer-sponsored work authorization; the role does not support the STEM OPT Extension program.
Nice To Haves
- Insurance or financial services industry knowledge.
- Graduate studies in business, statistics, math, computer science, or a related field.
- Certifications are encouraged.
Responsibilities
- Analyze end-to-end data product requirements and existing business processes, and lead the design, development, and implementation of data products.
- Produce data building blocks, data models, and data flows for dimensional data, reporting, data feeds, dashboards, and data science research and exploration.
- Apply secure software and systems engineering practices throughout delivery to protect data and technology solutions from threats and vulnerabilities.
- Translate business data stories into technical work breakdowns and estimates to assess value and fit within a schedule or sprint.
- Create business-user access methods for structured and unstructured data, including mapping to common data models, transforming data to satisfy business rules, and applying NLP, AI, statistical computations, and data validation as needed.
- Assist the enterprise DevSecOps team and other internal organizations with CI/CD best practices and tools such as JIRA, Jenkins, and Confluence.
- Implement production processes and systems to monitor data quality and ensure production data is accurate and available.
- Develop and maintain scalable streaming and batch data pipelines, and build API integrations to support increasing data volume and complexity.
- Write and perform data unit and integration tests; create test data and scripts to validate data quality and completeness; and develop automated testing programs and reusable test data.
- Practice code management and integration using engineering Git principles and practices.
- Support delivery of data engineering solutions within a defined product or platform scope.
- Monitor, troubleshoot, and optimize large-scale data pipelines.
- Perform other responsibilities as assigned.
Benefits
- Medical insurance
- Dental insurance
- Vision insurance
- Life insurance
- Short- and long-term disability coverage
- Paid time off: newly hired associates receive a minimum of 18 days per full calendar year, prorated quarterly based on hire date
- Nine paid holidays
- Eight hours of Lifetime paid time off
- Eight hours of Unity Day paid time off
- 401(k) with company match
- Company-paid pension plan
- Business casual attire
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
