Senior Systems Analyst and Developer

SENIOR SYSTEMS ANALYST AND DEVELOPER

Salary : Range 53 ($10,108 - $12,287 / per month DOQ)

Employment Status : Regular, Exempt, Full-Time position

Benefit Package : Regular, Full-Time Employee Benefits

Remote Work : Up to 10 hours Per Week of Remote Work Permitted After 6 Month Onboarding Period

Schedule : 5 x 8 or 4 x 10 with Flexible Schedule Options

Reports to : Technology Supervisor

To Apply : Visit https : / / www.epud.org / about-us / careers / to complete the online application and submit the following documents :

• Resume
• Veterans’ Preference Form, if applicable

Culture and Environment :

At Emerald PUD, we take pride in delivering electricity to approximately 23,000 meters that serve our customers and communities, with safety and reliability as our top priorities. We were founded on the idea that employees should own part of the decision-making process and have upheld that value over the years. We strive to create an environment where employees are empowered to do what is right for both the utility and our customers. We are a small and nimble team that can adapt quickly when conditions change, and we get the opportunity to wear many hats and collaborate with other departments and employees on a regular basis. We provide flexibility with work schedules, offer a strong compensation and benefits package, and continuously look for ways to help our employees create and maintain a healthy work / life balance.

Core Values : Service

Flexibility

Empowerment

Reliability

Safety

Job Summary :

As a member of the Technology Team, the Business Solutions Architect plays a key role executing Emerald’s long term strategic plan with technology infrastructure and business processes.  This hybrid role blends deep business analysis with hands-on software development. The ideal candidate serves as a bridge between business needs and technical implementation, requiring skills in requirements analysis, data management, data flow (ETL), and software development in general purpose programing languages (e.g. Python, .NET, HTML / Javascript). The position supports both operational and strategic initiatives by ensuring operational processes yield high quality data that drives meaningful insights.  The ability to professionally interface with stakeholders to understand needs and collaborate with internal and external resources to develop solutions is essential.  Solutions may include changes to workflow, customized reporting / business intelligence tools, automations, data integrations from different systems, or custom developed solutions.

Duties and Responsibilities :

Amount of time working in each function may vary. It is expected that the amount of time spent performing each function will fluctuate as needed for an employee to successfully manage their schedule.

1.     Information Systems Architecture & Data Management - Serve as Emerald’s subject matter expert on data flows, integrations, and information systems architecture. Understand key concepts of data management such as accuracy, consistency, and completeness. Responsible for implementing and maintaining data management practices to ensure consistent data across systems.  Oversee the data architecture including developing a data warehouse and ETL (extract, transform, load) processes for reporting.  Create technical proposals or architecture diagrams that translate business requirements into systems components.  Assist GIS team with data requests.

2.     Business Systems and Process Support – Collaborate with end users and stakeholders to identify information gaps, inconsistencies, and inefficiencies with information systems and processes. Be able to communicate complex systems information in plain language to ensure communication and understanding.

3.     Technical Development and Administration – Own the full lifecycle of solution delivery; from requirements gathering and design to development, testing, deployment, and support . Develop ETL processes for data management and integration.  Able to directly query data in relational databases or via API for reporting or workflow integration.  Develop internal tools, data pipelines, or workflow automations when off-the-shelf solutions are not viable using common languages such as python or .Net.  Develop documentation for new solutions and manage code with version control and a source code repository.

4.     Work Management - Collaborate with Technology Supervisor to identify and prioritize tasks. Embrace the culture of empowerment by using sound judgment, thoroughly reviewing and analyzing problems, making reasonable recommendations, and developing alternate solutions when necessary. Work independently, take ownership of assignments, and follow through to ensure projects and tasks are completed on time and in a thorough manner. Take initiative to solve problems and explore opportunities to increase efficiencies.  Be comfortable with cross-functional teams on large and small projects.

5.     Communication and Collaboration - Focus on developing strong working relationships with colleagues in order to gain trust and cooperation.  Collaborate with end users and stakeholders to identify opportunities and increase efficiencies.  Present ideas, views, and project status updates in a clear and logical manner.  Communicate with vendors and development partners in a professional manner and negotiate with tact.  Provide exceptional service to both internal and external customers to help build Emerald’s brand as a trusted advisor and provider of choice.

Skills :

1.     Must possess detailed knowledge of major operational business processes with relation to information services.

2.     Must have experience in developing requirements, business process, workflow modeling, and software testing.

3.     Must have high-level knowledge and experience working with relational databases concepts and structures, including proficiency in SQL syntax and writing queries against complex databases (e.g. T-SQL, PL-SQL) as well as some basic SQL Server Database Administration Knowledge.

4.     Must be comfortable using web services and other modern API concepts to facilitate data transfer between systems and to support systems integration projects.

5.     Working knowledge and experience working with general-purpose programming languages (e.g. Python, .NET, HTML / Javascript) required.

6.     Knowledge and experience with project management principles, including planning, execution, risk, and change management.

7.     Must be comfortable working in a small organization with a culture of limited hierarchy and greater autonomy.

8.     Must be self-directed at times and able to proactively work with others to solve problems.

9.     Knowledge of data analytics / data science and related software suites is a plus.

Experience :

1. Must have a minimum of five (7) years of experience in roles such as System Analyst, Software Developer, Data Architect, Business Analyst.

2.     2 years Experience working with Geographic Information Systems (GIS) and utility connectivity models.

3.     Experience deploying serverless cloud solutions in Microsoft Azure is a plus.

4.     Experience working within the utility industry is a plus.

Note : This description is intended to represent the key areas of responsibility. It is not meant to be all-inclusive and does not prescribe or restrict the work that may be assigned. Nothing in this description restricts EPUD’s right to assign or reassign duties and responsibilities to the job at any time. Job descriptions may occasionally be updated, as necessary, to reflect evolving business needs.