Drag

Business Intelligence

Location : ,

Job Description

We are seeking a PowerBI Developer w/DB2 to join our team. The selected candidate will work onsite in Tallahassee, FL alongside the project team.


Education

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


Required Experience

  • Candidate must have a minimum of 8 years' experience in Business Intelligence and at least four years of experience developing dashboards and reports in Microsoft Power BI.
  • Candidate must have experience with IBM DB2 databases.
  • Resume or supporting materials should include an example of a Power BI dashboard the candidate has created using IBM DB2 as a data source AND an example of a dashboard created presenting financial data.


Primary Job Duties/ Tasks
The selected candidate must be able to perform the following duties and/or tasks. Duties of the selected candidate will include, but not be limited to:

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


Job Specific Knowledge, Skills, and Abilities (KSAs):

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