Business Intelligence Analyst

Summary:

The Business Intelligence Analyst II is responsible for conducting full lifecycle analysis to include requirements, design, documentation, testing and validation to support the implementation of Business Intelligence analytics solutions for regional or system partners. BI Analyst II will develop analysis and reporting capabilities. This includes an understanding of methodology, design, specifications, programming, delivery, monitoring, and support standards. Individuals should have extensive experience supporting software or analytics development teams in an Analyst capacity. Additionally, strong SQL and database experience in OLTP, OLAP or MPP is required. Ideal candidates will also have experience in data mining using advanced SQL or BI tools. The BI Analyst II must have proven competency in the following areas: designing & developing complex reporting projects using highly normalized & denormalized data structure.

Responsibilities:

Meets expectations of the applicable Competencies: Leader of Self, Leader of Others, or Leader of Leaders. Analyze ideas and business/functional requirements to formulate a design strategy.

Act as a tenant to draw out a workable report design and coding parameters with essential functionalities. Work in collaboration with the team members to identify and address the issues by implementing a viable technical solution that is time and cost-effective and ensuring that it does not affect performance quality.

Design, code, and develop SQL logic to pull data that meets specifications for the end user.

Develop and deploy code using existing tools and platforms utilized for automation and testing.

Participates in the development of standards, design, and implementation of proactive processes to collect and report data and statistics.

Participates in the research, design, development, and implementation of application, database, and interface using technologies platforms provided. Researching, designing, implementing, and managing programs Fix problems arising across the test cycles and continuously improve the quality of deliverables. Reference and document each phase of development for further reference and maintenance operation.

Must have critical and analytical thinking skills. Must understand programming principles and design.

Must have strong technical knowledge of Application, Integration Design and Development of systems, databases, operating systems, and Information Services. Must be able to solve complex problems with direction. Must be able to interact effectively and patiently with customers, especially while under pressure. Ability to work on multiple projects/tasks simultaneously to meet project deadlines as required.

Ability to establish and maintain positive working relationships with other employees.

Job Requirements:

Education/Skills

Bachelor’s degree in related field of study or equivalent job-related experience required.

Experience

2-4 years’ experience in SQL programming in platforms with large data asset within an OLTP, OLAP and MPP architecture required.

1-3 years’ experience in design, coding, and deployment with Enterprise BI tool such as MicroStrategy or IBM Cognos or Power BI design & development based on normalized & denormalized data model required.

Experience with writing and debugging complex SQL queries required.

Experience working with Internal or External customers for an organization in coordinating work and designing solutions.

Experience utilizing the Software Development Lifecycle (SDLC), Agile and Waterfall Methodologies. Licenses, Registrations, or Certifications None Work Type: Full Time