DATA ANALYST II - CORE Electric Cooperative

NOTE: CORE Electric Cooperative cannot offer sponsorship for candidates in this role, either currently or in the future.

About CORE

CORE Electric Cooperative is the largest member-owned electric distribution cooperative in Colorado dedicated to providing reliable, affordable, clean, and safe electric service to our communities. With a commitment to innovation and member satisfaction, we strive to meet the evolving needs of our members while maintaining the highest standards of service excellence.

About the job

CORE Electric Cooperative is seeking a Data Analyst II to join our Data Architecture team, reporting to the Data Architecture Manager, located in the Sedalia office.

As a data analyst, you will be responsible for collecting, processing, analyzing, and reporting data to support business decisions and strategic initiatives. You will also collaborate with other departments and stakeholders to identify data needs, design solutions, and communicate insights. This position will be responsible to the Data Architecture Manager and will be a key support role to realize our data strategy and roadmap. The data analyst will be involved in enhancing our existing data warehouse, supporting our data governance and security processes, as well as supporting dashboard design and development of extract, transform and load (ETL) processes.

This is an Exempt onsite position at our Sedalia office, located at 5496 North U.S. Highway 85, Sedalia, CO 80135.

You will...

• Collaborate with the Data Architecture Manager and business stakeholders to understand and capture data requirements and objectives in order to translate business needs into effective data solutions.
• Build integration requirements and support integration development for internal and external data sources.
• Support and drive the design and development of scalable and efficient data warehouses, leveraging best practices for data modeling, ETL processes, and data storage.
• Create and manage databases, including schema design, indexing, and data modeling.
• Implement integration solutions to facilitate data exchange between various applications, systems, and platforms using ETL tools.
• Implement connectors for querying and reporting on the data warehouse. This may include business intelligence (BI) tools that enable users to create dashboards, reports, and ad-hoc queries.
• Resolve integration-related issues to ensure data consistency.
• Monitor the performance and stability of integrations.
• Implement security measures to protect data during transit and storage.
• Work within and support a formal data governance framework that defines the structure, roles, and responsibilities (owners, stewards, users) for data governance within the organization.
• Support the classification of data based on its sensitivity and criticality. Define levels of confidentiality, integrity, and availability for different types of data to guide appropriate handling and protection measures.
• Use established processes to ensure the quality and accuracy of data within the warehouse. Implement validation checks, data profiling, and cleansing routines to maintain data integrity.
• Use monitoring tools to track the health and performance of the data warehouse. Establish routine maintenance tasks, such as data purging, to keep the warehouse running efficiently.
• Collaborate with business stakeholders to understand and capture dashboard and analytic requirements and objectives.
• Design and create sophisticated and meaningful visualizations using tools like Tableau, Power BI, or Excel.
• Apply best practices and design principles to enhance the visual appeal and usability of visualizations.
• Leverage low/no-code tools such as Power Automate and Power Apps as needed to deliver data-focused solutions.
• Support business end users in their creation of dashboards and reports.
• Collaborate with cross-functional teams, including subject-matter experts, consultants, and vendors.
• Manage small to medium sized end-to-end data projects and support large sized end-to-end data projects.
• Be able to analyze performance, troubleshoot issues, and recommend enhancements for existing data-focused solutions.
• Perform Data and Dashboard testing processes to ensure quality product to end users.
• Create and maintain detailed documentation of data-focused configurations, code, and processes for future reference and troubleshooting.
• Support CORE's Artificial Intelligence strategy and roadmap as it relates to data needs.
• Manage vendors engaged in data-related projects.

We are excited to speak to someone with the following...

Minimum Qualifications:

• Bachelor's degree in a related field, such as computer science, data science, information technology, statistics, mathematics, business, or equivalent experience.
• 5-10 years of experience as a Data Analyst or similar role.
• Firm understanding of data modeling, data architectures (data warehouse, data lake, lake house), integration methodologies, database administration, and relevant software and tools.
• Knowledge of security best practices in database, integration, and data management.
• Understanding and implementation experience in
  • SQL and database platforms such as SQL Server and Oracle.
  • ETL tools such as SQL Server Integration Services and Pentaho PDI.
  • Low/no-code tools such as Power Automate and Power Apps.
• Advanced experience with data visualization tools such as Tableau and Power BI.
• Strong analytical and problem-solving skills with attention to detail.
• Strong analytical and problem-solving skills.
• Excellent communication, collaboration, and interpersonal skills.
• Strong attention to detail.
• Ability to work independently and as part of a team.
• Adaptability and willingness to stay updated with emerging technologies and best practices.

Preferred Qualifications:

• Experience in leading small to medium sized teams, formally or informally, towards the execution of a project, deliverable, or initiative.
• Understanding of project management concepts.
• Experience with mainstream Data and Data Governance platforms such as Microsoft Fabric.
• Ability to use scripting and automation languages (e.g., JavaScript, Python, PowerShell).
• Exposure to Artificial Intelligence implementations and tools (Copilot, machine learning, large language models, natural language processing).
• Knowledge of electric utility data and applications such as advanced metering infrastructure, outage management, work order management, billing & payments, and customer information systems.

CORE offers a comprehensive benefits package including the following...

• 9/80 work schedule: Every other Friday off!
• Eight paid holidays per year
• 160 Hours of accruable PTO per year
• Paid parental leave (80 hours)
• Education and training reimbursement
• Volunteer paid time off
• 100% Cooperative paid benefits, including:
  • Defined benefit pension plan
  • Medical insurance
  • Dental insurance
  • Vision insurance
  • Short term disability
  • Long term disability
  • Long term Care
  • Employee assistance program
  • Life insurance
  • HSA employer contribution: $900 for employee only, $1,800 for employee + dependents
• 401(k) retirement plan with company match up to 4%. Immediately 100% vested
• Wellness reimbursement: Up to $300 per year
• Travel assistance & identity theft support services
• Length of service program

• Free Onsite EV charging stations (at certain locations)
• Onsite micro market (at certain locations)
• Onsite gym with golf simulator and massage chairs (at certain locations)

Salary Range: $92,456 - $123,178 annually

This position is eligible for a discretionary annual incentive program driven by organizational and individual performance up to 5%.

The application deadline for this job is estimated to be September 30th, 2024. However, this timeline may be shortened or extended depending on business needs, the availability of qualified candidates, and whether the role is filled or not. We encourage qualified candidates to submit their application(s) expediently so as not to miss out on opportunities.

CORE is an Equal Opportunity Employer.

• EEO is The Law - click here for more information
• Equal Opportunity Employer Minorities/Women/Protected Veterans/Disabled
• We consider all applicants for employment without regard to race, color, religion, sex, sexual orientation, national origin, age, handicap or disability, or status as a Vietnam-era or special disabled veteran in accordance with federal law. If you need assistance, please reach out to us at hr@core.coop