Analytics Engineer

Pinnacol Assurance does just one thing, and does it better than anyone: provide caring workers’ compensation protection to Colorado employers and employees. Although employers are required by law to provide Worker’s Comp insurance, we believe our service is making a meaningful impact in worker’s lives across Colorado in their moments of need.

We have big hearts and love big ideas. We’ve been around for over 100 years, but don’t let that fool you. Pinnacol is committed to taking care of Colorado employers and workers in the most innovative of ways! We celebrate continuous improvement, new ideas, compassion, teamwork, integrity and excellence.
With our number one priority to keep everyone safe, along with the heart of Pinnacol’s “culture of caring” to do what is right and not what is easy, we’re currently having our team members work from home. During remote work, we’re still making time for fun! We host virtual painting classes, virtual yoga and Zumba classes, and virtual happy hours!

What you’ll do:

Analytics Engineers create clean, well-documented data models. At Pinnacol, Analytics Engineers primarily work with SQL for data transformation and Python for pipelines and orchestration. Once models are published, Analytics Engineers are responsible for testing their pipelines and monitoring data quality. Additionally, Analytics Engineers provide feedback and contribute to the design for data governance to ensure that confidential data is protected at all times.

Our Tech Stack:

Google Cloud Platform, Python, SQL (Postgres, BigQuery, Oracle dialects), Airflow, Docker, Terraform, GitLab

We have an open mind about implementing new technologies and processes where beneficial. Bring your experience and recommendations.

What you can expect:

• Build and maintain clean data sets to support self service and discovery by analysts and other power users
• Create and support data transformation pipelines
• Write tests to validate assumptions and monitor data quality
• Provide feedback and contribute to design for data governance/access
• Document the models, pipelines, and transformations related to data movement and storage
• Works with IS and business partners to gather detailed requirements and understand need
• Ensure day-to-day activities are consistent with Data strategies and standard processes
• Create and maintain optimal data pipelines
• Researches data design future state options and current state opportunities
• Actively experiments with new ideas
• Understands the data and business needs of the data
• Uses standard common business vocabulary
• Builds data structures with an eye on data volume, security and long term feasibility
• Train other employees as needed
• Present business and technical subjects to team members or other internal groups 
• Perform other duties as assigned

What you need to be successful:

• Experience with data analysis, business intelligence, data engineering or similar is required.

• Advanced knowledge of databases and data pipelines required.

• Demonstrated knowledge of SQL and database optimization required, experience with BigQuery/Postgres/Oracle a plus.

• Demonstrated knowledge working with Python required, experience with Airflow is a plus.

• Ability to learn new technical skills required. Strong problem solving abilities required.

• Insurance industry experience is a plus.

• Adaptation: Ability to adapt in order to work effectively in ambiguous or changing situations, and with diverse individuals and groups
• Communication: Ability to communicate highly technical ideas to a wide variety of audiences, including technical and non-technical audiences
• Teamwork: Ability to work effectively with people and cooperate with others in developing and releasing software with a team

We can’t do our work without people like you.
Our employees are extraordinary and committed to making a difference. Here’s some of the ways we show our appreciation.

• Our benefits go beyond the basics. You’ll get to choose from diverse benefit offerings for medical, dental and vision.
• We care about each other. We enjoy a positive, collaborative work environment. We are hard workers and high performers.
• Take a day (or 20!) off. Enjoy 20 paid days off your first full year plus 9 paid holidays.
• Take care of yourself. Sign up for unique wellness programs, including on-site, company-paid fitness facilities and classes
• Get your learning on. We promote a learning culture to help you master your current job and cultivate the skills of the future through a variety of on-site, online, and off-site professional development opportunities.
• Give back and get paid. Through our employee volunteer program, Pinnacol in Action, employees receive paid time off to volunteer with Colorado nonprofits.
• Share in our success. You’ll have the opportunity to earn a quarterly incentive, up to 20 percent of your annual base salary, when your team exceeds their goals and objectives.

When we find the right person, we try to put our best foot forward with an offer that excites you. We consider what you’d like to be paid, the skills and experience you bring, what similar jobs pay in the Denver area and make sure there’s equal pay for equal work among those you’ll be working with.  The compensation amount for this role is targeted at $ 112,000 - $ 119,700.00. Final offer amounts are determined by multiple factors including your experience and expertise and may vary from the amounts listed above.

Want to love your work? Apply today!

Pinnacol is committed to working with and providing reasonable accommodations to applicants with disabilities. To request assistance with the application process, please email recruiting_team@pinnacol.com.