Data Analyst II

Capital Project Intelligence

Data Analyst II supporting AI-enabled analytics, reporting, automation, and applications for infrastructure and utility consulting projects. Building Power BI dashboards, analyzing data, and documenting technical workflows.

Posted 8/4/2026full-timeRemote • California • 🇺🇸 United StatesMid-LevelSenior💰 $70,000 - $110,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in data analysis, business intelligence, and automation, with proficiency in SQL, Power BI, and Python. Capable of translating business needs into actionable insights and technical solutions while ensuring data integrity and quality.

Highest-signal resume keywords

Data AnalysisPower BI Report DevelopmentSQL Query ExecutionPython AutomationAI-Enabled Tools Familiarity

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data ExtractionData CleansingData ValidationData TransformationETL ProcessesDashboard CreationData VisualizationTechnical ReportingAutomation WorkflowsAPI Integration

Soft Skills

Analytical ThinkingProblem-SolvingAttention to DetailCommunicationCollaboration

Tools & Technologies

Power BISQLPythonAWSAzureHTMLJavaScriptAngularJSJQueryAI-Assisted Applications

Certifications & Qualifications

Microsoft Certified Data Analyst AssociateAWS Cloud Practitioner

Industry Keywords

Business IntelligenceData AnalyticsAutomationEnergy Utility Domain KnowledgeGenerative AI Workflows

Tech Stack

Tools & technologies

AngularAWSAzureCloudETLJavaScriptjQueryPythonSQL

About the role

Key responsibilities & impact

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

What you’ll need

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

Comp & perks

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