Power Bi Developer

Job Description
BIICS, Inc is looking to fill a Power BI Developer position. The position is located in Tallahassee, Florida and work is on-site. If you or someone in your network meets the qualifications and are interested in the position, please contact us at the link below.

Power BI Developer

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.

Business Intelligence & Informatics Consulting Services, Inc. (BIICS, Inc) is a business and information management solutions company serving clients in both the public and private sector.With access to new opportunities every day, BIICS, Inc is a premier source for placing highly skilled individuals with the most sought-after career opportunities and salaries.

Benefits

Health insurance.