Business Intelligence Engineer, Senior - Remote

Healthesystems offers workplace flexibility with a Work-From-Home model.

About the role

As an integral member of our delivery team, the BI Engineer, Senior is responsible for the requirements gathering, design, development, quality assurance, implementation, and support of mission-critical enterprise reports, dashboards, and data stores.

Responsibilities

• Perform business analysis activities to gather required reporting, dashboard, and data store requirements.
• Translate business requirements into specifications that will be used to implement the required reports, dashboards, and data stores created from potentially multiple data sources.
• Create data sources which include SQL stored procedures, Business Objects Universes, Microstrategy Cubes, Tableau Data Extracts, and/or other data sources approved by IT Management.
• Create reports and dashboards using tools such as Crystal Reports, Power BI, SSRS, Microstrategy, Tableau, and/or any other tools approved by IT Management.
• Provide support, as required, to ensure the availability and performance of developed reports and dashboards for both external and internal users.
• Provide training to other team members.
• Design and implement technology best practices, guidelines, and repeatable processes.
• Create test cases for ensuring reports meet stated business objectives; perform testing on reports before moving into a production environment.
• Work continuously on improving performance of queries, reports, and data stores using industry standard methodologies for SQL generation.
• Participate in industry and other professional networks to ensure awareness of industry standards, trends, and best practices to strengthen organizational and technical knowledge.
• Proactively interact with Business, Data Integration Engineers, Data Architects, and team to improve processes, reporting interactions, and adoption of tools.
• Coach and mentor current members to facilitate the move to “Technological Future State.”
• Consider customer and organization reactions to design decisions and challenge them if required.
• Look beyond the task given or the ask of the customer while using objective data and keep a customer focus while leading the team in design decisions.
• Innovate projects or designs that will improve the user experience and efficiency of BI product.

Requirements

• Bachelor's degree from a four-year college or university plus four to six years related experience and/or training; or equivalent combination of education and experience.
• 5+ years’ experience writing T-SQL stored procedures.
• 5+ years’ experience in Crystal Reports Development, SSRS, Power BI, or equivalent tools.
• 2+ years’ experience in Star Schema modelling and methodology.
• Strong understanding of the Agile, Scrum, and/or Kanban development methodologies.
• Understanding of SSIS and ETL best practices.
• Working knowledge of online transactional (OLTP) processing.
• Advanced knowledge of analytical processing (OLAP) databases, tabular models, and other consistently used EDW models/schemas.
• Must be comfortable with change, close collaboration, and have conflict resolution skills.
• Knowledge of or willingness to learn Agile / DevOps values.
• Take initiative and participate in team discussion.
• Adaption, ability & desire to learn, team oriented - tolerance & helpful, and quality focus.

Preferred Qualifications

• Experience with Business Objects Universe design, Microstrategy, and/or Tableau or equivalent tools.
• Version One Gherkin YAML file creation.
• Agile Competency.

Skills

• Shows Drive & Initiative
• Collaboration & Teamwork
• Delivers Quality Results
• Timely Communicates Effectively
• Job Knowledge & Skills

Benefits

• Comprehensive benefits package including healthcare coverage, dental, and vision insurance.
• Disability and life insurance.
• Wellness options.
• 401(k) with company contribution.
• Paid time off (PTO) and paid holidays.
• Recognition programs.
• Applicable statutory benefits, including the Colorado HFWA.

Pay

Anticipated Starting Pay Range: $90,300 USD - $124,190 USD. Pay is based on several factors including but not limited to education, work experience, certifications, and geographical cost of labor.

Schedule

Work-from-home model with potential travel required to attend meetings and visit locations throughout the country.

Working Conditions

• Duties are performed primarily in a home office setting utilizing computer equipment.
• While performing the duties of this job, the employee is regularly required to sit and talk or hear.
• The employee is frequently required to use hands.
• The employee is occasionally required to stand and walk.

To facilitate working from home, candidates must provide their own reliable, high-speed internet access with sufficient bandwidth to execute all job functions. A company laptop will be provided.