BI Developer – WebFOCUS​/Power BI (onsite

BI Developer – WebFOCUS/Power BI (onsite)

• Tallahassee, FL

14839 –
BI Developer – WebFOCUS/Power BI (onsite) – Tallahassee,FL

Start Date : ASAP

Type: Temporary Project

Estimated Duration :12 months with possible extensions

Work Setting: 100% of the time at the Client’s site. No telecommuting or remote work. This is a non-negotiable requirement from the client

Required:

• Availability to work 100% of the time at the Client’s site in Tallahassee,FL (required);
• Experience in Business Intelligence (3+ years)
• Experience developing dashboards and reports in Microsoft Power BI. (2+ years)
• Experience with IBM DB2 databases.
• Experience building dashboards and reports leveraging Microsoft Power BI.
• Experience developing paginated reports in Power BI
• Experience with SQL.
• Experience with data governance best practices
• Experience with data management concepts such as Data Warehousing, Operational Data Stores, Data Lakes, and Master Data Management
• Experience creating reports presenting financial data such as general ledger data, purchasing data, or revenue data.
• Experience with advanced data structures such as OLAP cubes and Star/Snowflake Schema.
• Experience with integration Power BI with other Microsoft tools such as Power Automate, Power Apps, Power Point, and Teams.
• Experience with IBM DB2 databases.
• Experience with Mainframe flat files.
• Experience with the SCRUM Framework.

Preferred:

• Experience with Oracle Data warehouse.
• Experience with mainframe programming languages, computer systems and supporting software.
• Experience with financial systems such as an ERP.
• Experience with WebFOCUS

Responsibilities include but are not limited to the following:

• Analyze the current data environment and data structures to determine if any transformation needs to occur prior to developing dashboards.
• Work with management to develop an overall reporting roadmap for the organization.
• Analyze existing reports and work with business users to determine how these reports can be improved based on current business needs.
• Work with developers and end users to automate data transformation reducing the reliance on pivot tables and analysis in Microsoft Excel.
• Read and document WebFOCUS and Mainframe FOCUS queries and convert them to T-SQL queries.
• Work with database administrators from the Office of Information Technology to create database views and stored procedures that will facilitate the creation of Power BI reports.
• Create dataflows in Power BI.