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