Capital Project Intelligence

Perform data extraction, cleansing, analysis, dashboard creation, and reporting to support business decision-making and process improvements in a fully remote environment. | 3+ years of data analysis experience, proficiency in Power BI and SQL, ability to write complex queries, strong communication skills, and preferred Python, AWS, and Microsoft Data Analyst certification. | This is a remote position. CPI is seeking a Data Analyst to join our growing team! We are a full-service consultancy and professional services firm specializing in large capital projects (infrastructure, energy, etc). We are headquartered in Los Angeles, CA, but our team is fully remote. Job Summary: The Data Analyst Level 2 plays a key role in delivering advanced analytics, cross-functional insights, and proactive process improvements. This role requires strong analytical thinking, proficiency with a range of data tools, and the ability to collaborate across departments to shape data-driven decision-making. Key Responsibilities: • Support day-to-day analytics operations, including data extraction, cleansing, and report generation • Create dashboards with guidance from senior analysts • Understand business needs to assist in decision-making • Communicate results and insights clearly and concisely • Ensure timely project completion • Visualize data in an easily consumable way for business stakeholders, using advanced reporting tools and dashboards • Execute ETL processes to assess datasets, identify nulls or errors, and load data to appropriate platforms • Perform in-depth data analysis and compile clear technical reports and findings • Collaborate effectively within and across teams, providing actionable insights to guide decisions • Identify opportunities for process improvement and contribute to continuous enhancement of analytics practices Performance Metrics: • Leads smaller-scope projects • Can explain insights to client • Clear documentation of processes • Demonstrates proactivity in solutions and takes full ownership of work • Timeliness and accuracy of data analysis and reporting • Clarity and impact of dashboards and visualizations • Adherence to data integrity and database best practices Requirements • 3+ years of experience in data analysis, business intelligence, or a related field • Bachelor’s degree in Business, Computer Science, Engineering, Marketing, or related field, or equivalent experience; master’s degree a plus • Ability to independently write and execute complex and efficient SQL queries • Experience designing and completing Power BI reports or similar dashboard projects • Demonstrated skillful data cleaning and validation • Proficiency with Power BI, SQL, and Python • Demonstrated focus on automation and version control • Strong communication skills, with the ability to present technical insights clearly to stakeholders • Experience in cross-functional collaboration with the ability to build trust and credibility • Strong planning, documentation, and process-tracking skills • Energy utility domain knowledge preferred but not required • Microsoft Certified Data Analyst Associate Certificate or similar preferred • Experience with AWS preferred Benefits • Salary: $80,000-$100,000+ depending upon qualifications and experience. • Work from home (fully remote) • 2 weeks paid time off • Home equipment allowance (monitors, stand-up desk, etc.) • Annual education allowance • 401(k) with company matching • Medical, Dental, Vision, and Life insurance