Data Analyst II

Summary

Capital Project Intelligence is a full-service consultancy and professional services firm specializing in large capital projects. The Data Analyst II plays a key role in supporting analytics, reporting, data workflows, automation, and AI-enabled application development.

Responsibilities

• 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 the development of AI-enabled tools, prototypes, automations, and data applications by preparing data, documenting requirements, testing outputs, and assisting with implementation
• Understand business needs and translate them into clear reporting, analytics, automation, or application support tasks
• Communicate results, insights, assumptions, risks, and limitations clearly and concisely
• Ensure timely completion of assigned tasks, deliverables, documentation, and follow-ups
• Visualize data in an easily consumable way for business stakeholders using Power BI, advanced reporting tools, dashboards, and other data visualization methods
• Execute ETL processes to assess datasets, identify nulls or errors, clean and transform data, and load data to appropriate platforms or reporting tools
• Perform data analysis and compile clear technical reports, summaries, findings, and documentation
• Assist with Python scripts, automation workflows, data preparation processes, and reusable technical components as needed
• Support API-based, AI-assisted, or application-related workflows under the guidance of senior technical team members
• Document data flows, report logic, process steps, assumptions, validation checks, prompts, and technical decisions
• Collaborate effectively within and across teams, providing actionable insights and technical support to guide decisions
• Identify opportunities for process improvement and contribute to continuous enhancement of analytics, reporting, automation, and AI-enabled delivery practices
• Support data integrity, security, quality, and documentation expectations throughout analytics and application development work

Skills

• Bachelor's degree in Business, Computer Science, Engineering, Data Analytics, Information Systems, Marketing, or related field, or equivalent experience; master's degree a plus
• 3+ years of experience in data analysis, business intelligence, analytics, information systems, automation, or a 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 for data analysis, reporting, automation, and data preparation
• Demonstrated skill in data cleaning, validation, transformation, and quality review
• Interest in and 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 sources such as databases, spreadsheets, files, APIs, or business systems
• Demonstrated focus on documentation, version control, automation, and repeatable processes
• Strong communication skills, with the ability to explain technical information, data findings, limitations, and recommendations clearly to stakeholders
• Experience collaborating across teams with the ability to build trust, ask good questions, and follow 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 front-end or user-interface technologies such as HTML, JavaScript, AngularJS, jQuery, or similar technologies preferred
• Experience with AI application concepts such as 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 Certificate, AWS Cloud Practitioner Certificate, or similar certification preferred

Qualifications

Must Haves

• Bachelor's degree in Business, Computer Science, Engineering, Data Analytics, Information Systems, Marketing, or related field, or equivalent experience; master's degree a plus
• 3+ years of experience in data analysis, business intelligence, analytics, information systems, automation, or a 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 for data analysis, reporting, automation, and data preparation
• Demonstrated skill in data cleaning, validation, transformation, and quality review
• Interest in and 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 sources such as databases, spreadsheets, files, APIs, or business systems
• Demonstrated focus on documentation, version control, automation, and repeatable processes
• Strong communication skills, with the ability to explain technical information, data findings, limitations, and recommendations clearly to stakeholders
• Experience collaborating across teams with the ability to build trust, ask good questions, and follow 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

Nice to Haves

• 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 front-end or user-interface technologies such as HTML, JavaScript, AngularJS, jQuery, or similar technologies preferred
• Experience with AI application concepts such as 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 Certificate, AWS Cloud Practitioner Certificate, 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