Applications Development Analyst

Jobtailor; Tallahassee (FL); On-site; USD 85,000 - 120,000; Full time

Job summary

Jobtailor is seeking a Business Intelligence professional in Tallahassee, FL to analyze data environments, design an BI roadmap, and transform and optimize reports for Power BI. The role focuses on SQL-driven data transformation, IBM DB2 integration, and financial data reporting, with responsibility for data flows and workspace administration.

The ideal candidate will have 3+ years in BI, hands-on Power BI development (including paginated reports), and familiarity with data warehousing concepts,

Qualifications

• Bachelor's Degree in a field related to technology or finance; work experience may substitute year for year
• Minimum 3 years' experience in Business Intelligence
• At least 2 years' experience developing dashboards and reports in Microsoft Power BI
• Experience with IBM DB2 databases
• Experience building dashboards and reports with Microsoft Power BI
• Experience developing paginated Power BI reports
• Strong SQL skills
• Knowledge of data governance best practices
• Familiarity with Data Warehousing, Operational Data Stores, Data Lakes, and Master Data Management
• Experience creating reports with financial data
• Familiarity with OLAP cubes and Star/Snowflake Schema
• Knowledge of Power BI integration with Power Automate, Power Apps, PowerPoint, and Teams
• Understanding of solutions using multiple data sources
• Knowledge of Mainframe flat files
• Knowledge of the SCRUM Framework
• Preferred: Oracle Datawarehouse, mainframe programming languages and systems, financial systems such as ERP, and WebFOCUS
• Ability to clearly communicate information in written and verbal formats
• Customer service, decision-making, flexibility, interpersonal, leadership, problem-solving, and team-building abilities

Responsibilities

• Analyze current data environment and data structures to determine transformation needs before dashboard development
• Develop an organizational reporting roadmap with management
• Analyze existing reports and improve them based on business needs
• Automate data transformation with developers and end users
• Read and document WebFOCUS and Mainframe FOCUS queries and convert them to T-SQL
• Collaborate with database administrators to create database views and stored procedures for Power BI reports
• Create Power BI dataflows
• Analyze financial data and recommend improvements to financial-system data models
• Administer the Power BI dedicated workspace
• Train comptroller's office staff on using Power BI reports

Skills

Power BI dashboard development

Strong SQL skills

IBM DB2 database experience

Data governance best practices

Financial data reporting

Education

Bachelor's degree in a technology or finance-related field

Tools

Power BI

Power Automate

Power Apps

PowerPoint

Teams

WebFOCUS

Job description

• Analyze the current data environment and data structures to determine transformation needs before dashboard development
• Develop an organizational reporting roadmap with management
• Analyze existing reports and improve them based on business needs
• Automate data transformation with developers and end users
• Read and document WebFOCUS and Mainframe FOCUS queries and convert them to T-SQL
• Collaborate with database administrators to create database views and stored procedures for Power BI reports
• Create Power BI dataflows
• Analyze financial data and recommend improvements to financial-system data models
• Administer the Power BI dedicated workspace
• Train comptroller's office staff on using Power BI reports

Requirements

• Bachelor's Degree in a field related to technology or finance; work experience may substitute year for year
• Minimum 3 years' experience in Business Intelligence
• At least 2 years' experience developing dashboards and reports in Microsoft Power BI
• Experience with IBM DB2 databases
• Experience building dashboards and reports with Microsoft Power BI
• Experience developing paginated Power BI reports
• Strong SQL skills
• Knowledge of data governance best practices
• Familiarity with Data Warehousing, Operational Data Stores, Data Lakes, and Master Data Management
• Experience creating reports with financial data
• Familiarity with OLAP cubes and Star/Snowflake Schema
• Knowledge of Power BI integration with Power Automate, Power Apps, PowerPoint, and Teams
• Understanding of solutions using multiple data sources
• Knowledge of Mainframe flat files
• Knowledge of the SCRUM Framework
• Preferred: Oracle Datawarehouse, mainframe programming languages and systems, financial systems such as ERP, and WebFOCUS
• Ability to clearly communicate information in written and verbal formats
• Customer service, decision-making, flexibility, interpersonal, leadership, problem-solving, and team-building abilities

Core Competencies

Demonstrates expertise in Business Intelligence with a strong focus on Microsoft Power BI, SQL, and data transformation. Capable of analyzing financial data and improving reporting processes while collaborating effectively with technical teams.

Highest-signal resume keywords

• Microsoft Power BI Dashboard Development
• Strong SQL Skills
• IBM DB2 Database Experience
• Data Governance Best Practices
• Financial Data Reporting

ATS Optimization Keywords

Hard Skills

• Data Transformation
• T-SQL
• Paginated Power BI Reports
• Data Warehousing
• Operational Data Stores
• Data Lakes
• Master Data Management
• OLAP Cubes
• Star/Snowflake Schema
• Mainframe Programming

Soft Skills

• Communication
• Customer Service
• Decision-Making
• Problem-Solving
• Team-Building

Industry Keywords

• Business Intelligence
• Financial Systems
• SCRUM Framework
• ERP

Tools & Technologies

• Power BI
• Power Automate
• Power Apps
• PowerPoint
• Teams
• WebFOCUS