Data Technology Administrator

OUC - The Reliable One, an industry leader and the second largest municipal utility in Florida committed to serving the community and the environment is presently recruiting for a Data Technology Administrator to be part of our growing team in the Meter Data Operations division.

We are looking for an organized and knowledgeable individual with a high level of accuracy and efficiency skills to be responsible for analyzing and troubleshooting meter data to ensure accurate customer billing, meter data sharing, resolution of system/sync errors, and identification of metering issues. ?

OUC’s mission is to provide exceptional value to our customers and community through the delivery of sustainable and reliable services and solutions. Click here to learn more about what we do.

The ideal candidate will have:

·       Bachelor’s Degree in Computer Science or related field of study from an accredited college or university or one year (1) of additional experience, as described below, may substitute for each year short of the education requirement;

·    Minimum of three (3) years of experience delivering data and/or application solutions, built from requirements and applying software tools to include one (1) year of experience as a systems administrator for computer applications such as data management applications (AWS, Snowflake, etc.) or building dashboards, or working with communication systems such as metering AMI head end systems

·    Experience with corporate applications such as billing systems, financial systems

·    Experience with analyzing, validating, and testing data using SQL (structured query language

·    Experience with system upgrades

·    Utility industry experience (preferred)

OUC Total Rewards package includes to cite a few:

·       Competitive compensation

·       Low cost medical, dental benefits, and paid life insurance premiums with no probationary period

·       Retirement benefits include a cash balance account with employer matching along with a health reimbursement account

·       Paid vacation, holidays, and sick time

·       Educational and professional assistance programs;

·       Paid memberships in professional Associations;

·       Paid conference and training opportunities

·       Free downtown parking 

·       Free Gym membership

·       Hybrid work schedule

Click here to view our Benefits Summary.

Salary Range: $34.47- $43.09 per hour (est. $71,697 - $89,627 annually)

Location: 6003 Pershing Avenue, Orlando, FL 32822

Please see below a complete Job description for this position.

Job Purpose:

Responsible for analyzing and troubleshooting meter data to ensure accurate customer billing, meter data sharing, resolution of system/sync errors, and identification of metering issues.

Responsible for the support, maintenance and utilization of multiple software application systems related to meter data, such as Automated Metering Infrastructure (AMI), Head-End System (HES), and Meter Data Platform (MDP). Builds and delivers meter data solutions and dashboards from requirements for a variety of internal stakeholders.

Primary Functions:

·       Develop and enhance OUC's Meter Data Platform (MDP) to support business operations use cases by ensuring all captured AMI data is stored and accessible;

·       Maintain/enhance Meter Data Platform and data integrations providing foundational tools set for team daily operation activities;

·       Monitor various data transfers for completeness and data integrity from HES and MDP;

·       Implement policies and objectives of Advanced Metering Infrastructure (AMI) initiatives as technical expert on AMI design and configuration; maintain back office AMI and metering end points data collection to support OUC's core application integrations;

·       Conduct daily data inspections and make determinations regarding device performance in order to escalate/create necessary field operation Field Activities;

·       Provide recommendations that will improve data integrations and workflow, mitigate data risks, and respond with documented solutions for new meter data requests;

·       Analyze, validate, and test meter data using SQL (structured query language) to discover anomalies and behavior patterns; develop complex, effective and efficient SQL queries to extract and analyze data to support additional data requests, incident research, and respond to data issues reported by OUC internal and external customers; develop SQL DDL (data definition language) and DML (data manipulation language) code in the Snowflake cloud database to define and manipulate data models

·       Research customer (end point, meter) consumption usage, power quality recorded events and prepares information in usable format for EWD engineering and operations teams; prepare comprehensive meter, field activity and billing assessments to support meter to cash (billing) activities; analyze large volumes of data related to meter endpoint usage, events, status, health, instrumentation and network performance; identify problems and correct data when necessary;

·       Develop, schedule and maintain various daily and periodic reports, ETL (extract, transform, load) pipelines and orchestrate operations through ETL technologies (Talend and Talend Management Cloud); provide ad hoc reports internally and to other Business Units as needed;

·       Collect and assess business requirements to develop use cases; perform analysis of data to determine solution effectiveness;

·       Design, test, and implement data visualizations, dashboards, and automated workflows of analysis and end-user impact by applying gathered business requirements, and data from diverse systems & technologies (Alteryx, Tableau, Snowflake etc.);

·       Support Key Business Operations such as Electric and Water Workflow for Connectivity Model Analysis, as well as additional Operations Use Cases utilizing the MDP

·       Coordinate department pilots and assist with data transfer and tracking of large-scale AMI deployment projects.

·       Perform system administration responsibilities for any of the following application/areas: cloud based Meter Data Platform, AMI network (HES), route management software, MV-90 hardware/software, AMI communication issues and any additional technology field solution;

·       Monitor and maintain system health and performance; perform file movement and use case support/management, respond to/resolve system anomalies, liaise with vendors and users/technical staff, support infrastructure enhancements, and help ensure system performance across multiple environments;

·       Proactively research and plan necessary application/system patches/upgrades by coordinating testing and release management with impacted areas following change management methodology and documentation best practices;

·       Develop documentation using Visio, Excel & PowerPoint contribute to the documents for the MDP (meter data platform infrastructure diagram, data source mappings, etc), Electric and Water Connectivity workflow analysis and other use case deliverables.

·       Provide verbal and written meter data application expertise of configurations needed to support OUC processes and system flows;

·       Utilize team methodology for business requirements documentation (use case intake form/testing results) and agile project management tools such as Jira;

·       Collaborate with other internal stakeholders (Digital & Technology, Operations, Customer Service, etc.) to identify data/systems needs and opportunities for improvement;

·       Represent OUC interest when attending software vendor conferences, user forums and other events that relate to meter data and AMI technologies; collaborate with various vendors/Consultants/Contractors to develop solutions on the MDP (Meter Data Platform).

·       Facilitate vendor support for implemented technologies such as Honeywell (NetSense/RouteManager HeadEnd Systems/Endpoint Management) in support of system health, updates and troubleshooting; review and approve updates, enhancements, and troubleshooting related to applications, systems, and firmware;

·       Perform other duties as assigned.

Technical Requirements:

·       Working knowledge of the following:

o   Corporate applications such as billing systems, financial systems

o   Corporate integrations and data transfers

o   Communication protocols and data transfers between end points

o   Database technologies and programming languages (e.g., Python, Microsoft SQL, Oracle, Snowflake, etc.)

o   Data analytics techniques and methodologies;

o   Technology issues with hardware, software, and network issues

·       Familiarity with but not limited to the following:

o   Electric meters;

o   Water meters;

o   Data visualization (e.g., Tableau, Qlk, PowerBI, etc.)

o   ETL technologies (e.g., Talend)

o   Related cloud based technologies (e.g., Amazon Web Services)

o   Alteryx- Analytic Process Automation Tool

o   Computer server, networking, virtual machine set up, administration and issue management

o   Related industry, organizational, and departmental policies, legal guides, best practices, and procedures, ordinances, and laws.

·       Effective oral and written communication and presentation skills;

·       Ability to:

o   Respond to 24x7 call-outs on a rotating basis, as a system administrator for the AMI HES, MDP or other related operational technologies.

o   Develop structured test scenarios, test cases, and perform accurate testing with documented results;

o   Develop complex structured queries for accurate results;

o   Lead technical design through application structured testing;

o   Create logical and physical data models and design user interfaces;

o   Integrate/share/publish timely data to third party systems needing access to operations data;

o   Develop and give related presentations to technical and non-technical audiences;

o   Lead and/or independently work through technical projects;

o   Provide training and/or guidance on meter data and related technologies to others.

o   Perform data analysis related to meter endpoint usage, events, status, health, instrumentation and network performance statistics;

o   Use Microsoft Office Suite (Word, Excel, Outlook, etc.) and standard office equipment (computer, fax, telephone, copier, etc.);

o   Make arithmetic computations using whole numbers, fractions, and decimals, and compute rate ratios, and percentages;

Education/ Certification/ Years of Experience Requirements: 

·       Bachelor’s Degree in Computer Science or related field of study from an accredited college or university or one year (1) of additional experience, as described below, may substitute for each year short of the education requirement;

·       Minimum of three (3) years of experience delivering data and/or application solutions, built from requirements and applying software tools to include one (1) year of experience as a systems administrator for computer applications such as data management applications (AWS, Snowflake, etc.), or building dashboards, or working with communication systems such as metering AMI head end systems;

·       Utility industry experience (preferred);

·       Must possess or be able to obtain/maintain one (1) or more certifications in the of the following technologies: AWS, Snowflake, Talend, Tableau, Alteryx (or have the ability to obtain certification within one year of hire)

Working Conditions:

This job is absent of disagreeable working conditions.

Physical Requirements:

This job requires very frequent typing, sitting, standing, operating machines/equipment, detailed inspection, speaking and hearing, and writing. This job requires frequent repetitive motions.

This job requires occasional walking and lifting up to twenty (20) pounds, reaching overhead, kneeling/crawling, and climbing.

OUC–The Reliable One is an Equal Opportunity Employer who is committed through responsible management policies to recruit, hire, promote, train, transfer, compensate, and administer all other personnel actions without regard to race, color, ethnicity, national origin, age, religion, disability, marital status, gender, sexual orientation, gender identity or expression, genetic information and any other factor prohibited under applicable federal, state, and local civil rights laws, rules, and regulations.

EOE M/F/Vets/Disabled 

The ideal candidate will have:

·       Bachelor’s Degree in Computer Science or related field of study from an accredited college or university or one year (1) of additional experience, as described below, may substitute for each year short of the education requirement;

·    Minimum of three (3) years of experience delivering data and/or application solutions, built from requirements and applying software tools to include one (1) year of experience as a systems administrator for computer applications such as data management applications (AWS, Snowflake, etc.) or building dashboards, or working with communication systems such as metering AMI head end systems

·    Experience with corporate applications such as billing systems, financial systems

·    Experience with analyzing, validating, and testing data using SQL (structured query language

·    Experience with system upgrades

·    Utility industry experience (preferred)