Sr. Power BI Developer

BIICS, Inc is looking to fill a Sr. Power BI Developer position. The position is located in Tallahassee, Florida and work is on-site.

Responsibilities:

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

• Analyze financial data and make recommendations to

improve the data model of financial systems.

• Provide administration of the Power BI dedicated

workspace.

• Train staff from the office of the comptroller on

using Power BI reports.

Requirements

Potential candidate must possess the following:

• Bachelor's Degree in a field of study related to

technology or finance. Work experience can substitute on a year for year basis for the degree.

• Candidate must have a minimum of 3 years' experience

in Business Intelligence and at least two years of experience developing dashboards and reports in Microsoft Power BI.

• Candidate must have experience with IBM DB2 databases.

• Experience building dashboards and reports leveraging

Microsoft Power BI.

• Experience developing paginated reports in Power BI.

• Strong SQL skills.

• Well versed in data governance best practices.

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

• Familiarity with advanced data structures such as OLAP

cubes and Star/Snowflake Schema.

• Knowledge of how Power BI integrates with other

Microsoft tools such as Power Automate, Power Apps, Power Point, and Teams.

• Analytical thinking for converting data into relevant

reports and graphics.

• Understanding of how to implement solutions with

multiple data sources.

• Experience with IBM DB2 databases.

• Knowledge of Mainframe flat files.

• Knowledge of the SCRUM Framework.

Preferred KSAs:

• Experience with Oracle Datawarehouse.

• Knowledge of mainframe programming languages,

computer systems and supporting software.

• Knowledge of financial systems such as an

ERP.

• Experience with WebFOCUS 9 General Knowledge

Skills.

Benefits

Health insurance.