Data Analytics & BI Systems Analyst

WA River Protection Solutions; Richland (WA); On-site; USD 82,000 - 138,000; Full time

Benefits offered by this job

Medical/Dental/Vision

401(k) match

Paid time off

Casual-dress environment

4-10s schedule

Job summary

CPCCo in Richland, WA, is seeking an experienced Data Analytics & AI specialist to design, develop, and maintain BI solutions including Power BI dataflows, datasets, reports, and dashboards. You will translate business needs into analytics systems, perform advanced data modeling, ETL, and cross-system analyses to improve data quality and efficiency.

You will lead customer discussions, mentor peers, and collaborate with cross-functional teams to deliver high-impact analytics while maintaining

Qualifications

• Bachelor's degree in CS, IT, AI, business, or related field; advanced degree a plus.
• Advanced proficiency with Microsoft Power Platform, Power BI Service, Power BI Desktop, Microsoft Office software.
• Advanced experience with M Power Query and DAX.
• Advanced proficiency with SQL, M, R, Python, HTML, and/or JavaScript.
• Extensive experience using data analytics platforms.
• Applied understanding of data science principles including machine learning and artificial intelligence.

Responsibilities

• Lead discussions with customers across CPCCo functional areas to gather requirements, define business needs, and guide solution direction.
• Translate complex business requirements into reporting, analytics, and business intelligence solutions that support operational and strategic decision-making.
• Design, develop, implement, and maintain BI solutions, including Power BI dataflows, datasets, reports, dashboards, and applications, while ensuring alignment with quality, compliance, and performance expectations.
• Perform advanced data modeling and cross-system analysis to identify and implement improvements to data structure, data quality, and data flow efficiency.
• Extract, transform, and integrate data from diverse sources using ETL methods and data management best practices.
• Drive continuous improvement by identifying opportunities to enhance analytics processes, reporting tools, and underlying data architecture.
• Partner with cross-functional teams to ensure data and reporting solutions support integrated business needs across the organization.
• Serve as a technical resource and mentor to others by sharing knowledge, supporting problem-solving, and promoting best practices.
• Manage multiple priorities independently and deliver high-impact analytics solutions in a timely manner.
• Perform work in a safe, compliant, and cost-effective manner.

Skills

Power Platform

Power BI

Office Suite

Power Query M

DAX

SQL

Python

HTML

JavaScript

Education

Bachelor's degree in CS/IT/AI/Business or related field

Tools

Microsoft Power BI Desktop

Power BI Service

Microsoft Office

Job description

CPCCo in Richland, WA, is seeking an experienced Data Analytics & AI specialist to design, develop, and maintain BI solutions including Power BI dataflows, datasets, reports, and dashboards. You will translate business needs into analytics systems, perform advanced data modeling, ETL, and cross-system analyses to improve data quality and efficiency.

You will lead customer discussions, mentor peers, and collaborate with cross-functional teams to deliver high-impact analytics while maintaining