Report this job

---

What is the problem? *

Incorrect company
Incorrect location
Job is expired
Job may be a scam
Other

Position: Power BI

Location: Austin, TX

Need local to Austin consultants

Duration: Long term

Top Skills' Details

-SQL Server Development - version 2012 and beyond: This consultant is primarily going to be using SQL day to day.

-SSRS: Financial reports are primarily being developed using SSRS so this consultant is going to need to be able to develop reports using SSRS.

-Power Bi: Power BI is becoming popular at TRS so while this person doesn't necessarily need power BI development skills, it's a very strong nice to have.

Secondary Skills - Nice to Haves

Job Description

This consultant will be working on a variety of different projects for the financial department within TRS including:

- Automating the Reconciliation of Cash accounts reports.
- DW Build- Using SQL to test the data being migrated into the DW against control reports provided from a 3rd party Peoplsoft application.
- Reporting for Workiva (financial application)

Skills:

Extensive knowledge of SQL
SQL Server Management Studio experience
Extensive knowledge of complex data models
Strong data analysis/mining experience
Strong data validation skills
Strong Experience with ETL tools
Driving curiosity and attention to detail

Must-Haves
Strong SQL querying/writing experience
SSIS experience
Strong SQL experience, specifically SQL Server 2012.
Knowledge of data governance standards.

Responsibilities:

Defines, develops, and implements automation of reports, processes, and interfaces.
Designs and develops models to improve financial analysis and to project financial impact of business changes.
Interprets and translates accounting and finance business needs into effective applications and operational requirements to assist IT staff with implementation of finance and accounting system solutions.
Works with IT and Finance to perform testing and facilitate implementation of data warehouse.
Identifies data gaps, errors, anomalies, inconsistencies, and redundancies by analyzing the content, structure, and relationships within data.
Understands and compiles accurate data to present reports and assesses data quality.
Applies a broad range of techniques and theories from business intelligence, data analysis and visualization, statistics, and predictive analytics to deliver actionable business insights based on large-scale data.
Defines, captures, enriches, explores and preps data to support desired metrics monitoring and reports.
Leverages mature data with variable/algorithm selection, predictive and behavioral analytics to identify emerging risks and issues beyond operational controls.
Troubleshoots and resolves problems related to accounting and finance systems and applications.

Reporting
Provides thorough, visible, rigorous and transparent data reports and analysis.
Tracks trends and provides recommendations for solutions based on findings.
Interprets and communicates analytical insights to audiences with various analytical backgrounds using different but suitable communication methods for different audiences.
Develops visually appealing and intuitive dashboards that provide visibility into key performance, risk, and control indicators across agency divisions and departments.
Delivers quality results under short timelines.