Principal Business Intelligence Analyst

Healthesystems is a company that offers workplace flexibility and a competitive benefits package. They are seeking a Principal Business Intelligence Analyst who will lead the requirements gathering, design, development, quality assurance, implementation, and support of enterprise reports, dashboards, and data stores, while driving innovation and collaboration within agile teams.

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 Paginated Reports, Power BI, SSRS, Crystal Reports, 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
• Drives technology direction and choices of technologies by making recommendations based on experience and research, creating 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 to strengthen organizational and technical knowledge
• Proactively interacts with Business, Data Integration Engineers, Data Architects, and team to improve processes, reporting interactions, and adoption of tools
• Coaches, Mentors, and trains current members to facilitate the move to 'Technological Future State' and Influences them to lead change
• Works closely with Solution Architects and team members to insure alignment of software design with architectural vision and IT strategy

Requirements:

• Bachelor's degree from four-year college or university plus five to eight years related experience and/or training; or equivalent combination of education and experience
• 8+ years' experience writing T-SQL stored procedures
• 6+ years' experience in Paginated Reports, Power BI, SSRS, Crystal Reports 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
• 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
• Shows Drive & Initiative
• Collaboration & Teamwork
• Delivers Quality Results Timely
• Communicates Effectively
• Job Knowledge & Skills
• Experience with Business Objects Universe design, Microstrategy, and/or Tableau or equivalent tools
• Jira or equivalent tools
• Gherkin
• YAML file creation