Business Intelligence Programmer

Pinnacol Denver , CO 80208

Posted 4 months ago

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 celebrate continuous improvement, innovation, compassion, teamwork, integrity and excellence. Speaking of celebrating, we love having fun at work. We host holiday parties, on-site painting classes, and employees love our yoga classes and book club, too.

What you'll do:

At Pinnacol Assurance, we're bringing forth a revolution in caring for employers and employees across Colorado. We are seeking a Programmer/Data Engineer that is versatile and passionate about creating revolutionary solutions.

You will work with medical, claims, and policy related data that comes in a variety of formats structured and some unstructured to extract, transform, stage and load it in databases to support our Business Intelligence team. This data is used to deliver a variety of advanced analytical insights to customers and decision makers throughout the organization. As a Business Intelligence Programmer/Data Engineer, you will work with internal teams to:

  • extract data from disparate sources of data
  • apply tools and methods to transform or enrich data for an array of possible uses
  • build creative solutions for a variety of problems of interest to our company
  • troubleshoot existing ETL jobs written in Python, pl/SQL or Pentaho
  • enhance and maintain projects in an Oracle Data Warehouse
  • help support/administer our Business Intelligence reporting tools (MicroStrategy and Tableau)

What you can expect:

  • Ability to thrive in a fast-paced environment and enjoy working closely with a team of analysts, programmers and others in our IT department (data scientists, data engineers, system admins, database administrators, cyber security engineers, project managers, tech support and quality assurance analysts).

  • Demonstrate an understanding of data modeling, data warehouse concepts and methodologies for large scale data storage

  • Code, design and troubleshoot/debug ETL programs

  • Maintain existing code to enhance functionality, improve efficiency, and replace malfunctioning or obsolete code

  • Share knowledge and communicate complex concepts effectively to both technical and non-technical team members and leaders

  • Enthusiastically seek out opportunities to continuously improve and grow both your domain and technical knowledge

  • Develop and follow technical documentation pertaining to the design and implementation of software

  • Support team members in the maintenance of systems for production environments and resolution of internal and external customer issues

  • Support our data transformation efforts in moving from Oracle based on-prem databases to Salesforce and Cloud-based databases

What you'll bring to the table:

  • Bachelor's degree (Computer Science, Information Systems, Mathematics, Data Science or related field is preferred). Completion of advanced degrees is encouraged and supported.

  • 5+ years of programming experience.

  • Experience with the following languages required: SQL (preferably pl/SQL) and Python.

  • 3+ years of experience building and maintaining ETL solutions (preferably Pentaho).

  • 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

  • Advanced Oracle database skills and knowledge of star schema data warehouse design.

  • Highly resourceful with strong problem solving abilities.

  • Effective customer service and interpersonal skills

  • Knowledge of Bash shell scripting and Git for version

  • Some experience working in cloud environments (e.g. Google Cloud Platform's BigQuery, Snowflake) would be helpful

  • Some experience working with Jenkins, Docker, Kubernetes to deploy and manage containers would be helpful

  • Familiar with fundamental concepts, practices, and principles of software and API development

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 eight paid holidays annually.

  • 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!


icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Business Intelligence Analyst 1

Servicesource

Posted 1 week ago

VIEW JOBS 11/1/2019 12:00:00 AM 2020-01-30T00:00 At ServiceSource, we strive to find and grow exceptional people like you. Working at ServiceSource, you will be a part of an engaging, energetic, and entrepreneurial work environment while having the stability and influence of a nearly 20-year industry leader behind you. ServiceSource is a place where you can GROW, both personally and professionally, while expanding your skills in sales, customer success and people management. Reporting to the Manager of Business Intelligence Analysis, the Business Intelligence Analyst is responsible the adoption of the new Business Intelligence Platform for their local reporting analysts. Potential activities for this position include assisting in the design and administration of standard approved KPI calculations and metrics, creation and maintenance of the standard reporting template, and creation and maintenance of all standard reports for general usage throughout the company. This person will be the System Matter Expert for the Business Intelligence Platform and will work with our local internal reporting teams to help them in their adoption of the new platform. Job Description: * Work directly with local Sales Operations leadership and analysts to increase understanding and adoption of the BI Platform for reporting needs * Create and maintain KPI calculations using the Business Intelligence data platform * Assist in the design and implementation of the standard report template to be used for all standard reports * Create and maintain all standard reports and analysis as needed * Communicate status of requested reporting support quickly and efficiently * Develop subject matter expertise on the data and reporting environment * Partner with global sales operations counterparts to assist in reporting related projects as needed Job Requirements: * Bachelor's degree in Computer Science or comparable work history * 2+ years of SQL code experience with a minimum of 2+ years BI development (SAP products preferred) * Moderate knowledge of Business Intelligence data presentation concepts * Moderate knowledge of CRM databases (Salesforce.com or MS Dynamics preferred) * Moderate knowledge of relational databases * Advanced Excel skills, and proficiency with MS Office Suite * Ability to multitask, stay flexible and prioritize accordingly in a very fast paced environment * Ability to respond in a timely manner to the demands of a productive, successful sales organization * Distinctive problem-solving skills, impeccable business judgment, and attention to detail * Proven ability to successfully manage projects from start to finish. Meets deadlines * Ability to interpret data and provide recommendations to business * Ability to communicate technical subject matter to non-technical audience * Strong analytical skills Servicesource Denver CO

Business Intelligence Programmer

Pinnacol