Job Title: Power BI Developer/Applications Development Analyst
Job Summary
The role requires strong Power BI, SQL, IBM DB2, financial reporting, data warehousing, and legacy reporting modernization experience.
Required Qualifications
- Bachelor's degree in Technology, Finance, or related field; equivalent experience may substitute.
- 3+ years of Business Intelligence experience.
- 2+ years of Power BI dashboard/report development.
- Hands-on experience with IBM DB2.
- Experience developing Power BI dashboards and reports.
- Experience with Power BI paginated reports.
- Experience with Power BI dataflows.
- Experience working with multiple data sources.
- Understanding of data governance and data management.
- Experience with financial data/reporting.
Technical Skills
Power BI
- Power BI Desktop
- Power BI Service
- Paginated Reports
- Dataflows
- Dedicated Workspaces
- Power BI Administration
- Power Automate
- Power Apps
Database / SQL
- SQL
- T-SQL
- IBM DB2
- Stored Procedures
- Database Views
- Data Transformation
Legacy / Mainframe
- WebFOCUS
- Mainframe FOCUS
- Mainframe flat files
- Mainframe reporting
- Legacy report modernization
- Data Warehousing
- Operational Data Stores
- Data Lakes
- Master Data Management
- OLAP
- Snowflake Schema
- Multiple Data Sources
Business Domain
Key Responsibilities
- Analyze existing data environments and determine transformation requirements.
- Develop organizational reporting roadmaps.
- Analyze and modernize existing reports based on business requirements.
- Develop Power BI dashboards and reports.
- Create Power BI dataflows.
- Develop paginated reports.
- Read and document WebFOCUS/Mainframe FOCUS queries.
- Work with DBAs to create database views and stored procedures.
- Analyze financial data and recommend improvements to data models.
- Administer Power BI dedicated workspaces.
- Train business users on Power BI reports.
- Support data governance and reporting best practices.
- Collaborate with developers, DBAs, business users, and management.