Data Engineer

Pinnacol Assurance does just one thing, and does it better than anyone: provide caring workers’ compensation protection to Colorado employers and employees. And while we may be a little biased, we believe that our work shapes communities and changes lives.

We have big hearts and love big ideas. We’ve been around for more than  100 years, but don’t let that fool you. Pinnacol is committed to taking care of Colorado employers and workers in the most innovative ways. We celebrate continuous improvement, new ideas, compassion, teamwork, integrity and excellence.

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:

• Build new data products and systems from various internal and third party data sources that use custom code in Python, SQL/NoSQL, Google Cloud-Composer(Airflow), Apache Beam and other technologies
• Create reliable, maintainable and scalable data solutions
• Champion software and data engineering best practices by developing, refining, iterating, integrating, testing, staging, and deploying maintainable technical solutions.
• Develop secure solutions which adhere to data privacy laws and regulations using Data Loss Prevention toolsets and secure storage practices.
• Enhance our platform capabilities and make recommendations to support a rapidly growing organization.
• Identify system or program problems efficiently and effectively and propose pragmatic solutions.
• Participate in code pull/merge request and design reviews
• Create design documents that satisfy business requirements, follow adopted methodologies and lead to efficient, easy to maintain, and reliable systems
• Document and demonstrate solutions by developing documentation, flowcharts, layouts, diagrams, charts, code comments and clear code
• Remain current on the external environment for industry leading tools, technology, analytics and best practices to continuously improve Pinnacol’s customer value proposition.
• 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:

• Knowledge of data engineering best practices and experience in implementing them through designing and implementing data solutions in cloud environments in one or more of the following cloud environments (GCP, AWS or similar)
• Experience with ETL/ELT tooling and practices using batch (Airflow or similar) or near-real time (Spark, Apache, Flink, Kafka, or similar) methodologies
• Experience with container technologies especially Docker 
• Knowledge of Cloud-based Data storage and security best practices

Competencies:

• 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
• Innovation: Ability to generate novel solutions and creative ideas in order to identify system or program problems, and propose pragmatic solutions
• 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.
• We love who you are. Pinnacol is on a journey to embody diversity, equity and inclusion. We’re committed to creating a culture that deeply values differences, where everyone feels like they belong.
• 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 12 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 $126,000 - $131,000. 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 [email protected].

This posting will close 14 days after being published; August 1, 2024