Analyst, Data and Systems

Summary

Join Clean Power Alliance (CPA) as an Analyst, Data and Systems! This role involves implementing CPA’s Data and Systems Strategic Plan, developing solution requirements, evaluating RFP responses, and working with vendors to deploy new systems. Key responsibilities include data reporting, data storage, cloud environment management, requirements gathering, and project management. You will optimize solutions for cost-effectiveness and explore new IT applications for CPA’s business processes. The position reports to the Director, Data & Systems and requires collaboration with internal and external stakeholders. CPA values diversity and fosters a culture of open communication and collaboration. The ideal candidate will possess strong analytical, communication, and technical skills.

Requirements

• Demonstrate good judgement and integrity
• Excellent organizational, scheduling, time management skills, and attention to detail
• Strong project management skills
• Communicate effectively, orally and in writing, and can translate complex technical information into non-technical language
• High tolerance for uncertainty and can bring issues to resolution
• Have a strong work ethic and be comfortable taking initiative/working in a fast-paced environment
• Must be able to work at a desk and work on a computer for prolonged periods
• Candidates must have a bachelor’s degree and a minimum of 2 years of relevant experience
• Knowledge of data systems, analytics, and cloud providers, including Snowflake and AWS
• Experience with Jira, Confluence, or another project management tool

Responsibilities

• Assists with the implementation of CPA’s Data and Systems Strategic Plan, developing solution requirements, evaluating RFP responses, technical documentation, and working with vendors and consultants to deploy new processes, applications, and systems (e.g. Data Analytics Platform, Forecasting and Analysis, ETRM, Financial Management & Accounting, Financial Modeling, Budget, and Planning Analysis)
• Key areas of focus include but are not limited to data reporting, data storage, cloud environment deployment and ongoing maintenance, requirements gathering and management, technology assessment, interface development, product implementation and support, and project management
• The Analyst, Data and Systems will also assist in optimizing solutions to be as cost-effective and efficient as possible and seeking new opportunities to apply information technology to CPA’s business processes
• Responsible for communicating with internal and external stakeholders to elicit and develop technical requirements, including functional requirements, user stories, and acceptance criteria
• Responsible for creating, modifying, and verifying technical documentation in Confluence, including project/product release plans, technical requirements, as-built documentation, and product roadmaps
• Responsible for collaborating with team members across the organization to create, update, and track features, epics, and tasks in Jira
• Responsible for building reports and data visualizations in Tableau and other reporting tools
• Responsible for serving as subject matter expert and assists internal stakeholders with report creation, modification, and technical challenges
• Serves as the Tableau administrator for CPA, assigning and removing licenses, and managing folder permissions
• Responsible for creating and maintaining a data catalog of datasets in cloud-based applications (Tableau, Snowflake, AWS, etc.)
• Responsible for maintaining an inventory of production data products, including pipelines, reports, and models
• Responsible for collaborating with team members to develop, document, and maintain data quality standards
• Assist internal stakeholders with creating and maintaining data quality dashboard(s)
• Assists internal and external stakeholders with troubleshooting data quality issues or processes, and transfer issues with service providers
• Responsible for providing records management support and platform support of SharePoint and other enterprise content management systems
• Collaborate with other team members to support deployment and maintenance of third-party systems, custom-built systems, and data pipelines between CPA’s various data sources and Snowflake
• Responsible for assisting users across the organization with data access, development of standard and customized reports, and technical issues
• Implement and maintain business intelligence (BI) tools and dashboards in collaboration with the marketing, customer programs, account services, finance, and power procurement teams
• Provide support to internal staff as needed and accurately document and escalate issues as necessary
• Responsible for installing and configuring hardware and software components, including but not limited to antivirus software
• Responsible for testing and evaluating new technology, including upgrading systems to enable compatible software
• Perform tests on new hardware and software and troubleshoot hardware and software issues
• Collaborate with internal stakeholders to analyze IT requirements and provide objective advice on the use of IT
• Partner with other members of the Data and Systems team to perform functions such as managing user accounts and profiles in various applications and assisting with preventing and resolving password and security issues
• Responsible for performing strategic analysis to identify trends and anomalies that impact operations and strategy and communicating results and relevant information to senior leadership
• Responsible for analyzing large datasets using innovative models and methodologies to derive actionable insights and deliver strategic recommendations to senior leadership
• Build analytical and operational capabilities by modeling best practices and collaborative problem solving
• Work in close collaboration with the marketing, customer programs, account services, finance and power procurement teams to analyze data
• Responsible for coordination with third-party vendors and service providers to ensure timely delivery of products and services
• Responsibilities include coordinating payment and review of invoices, managing licenses and subscriptions, coordinating license renewals, reviewing contracts and service level agreements (SLAs), coordinating support requests or escalations, processing change orders, and tracking vendor performance
• Serve as the primary point of contact for vendor issue resolution, procurement updates, and project alignment to ensure vendors meet CPA standards and expectations
• Responsible for Data & Systems budget coordination activities, including budget preparation, tracking expenses against budget, forecasting future expenses, analyzing variances, and providing regular Data & Systems financial reporting
• Collaborate with leadership, finance teams, and other functional areas to optimize financial resource allocation, support strategic planning, and ensure compliance with CPA financial policies and procedures
• Monitor, analyze, and optimize cloud spending (AWS, Snowflake, Databricks, etc.) to ensure cost efficiency and alignment with budget
• Responsibilities include tracking usage and consumption patterns, identifying cost-saving opportunities, implementing resource tagging and budgeting policies, and generating regular reports for leadership and the Data & Systems team
• Performs other duties as assigned

Preferred Qualifications

• Degree in information technology, computer science, or engineering preferred
• Experience with programming languages such as R, Python, and JavaScript is a plus
• Excellent verbal and written communication skills with the ability to translate complex technical information into non-technical messages for stakeholders
• Experience and comfort presenting information to colleagues and external consultants
• Ability to work independently on projects and fully own tasks and processes
• Ability to act with integrity, professionalism, and confidentiality
• Ability to handle multiple priorities to meet deadlines and escalate key issues
• Works well with diverse teams and consultants and is highly collaborative
• Highly proficient with Microsoft Office Suite (particularly Excel and PowerPoint)
• Proficient in Tableau
• Proficient with cloud computing environments, such as AWS or Azure
• Proficient with SharePoint
• Proficient in SQL

Benefits

• Health care
• A 401(k)-like match program
• Paid vacation
• Sick leave