What are the responsibilities and job description for the Data Analyst 2 position at Capital Project Intelligence?
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
Salary : $80,000 - $100,000