Data Analyst II

🕒 August 4

🏄 California – Remote

🏄 California – Remote

💵 $70k - $110k / year

⏰ Full Time

🟡 Mid-level

🟠 Senior

📉 Data Analyst

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Capital Project Intelligence

WebsiteLinkedInAll Job Openings

51 - 200 employees

Founded 2020

💼 Consulting

⚡ Energy

🤖 Artificial Intelligence

Consulting • Energy • Artificial Intelligence

Capital Project Intelligence is a B2B engineering and data consultancy focused on utility and infrastructure clients. The firm delivers AI-enabled electrical engineering, automation, data engineering, QA/QC, knowledge management, information system design, document controls, and PMO services to lower costs, reduce risk, and accelerate project delivery. They combine industry experience, automation, and change-management best practices to ensure organizational buy-in across the project lifecycle.

📋 Description

• Support day-to-day analytics operations, including data extraction, cleansing, validation, transformation, and report generation • Create dashboards, reports, and data visualizations with guidance from senior analysts or technical leads • Support development of AI-enabled tools, prototypes, automations, and data applications • Translate business needs into reporting, analytics, automation, or application support tasks • Communicate results, insights, assumptions, risks, and limitations clearly • Complete assigned tasks, deliverables, documentation, and follow-ups on time • Visualize data for business stakeholders using Power BI, reporting tools, dashboards, and other visualization methods • Execute ETL processes to assess, clean, transform, and load datasets • Perform data analysis and compile technical reports, summaries, findings, and documentation • Assist with Python scripts, automation workflows, data preparation, and reusable technical components • Support API-based, AI-assisted, and application-related workflows • Document data flows, report logic, process steps, assumptions, validation checks, prompts, and technical decisions • Collaborate across teams to provide actionable insights and technical support • Identify process improvement opportunities and contribute to analytics, reporting, automation, and AI-enabled delivery enhancements • Support data integrity, security, quality, and documentation throughout analytics and application development work

🎯 Requirements

• Bachelor's degree in Business, Computer Science, Engineering, Data Analytics, Information Systems, Marketing, or related field, or equivalent experience • 3+ years of experience in data analysis, business intelligence, analytics, information systems, automation, or related technical field • Ability to independently write and execute SQL queries across multiple tables • Experience designing, building, or maintaining Power BI reports, dashboards, data models, or similar reporting solutions • Proficiency with Power BI, SQL, and Python • Skill in data cleaning, validation, transformation, and quality review • Practical familiarity with AI-enabled tools, automation, generative AI workflows, prompt-based tools, or AI-assisted application development • Ability to work with structured and semi-structured data from databases, spreadsheets, files, APIs, or business systems • Focus on documentation, version control, automation, and repeatable processes • Ability to explain technical information, data findings, limitations, and recommendations clearly • Experience collaborating across teams and following through on assigned work • Strong planning, documentation, organization, and process-tracking skills • Strong analytical thinking, problem-solving ability, attention to detail, and continuous improvement mindset • Ability to take ownership of smaller-scope tasks or workstreams while seeking guidance appropriately • Experience with APIs, Python-based automation, lightweight application development, or AI-enabled prototypes preferred • Experience with AWS, Azure, or other cloud platforms preferred • Experience with HTML, JavaScript, AngularJS, jQuery, or similar front-end technologies preferred • Experience with prompt workflows, retrieval-augmented generation, embeddings, structured outputs, agents, or evaluation workflows preferred • Energy utility domain knowledge preferred but not required • Microsoft Certified Data Analyst Associate, AWS Cloud Practitioner, or similar certification preferred

🏖️ Benefits

• Work from home, fully remote • 2 weeks paid time off • Home equipment allowance, including monitors, stand-up desk, and related equipment • Annual education allowance • 401(k) with company matching • Medical, Dental, Vision, and Life insurance