Microsoft BI And Integration Specialist - (24-It-601006-081)

The intent of this job description is to provide a representative summary of the major duties, locations, and responsibilities performed by incumbent(s) in this job. Incumbent(s) may not be required to perform all duties in this description, and incumbent(s) may be required to perform work-related tasks other than those specifically listed in this description.

This job description is not a "contract" between the employee and the Authority. The job duties and essential functions may be changed at the discretion of the General Manager.

General

Job Title: Microsoft BI and Integration Specialist Job Code:

P0562 Supervises Directly: No New or Revised: Revised Regular or At-Will:

At-Will Date Last Revised: 5/14/2024 Exempt or Non-Exempt: Exempt Compensation Approval Signature: Union/ Non-Union:

Non-Union Department Name and Division: Information Technology- Data and Analytics Salary Schedule: Non-Union Salary Range Cost Center Code: 601006 Grade:

NU17 Essential Position: No Reports To: Sr. Program Manager, Data & Analytics EEO Code:

Professionals Work Format Hybrid

Who We Are & What We Do:

At DC Water, we provide more than 700,000 District of Columbia residents and 24.6 million annual visitors with essential water, wastewater, and stormwater services. DC Water also provides wholesale wastewater treatment services for 1.8 million people in Montgomery and Prince George's counties in Maryland, and Fairfax and Loudoun counties in Virginia.

We aspire to be known for superior service, ingenuity, and stewardship to advance the health and well-being of our diverse workforce and communities. To achieve this vision, we commit to our shared mission every day-exceeding expectations by providing high quality water services in a safe, environmentally friendly, and efficient manner.

Role Description:

The Microsoft BI and Integration Specialist is responsible for managing and maintaining DC Water's mission critical Advanced Metering Infrastructure (AMI) and applications including but not limited to High Usage Notification Alert and Consecutive Usage Alert systems. This position is responsible for testing and implementation as well as supporting post implementation components of the core AMI application and components utilizing the meter reading information supplied by AMI.

The employee must be highly adept at identifying user needs, gathering, and analyzing requirements, translating them into software requirements and working with the other Principals/Lead Engineers, Architects and Cyber Security Professionals to build and deploy high quality reliable and sustainable solutions that meet or exceed our business partner expectations. The employee must have expertise in data management, data warehousing and SQL concepts and applications.

Essential Duties & Responsibilities:

• Work with the client community to identify business challenges that can benefit from the application of information technology.

• Gather and translate user requirements into technical requirements that address business challenges.

• Design and develop solutions that leverage all elements of the IT stack including but not limited to core applications in customer service, finance and operations, AMI systems, data warehouses, business intelligence and data analytics solutions.

• Provide support for regular updates of the AMI application and infrastructure and solutions that rely on the AMI technology stack.

• Provide recommendations to management and implement action plans to improve performance and cost effectiveness.

• Provide detailed technical training, mentorship, peer review, and/or guidance to others.

• Apply technical knowledge to help promote a safe work environment and to enhance customer satisfaction.

Supervisory Responsibilities: N/A

Key Working Relationships: Interacts with employees throughout DC Water including senior and executive management, officials, representatives; staff from various regulatory agencies; and vendors.

Skills & Qualifications:

The qualifications listed below are representative of the knowledge, skill, and ability necessary for an individual to perform each essential responsibility satisfactorily. Reasonable amounts of training are provided..

Required Skills & Qualifications

Required Experience:

Five (5) years' experience in administering and supporting AMI and/or similar systems; or a High School Diploma or equivalency and nine (9) years' experience in administering and supporting AMI and/or similar systems.

Five(5) years' experience utilizing and integrating applications with XML, SOAP,REST, YAML, SQL, .NET and/or JAVA as well as MS-SQL databases.

Bachelor's degree in computer science, or a related technical field from an accredited college or university.

Required Skills: Database programming languages (SQL, PL/SQL, or T-SQL) Data warehousing concepts and methodologies Data management tools and technologies (Hadoop, Spark, NoSQL) Power BI development/reporting AMI system infrastructure (meters, meter transmitting units, repeaters, and other communication system components). Software troubleshooting IBM Maxi Microsoft Power Platform Microsoft Power BI Cloud Technologies (Azure, Data Factory, Date Lake, Data Warehouse Solutions) Required Licenses & Certifications:

N/A Required Languages: English Physical Requirements: General office conditions

Your Experience at DC Water:

At DC Water, our people make us an industry leader. Join a group of thinkers, innovators, and problem solvers focused on protecting life's most precious resource in the nation's capital.

• Take pride in your work. We provide an essential service and do work those matters. A career at DC Water is an exciting opportunity to help improve the environment and make a lasting difference for the community.

• Connect to a strong culture. Everything we do is grounded in our shared values-accountability, trust, teamwork, customer focus, safety, and wellbeing.

• Be your true self. We are an inclusive organization that embraces diversity, and we recognize and celebrate employees' individuality and unique contributions.

• Build your skills and career path. We are committed to developing a future-ready workforce by helping our employees develop skills for the jobs of tomorrow.

We are proud to be an EEO/AA employer M/F/D/V.

We maintain a drug-free workplace and perform pre-employment substance abuse testing

The Americans with Disabilities Act prohibits discrimination against "qualified individuals with disabilities."

If a reasonable accommodation is needed to participate in the job application or interview process, to

perform essential job functions, and/or to receive other benefits and privileges of employment, please

email complianceada@dcwater.com.