PowerBI Developer

TechWish; Tallahassee (FL); On-site; USD 85,000 - 110,000; Full time

Job summary

TechWish in Tallahassee, FL is seeking a Power BI Developer with 3+ years of BI experience and 2+ years building dashboards in Power BI. You will convert WebFOCUS and Mainframe FOCUS queries to T-SQL, create dataflows, and collaborate with IT to optimize data models.

This is an onsite role with local candidates only. Responsibilities include analyzing data environments, developing a reporting roadmap, improving existing reports with business users, automating data transformations, and training

Qualifications

• Minimum 3 years in Business Intelligence and 2+ years creating Power BI dashboards.
• Experience with IBM DB2 databases.
• Strong SQL skills and data governance knowledge.
• Familiarity with Data Warehousing, Data Lakes, and Master Data Management concepts.
• Experience converting legacy queries (WebFOCUS/Mainframe FOCUS) to Power BI data models.

Responsibilities

• Analyze the current data environment and data structures to determine transformations for dashboards.
• Develop an overall reporting roadmap with management.
• Improve existing reports based on current business needs with business users.
• Automate data transformations to reduce reliance on pivot tables and Excel analysis.
• Convert WebFOCUS/Mainframe FOCUS queries to T-SQL.
• Create database views and stored procedures to facilitate Power BI reports.
• Create dataflows in Power BI.
• Analyze financial data to improve data models of financial systems.
• Administer the Power BI workspace.

Skills

Power BI

SQL

IBM DB2

Data Governance

OLAP

Mainframe FOCUS

WebFOCUS

Data Warehousing

SCRUM

Tools

Dataflows

T-SQL

Job description

Title: Power BI Developer

Location: Tallahassee, FL 32399 (Onsite)

Local candidates only

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.

Primary Job Duties/Tasks

• 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

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