Business Intelligence Programmer

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.

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. But we’re still making time for fun with virtual events like virtual painting classes, virtual yoga and Zumba classes, and virtual happy hours!

What you’ll do:

Create and maintain data warehouse structures for use in our reporting systems; create and maintain the data streams to populate these data structures and downstream reports via Looker, Microstrategy and/or Tableau.

What you can expect:

• Design data mart/warehouse tables, queries and metadata; designs will be error free, timely and tuned to data warehouse industry standards
• Work with Application Services and Data Engineering & Network Services to create and maintain interfaces between data marts/warehouse, information tools and production systems to accurately reflect operational system logic
• Maintain existing code to enhance functionality, improve efficiency, and replace malfunctioning or obsolete code, following current standards; ensure code is current with rules and standards
• Establish regular and proactive communications and maintain strong relations with other Business Intelligence(BI) members and internal customers
• Develop technical documentation pertaining to the design and implementation of software following relevant standards for technical work
• Train analysts and other programmers on technical subjects
• Remain current on new information technologies and techniques
• Perform other duties as assigned

What you need to be successful:

• Bachelor’s degree (Computer Science, Information Systems, Mathematics, Data Science or related field is preferred). Completion of advanced degrees is encouraged and supported.
• 2+ years of programming experience.
• Experience with the following languages required: SQL (preferably pl/SQL) and Python.
• Experience building and maintaining ETL solutions (preferably Airflow,  Google Cloud Composer, or Google Cloud Run).
• Ability and willingness to quickly learn new technical skills as needed.
• Highly self-motivated to excel at any assigned task
• Ability to carefully follow and apply internal process documentation
• Highly resourceful with strong problem solving abilities.
• Effective customer service and interpersonal skills
• Knowledge Git for version control and GitLab CI/CD pipelines
• Some experience working with Docker, Kubernetes to deploy and manage containers would be helpful
• Some experience with LookML to construct SQL queries against a database would be helpful

• 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 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 $103,300 - $110,800. 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].