Data Analyst 2 Job at Capital Project Intelligence, San Diego, CA

MU5SaVVnbjh5NlNvMzk4R28vN2ZPaFFGQWc9PQ==
  • Capital Project Intelligence
  • San Diego, CA

Job Description

 

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

Job Tags

Remote work, Flexible hours,

Similar Jobs

American Airlines

Analyst/Sr Analyst, AAdvantage Co-Brand Partnerships Job at American Airlines

 ...Intro Are you ready to explore a world of possibilities, both at work and during your time off? Join our American Airlines family, and youll travel the world, grow your expertise and become the best version of you. As you embark on a new journey, youll tackle challenges... 

Butler's Bus Service Inc.

School Van Monitor Job at Butler's Bus Service Inc.

 ...Van Pool Transportation LLCThe Bus Aide will help students board the bus, depart from the bus, and arrive safely at their destination...  ...one of the Great Places to Work in 2023-2024! Being a School Van Monitor for Van Pool Transportation gives you the pay you deserve... 

Valstro

Junior DevEx Engineer Job at Valstro

 ...We are seeking a Junior Engineer with a strong interest in improving the way engineers build, test,deployandmaintainsoftware. You...  ...Experience withGitand version control workflows~ Interest inDevOps,CI/CDand platform engineering ~ A real desire tolearn,... 

NASSCO

Sheet Metal Mechanic J4 Job at NASSCO

 ...Responsibilities for this Position Sheet Metal Mechanic J4 Location: Norfolk, VA, US, 23523 National Steel and Shipbuilding Com...  ...be able to read and interpret mechanical drawings, layout, fabricate, install, and repair sheet metal products related to shipboard... 

AXA Group

Talent Management Program Lead, Americas Job at AXA Group

 ...independently own and drive key programs. What we OFFER Inclusion AXA XL is committed to equal employment opportunity and will...  ..., age, ethnicity and origins, marital status, religion, disability, or any other protected characteristic. At AXA XL, we know that...