Business Intelligence Engineer at Healthesystems

Job description

Healthesystems offers workplace flexibility with our Work-From-Home model, and a competitive compensation and benefits package including healthcare coverage, PTO, paid holidays, 401(k), company-provided life insurance/disability coverage, wellness options, and more. Healthesystems welcomes candidates from these states: AL, AZ, CO, FL, GA, ID, IN, LA, MD, MS, MO, NC, OH, OK, PA, SC, TN, TX, UT, VA Summary: As an integral member of our delivery team, the BI Engineer is responsible for the requirements gathering, design, development, quality assurance, implementation and support of miss ion-critical enterprise reports, dashboards, and data stores. Key Responsibilities: “To simplify complexities for each customer.” 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, SQL Data Extracts, and/or other data sources approved by IT Management  Create reports and dashboards using tools such as Paginated Reports, Power BI, SSRS, Tableau, Crystal Reports, 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 technical assistance and cross 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. Participates in industry and other professional networks to ensure awareness of industry standards, trends and best practices in order to strengthen organizational and technical knowledge. Qualifications/Education/Certifications: Bachelor's degree from four-year college or university plus two to four years related experience and/or training; or equivalent combination of education and experience. Knowledge, Skills and Abilities: Required Experience : 3 + years’ experience writing T-SQL stored procedures 1 + years’ experienc e in Paginated Reports, C rystal Reports Development , SSRS, Power BI, or equivalent tools Working knowledge of Star Schema modelling and Methodology Strong understanding of the Agile, Scrum, and/or Kanban development methodologies Working knowledge of online transactional (OLTP) processing and analytical processing (OLAP) databases and schemas The following knowledge is not required , but is preferred : Experience with Tabular Models, Business Objects Universe design, Microstrategy , Tableau and/ or equivalent tools SSIS Azure Portal especially Logic Apps JIRA Agile Competency Requirements: 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 Leadership Requirements: Consider customer and organization reactions to design decisions Look beyond the task given or the ask of the customer while using objective data and keep a customer focus while design decisions are made Promote projects or designs that will improve the user experience and efficiency of BI product Role-Based Competencies:   Shows Drive & Initiative  Collaboration & Teamwork  Delivers Quality Results Timely  Communicates Effectively  Job Knowledge & Skills  Physical Demands/Working Conditions: Duties are performed primarily in a home office setting utilizing computer equipment. Travel to attend meetings and visit locations throughout the country may be required. 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. *** Job descriptions will be reviewed and are subject to changes of business necessity.  Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Pay is based on several factors including but not limited to education, work experience, certifications, geographical cost of labor, etc. In addition to base pay, Healthesystems offers a comprehensive benefits package including, health, dental, vision, disability and life insurance, wellness resources, recognition programs, 401k contribution, and PTO & Holiday pay (all subject to eligibility requirements). Applicable statutory benefits also provided, including the Colorado HFWA. healthesystems.com Anticipated Starting Pay Range $79,000 — $108,570 USD To facilitate working from home, and as a requirement for this role, candidates must provide their own reliable, high speed internet access with sufficient bandwidth to execute all job functions. Company laptop will be provided - (except for temporary internship roles) Healthesystems California Prospective Employee Privacy Notice

Requirements

Must-haves

AL, AZ, CO, FL, GA, ID, IN, LA, MD, MS, MO, NC, OH, OK, PA, SC, TN, TX, UT, VA
Key Responsibilities: “To simplify complexities for each customer.”
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, SQL Data Extracts, and/or other data sources approved by IT Management
Create reports and dashboards using tools such as Paginated Reports, Power BI, SSRS, Tableau, Crystal Reports, 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 technical assistance and cross 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.
Participates in industry and other professional networks to ensure awareness of industry standards, trends and best practices in order to strengthen organizational and technical knowledge.
Bachelor's degree from four-year college or university plus two to four years related experience and/or training; or equivalent combination of education and experience.
3 + years’ experience writing T-SQL stored procedures
1 + years’ experienc e in Paginated Reports, C rystal Reports Development , SSRS, Power BI, or equivalent tools
Working knowledge of Star Schema modelling and Methodology
Strong understanding of the Agile, Scrum, and/or Kanban development methodologies
Working knowledge of online transactional (OLTP) processing and analytical processing (OLAP) databases and schemas
Experience with Tabular Models, Business Objects Universe design, Microstrategy , Tableau and/ or equivalent tools
Azure Portal especially Logic Apps
Must be comfortable with change, close collaboration, and have conflict resolution skills.
Knowledge of or willingness to learn Agile / DevOps values.

Nice-to-haves

The following knowledge is not required , but is preferred :

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlagilescrumazurejira

Platform: greenhouse
Effort: quick

Benefits

Benefits detected in the listing.

Dental

Vision

401k

401(K)

Pto

Wellness