Business Intelligence Analyst

Company: REETECH USA
Location: Austin
Posted on: April 19, 2024

Job Description:

BI Analyst

Location: Austin, TX (Hybrid)

Duration: 6 Months+



Job Description:

Client needs one worker to assist in the creation of technical solutions for Finance, Business Relationship Management (BRM), and the IT Business Office (ITBO) needs.

The solutions will be created using SQL, Excel / power pivot, or other database environments to consolidate financial and IT tracking data into reports, dashboards, SharePoint sites and document repositories. Business Intelligence (BI) software such as Tableau and/or Power BI, Power Automate, will be used by the worker to create dynamic visualizations that help management understand and manage operations and project costs and automated workflows.

The worker also needs to develop requirements gathering documents that translate into best practices for advanced data quality and data analytics with uniformly governed data integrity. The worker will coordinate efforts with ITS Groups (Finance team, BRM, ITBO, Project Mangers, other users, and developers) to identify and map requirements to capture and report data and processes in a meaningful way for users and decision makers. The worker will need expert development skills in SharePoint, Power BI, Power Automate, Excel development, to develop solutions across the ITS landscape.

The Worker will also participate in identifying and documenting business processes and be able to translate these processes into PowerAutomate workflows. The Workers must have demonstrated advanced experience with Excel, PowerBI, and Tableau and other reporting tools. The worker must also update and maintain any product produced while under contract.



Responsibilities include (but are not limited to):

Develop requirements gathering documents.
Identify and map requirements to capture report data.
Develop Power Automate and SharePoint workflows.



Minimum Candidate Characteristics:

Advanced-expert level Excel and SharePoint experience.
Advanced BI experience leading BI solution design and implementation.BI experience should exceed solely dashboard creation.


PowerBI, Tableau experience.
Experience developing Power Automate and SharePoint workflows.
Data analysis experience.


SKILLS AND QUALIFICATIONS



Required/Preferred

Experience

Required

Expert translation of business requirements into technical specifications and document business needs to technical specifications

Required

Advanced Excel skills and specific experience with developing complex workbooks with many linked sheets, weighted scoring roll-ups

Required

Advanced BI dashboard build-outs, administration, and enhancements to all products created. Advanced data source administration that feeds the BI solution (SQL)

Required

Workflow experience developing SharePoint workflows and PowerAutomate workflows, debugging, servicing, and production support of the workflows. Adv SharePoint functions like polling, report building, dynamic data pulls and scripted or automated functions

Required

Developing, building, and deploying databases and data analytics platforms

Required

Transitioning financial and operational management data and reports from Excel to PowerBI

Required

Writing queries; and integrating Power BI reports into other applications as needed.

Required

Technical and business analyst experience, including development and working with staff to create and implement procedures

Required

Experience extracting and analyzing data from large, complex applications

Required

BSc/BA in Computer Science, Informatics, Business Intelligence, Engineering, or relevant field

Preferred

Experience with Federal, State, or Local government data reporting; with strong understanding of state government.

Keywords: REETECH USA, Austin , Business Intelligence Analyst, Professions , Austin, Texas