Title: Application Development Analyst
Location: Tallahassee, FL
Job Description:
Education
Experience
Primary Job Duties/ Tasks
Job Specific Knowledge, Skills, and Abilities (KSAs)
Preferred KSAs:
General Knowledge Skills and Abilities (KSAs)
Location: Tallahassee, FL
Job Description:
Education
- 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.
Experience
- 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 (KSAs)
- 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
General Knowledge Skills and Abilities (KSAs)
- Communication: Ability to clearly convey information, in both written and verbal formats, to individuals or groups in a wide variety of settings (i.e., project team meetings, management presentations, etc.). Must have the ability to effectively listen and process information provided by others.
- Customer Service: Works well with clients and customers (i.e., business office, public, or other agencies). Able to assess the needs of the customer, provide information or assistance to satisfy expectations or resolve a problem.
- Decision Making: Makes sound, well-informed, and objective decisions.
- Flexibility: Open to change, new processes (or process improvement), and new information. Has the ability to adapt in response to new information, changing conditions,
- or unexpected obstacles. Ability to receive and give constructive criticism and maintain effective work relationships with others.
- Interpersonal: Shows friendliness, courtesy, understanding, and politeness to others.
- Leadership: Motivates, encourages, and challenges others. Adapt leadership styles in a variety of situations.
- Problem Solving: Ability to identify, evaluate, and use sound judgement to generate and evaluate alternative actions, and make recommendations as accordingly.
- Team Building: Encourages, inspires, and guides others toward accomplishing the common goal.