Job description

Overview Data Analyst 2 job at Capital Project Intelligence. San Diego, CA. 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. 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 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 #J-18808-Ljbffr Itlearn360

Requirements