Principal Business Intelligence Analyst

Note: we are unable to hire in every state

Summary: As an integral member of our delivery team, the, Principal is responsible for leading the requirements gathering, design, development, quality assurance, implementation and support of mission-critical enterprise reports, dashboards, and data stores. Evangelizes approved agile methodologies, leading the design and development efforts for all agile teams/members. A thought leader that drives innovation for new methodologies, processes, tools, and technologies, while garnering community adoption for lean concepts, using collaboration and influencing skills. A primary contact for Architecture to consult with on vision and software design. This position will have a range of coaching and architectural duties, depending upon the specific assignment.

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 Paginated Reports, Power BI, SSRS, Crystal Reports, 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. Drives technology direction and choices of technologies by making recommendations based on experience and research, creating best practices, guidelines and repeatable processes.
7. Create test cases for ensuring reports meet stated business objectives.
8. Perform testing on reports before moving into a production environment.
9. Work continuously on improving performance of queries, reports, and data stores using industry standard methodologies for SQL generation.
10. Participates in industry and other professional networks to ensure awareness of industry standards, trends and best practices to strengthen organizational and technical knowledge.
11. Proactively interacts with Business, Data Integration Engineers, Data Architects, and team to improve processes, reporting interactions, and adoption of tools.
12. Coaches, Mentors, and trains current members to facilitate the move to “Technological Future State” and Influences them to lead change.
13. Works closely with Solution Architects and team members to insure alignment of software design with architectural vision and IT strategy.

Qualifications/Education/Certifications:

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.

Knowledge, Skills and Abilities:

Required 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

The following knowledge is not required, but is preferred

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

• Jira or equivalent tools

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