Responsible for taking the knowledge transfer of 50 (approximately) existing reports developed using Power BI reporting tool and SQL Server database.
Performs data validation of the reports using MS Excel, MS Access, and other internal DCW systems.
Responsible for the delivery of existing 50 reports to business users.
Responsible for upgrading the existing reports for automation and performance improvement.
Develops new reports based on business needs while maintaining the existing 50 reports.
Ability to document reports execution and validation procedures.
Evaluates and recommends improvements to the current reports.
Creates business requirements, data flow diagrams, test data, test scenarios and design documents for the new reports.
Closely work with the reports end-users by providing/facilitating necessary training, support, and troubleshooting. Collects user input regarding reports functionality and explores feasibility of potential improvements/enhancements to the reports.
Identifies, coordinates, and resolves reports related issues by working with DC Water Business and IT teams.
Facilitates the creation of reports using the Power BI and other reporting tools provided by DCW team.
Ability to learn any new reporting tools introduced by DCW.
Performs a variety of self-directed and management directed tasks.
Relies on extensive experience and judgment to plan and accomplish goals.
Interacts with employees, contractors, and management at all levels.
Requirements:
The minimum qualifications listed below are representative of the knowledge, skill, and ability necessary for an individual to perform each essential function satisfactorily. Reasonable amounts of training are provided.
Requires a bachelor’s degree in finance, Accounting, Business Management, or Information Technology (or related field) from an accredited college/university, and five (5) years of hands-on experience in Microsoft Power BI reports and SQL Server Database.
Understanding of financial and accounting methods.
Experience in creating reports, dashboards, and data visualization using Microsoft Power BI. – must have
Experience in developing programs related to data transfer across multiple systems using SQL Server procedures, functions, and related development tools. – must have
Experience in SQL Server integrations services and SQL Management studio for development of queries. – must have
Expertise with ongoing maintenance and troubleshooting of Power BI-driven reporting, including query tuning. – must have
Strong MS Excel skills including formula building, pivot tables etc.
Understanding of Microsoft Access and SQL or similar database tools.
Experience presenting dashboards and quantitative data to stakeholders and leadership.