Applications Development Analyst / Power BI Developer

KAIS ASSOCIATES LLC

Tallahassee, FL, United States

8 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Experienced

Experience required

2 years minimum

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Microsoft Excel Agile Methodology Data Analysis Data Governance Data Transformation Data Warehousing IBM DB2 Mainframes Online Analytical Processing Oracle Warehouse Builder Pivot Tables Microsoft PowerPoint

+14 more

Scrum Methodology Power BI Standard Sql Software Engineering SQL Stored Procedures Transact-SQL Microsoft Power Automate Mainframe Programming Data Lakes Star Schema WebFOCUS Data Management Database View Powerapps

Job description

Analyze data environments and determine transformation requirements for Power BI dashboards. Develop and maintain Power BI dashboards, reports, paginated reports, and dataflows. Create reporting roadmaps and work with business stakeholders to improve existing reports. Automate data transformation processes and reduce dependency on Excel/pivot-table analysis. Analyze and document WebFOCMainframe FOCUS queries. Convert legacy FOCUS queries into T-SQL. Work with DBAs to create database views and stored procedures for Power BI reporting. Develop financial data models and provide recommendations for improving reporting. Administer Power BI dedicated workspaces. Work with multiple data sources and develop integrated reporting solutions. Train business users on Power BI reports. Apply data governance and data-management best practices.

Requirements

3+ years Business Intelligence experience 2+ years developing Power BI dashboards and reports Strong Power BI Paginated Reports Strong SQL / T-SQL IBM DB2 Data governance Data Warehousing / ODS / Data Lakes / MDM Financial reporting/data experience OLAP cubes Star Schema / Snowflake Schema Power BI integration with Power Automate, Power Apps, PowerPoint, Teams Multiple data-source integration Mainframe flat files Scrum/Agile knowledge

Preferred Skills WebFOCUS Mainframe programming/system knowledge Oracle Data Warehouse ERP / financial systems Mainframe FOCUS experience