Description

Essential Functions:

  • 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.

Education

Any Graduate