Business Intelligence Engineer, Senior - Remote

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, Senior is responsible for the requirements gathering, design, development, quality assurance, implementation and support of mission-critical enterprise reports, dashboards, and data stores. 

Key Responsibilities: “To simplify complexities for each customer.” 

1. Perform business analysis activities to gather required reporting, dashboard, and data store requirements   
2. Translate business requirements into specifications that will be used to implement the required reports, dashboards, and data stores created from potentially multiple data sources  
3. 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  
4. Create reports and dashboards using tools such as Crystal Reports, Power BI, SSRS, Microstrategy, Tableau, and/or any other tools approved by IT Management 
5. Provide support, as required, to ensure the availability and performance of developed reports and dashboards for both external and internal users 
6. Provide training to other team members 
7. Design and implement technology best practices, guidelines and repeatable processes  
8. Create test cases for ensuring reports meet stated business objectives.  
9. Perform testing on reports before moving into a production environment. 
10. Work continuously on improving performance of queries, reports, and data stores using industry standard methodologies for SQL generation. 
11. Participates in industry and other professional networks to ensure awareness of industry standards, trends and best practices to strengthen organizational and technical knowledge. 
12. Proactively interacts with Business, Data Integration Engineers, Data Architects, and team to improve processes, reporting interactions, and adoption of tools.   
13. Coaches and Mentors current members to facilitate the move to “Technological Future State” 

Qualifications/Education/Certifications: 

Bachelor's degree from four-year college or university plus four to six years related experience and/or training; or equivalent combination of education and experience. 

 Knowledge, Skills and Abilities: 

Required 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 

The following knowledge is not required, but is preferred 

• Experience with Business Objects Universe design, Microstrategy, and/or Tableau or equivalent tools 

• Version One 

• Gherkin  

• YAML file creation 

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 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 team in design decisions 
• Innovate 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.