Data Analyst 2

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 San Diego, 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

Requirements

Skills and Qualifications:  

• Bachelor’s degree in Business, Computer Science, Engineering, Marketing, or related field, or equivalent experience; master’s degree a plus  
• 3+ years of experience in data analysis, business intelligence, or a related field  
• 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

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  

Benefits

• Salary: $80,000-$100,000+ depending upon qualifications and experience.
• Work from home (fully remote)
• 2-3 weeks flexible 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