Data Engineer (Remote or Onsite) at Pinnacol Assurance

| Greater Denver Area
Sorry, this job was removed at 11:40 a.m. (MST) on Friday, June 26, 2020
Find out who's hiring in Colorado.
See all Data + Analytics jobs in Colorado
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

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:

As a Data Engineer, you play a key part in realizing our mission to provide customers with tools they love to use. As a member of the Data Transformation Team you will be responsible for data management tasks including design, development, and data security in a Google Cloud Platform environment. You will leverage your experience and skills to design solutions that will deliver Pinnacol data products while operating as a key contributor on a team of dedicated professionals working toward a common product vision.

What you can expect:

  • Design, develop, document, monitor, and optimize automated data pipelines for various internal and third-party data sources.
  • Develop custom code using Python, SQL/NoSQL, Google Cloud-Composer (Airflow), Apache Beam and other technologies to build customized solutions supporting business initiatives/processes.
  • Implement software engineering best practices by developing, refining, iterating, integrating, testing, staging, and deploying maintainable technical solutions.
  • Develop solutions which adhere to data privacy laws and regulations using Data Loss Prevention toolsets and secure storage practices.
  • Provide innovative solutions leveraging modern data tools and techniques.
  • Enhance our platform capabilities and make recommendations to support a rapidly growing organization.
  • Use analytical skills and judgement to solve problems and make decisions in a rapidly changing environment.
  • Communicate complicated problems to team members to ensure we are coming up with the right solutions.
  • Be accountable for effectively driving, communicating and managing changes that ensure the performance and sustainability of our data processes.
  • Remain current on the external environment for industry leading tools, technology, analytics and best practices to continuously improve Pinnacol’s customer value proposition

Additional Duties:

  • Train other employees as needed
  • Serve on committees
  • Present business and technical subjects to team members or other internal groups
  • Perform other duties as assigned

What you’ll bring to the table:

Minimum Qualifications:

  • Experience designing and implementing data solutions in cloud environments
  • Experience with ETL/ELT tooling and practices
  • Data Provenance/Lineage approaches
  • Cloud-based Data storage and security best practices

Ideal Qualifications:

  • Experience with Google Cloud Platform
  • Experience with Apache Airflow/Cloud Composer or similar
  • Experience with Apache Beam/Dataflow or similar
  • Experience with Docker and Kubernetes or similar
  • Experience with BigQuery or similar
  • Experience with functional data engineering best practices
  • Must be flexible, innovative, and have the ability to perform in a rapidly changing, fast-paced environment.

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

Want to love your work? Apply today!


Read Full Job Description
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.

Technology we use

  • Engineering
    • JavaLanguages
    • PythonLanguages
    • RubyLanguages
    • SqlLanguages
    • PandasLibraries
    • Airflow/Cloud Composer Frameworks
    • Dataproc (GCP) Frameworks
    • Dataflow (GCP)Frameworks
    • MySQLDatabases
    • PostgreSQLDatabases

Location

We're a few blocks away from Lowry shopping center with coffee shops, restaurants, shopping etc. We have a light rail stop on our corner too!

An Insider's view of Pinnacol Assurance

What are some social events your company does?

Pinnacol plans our larger annual events, such as our holiday party, Halloween parade and summer picnic. We also plan our monthly and weekly events, such as weekly fitness classes (yoga, pilates etc), and monthly paint & sip class, book club etc. Many of our teams are very active in the community and plan volunteer events together!

Mallory

Talent Acquisition Specialist

What projects are you most excited about?

I’m most excited to be executing on Pinnacol’s vision for an enterprise cloud data platform. Pinnacol is committed to transforming its business with a modern tech stack. I enjoy collaborating with many smart minds to execute on this project. Recently, I have been iterating on a cloud-based solution for scheduling and monitoring our data workflows.

Gavin

Data Engineer

How does the company support your career growth?

They focus on me as an individual and cater learning objects to my needs. The Learning Development team offers a variety of resources to help me achieve any goal from curated online learning content, book clubs, hosting Leadercast, leadership development content, job training etc. They have a robust tuition reimbursement and certification bonuses!

Stacey

Learning & Org Development Specialist

How would you describe the company’s work-life balance?

Pinnacol works hard to maintain a strong work-life balance for our team members. We allow 1-2 days per week work from home, and flexibility in schedules. We coach leadership to be understanding of different employee situations.
During the pandemic Pinnacol employees are working from home - our team's safety is our number one priority!

Mallory

Talent Acquisition Specialist

What are Pinnacol Assurance Perks + Benefits

Culture
Volunteer in local community
Partners with Nonprofits
Friends outside of work
Eat lunch together
Intracompany committees
Wellness, Employee Events, Employee Giving
Open door policy
Team owned deliverables
Group brainstorming sessions
Diversity
Documented equal pay policy
Unconscious bias training
Mean gender pay gap below 10%
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
Disability Insurance
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Pet Insurance
Wellness Programs
Onsite Gym
Team workouts
Retirement & Stock Options Benefits
401(K)
Plus Colorado PERA
401(K) Matching
Performance Bonus
Match charitable contributions
Child Care & Parental Leave Benefits
Flexible Work Schedule
Remote Work Program
Family Medical Leave
Adoption Assistance
Company sponsored family events
Vacation & Time Off Benefits
Generous PTO
Paid Volunteer Time
Paid Holidays
Perks & Discounts
Casual Dress
Commuter Benefits
Company Outings
Parking
We offer employees Free on-site garage parking.
Fitness Subsidies
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Lunch and learns
Promote from within
Time allotted for learning
Online course subscriptions available
Customized development tracks
More Jobs at Pinnacol Assurance3 open jobs
All Jobs
Finance
Dev + Engineer
Legal
Finance
new
Denver
Apply now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Save jobView Pinnacol Assurance's full profileSee more Pinnacol Assurance jobs