Data Analyst II

About the role

The Data Analyst II plays a key role in supporting analytics, reporting, data workflows, automation, and AI-enabled application development. This role requires strong analytical thinking, hands-on experience with data tools, attention to detail, and the ability to translate business needs into clear reporting outputs, data-driven insights, and practical technical solutions. The ideal candidate is a curious, highly organized technical contributor who is comfortable working with SQL, Power BI, Python, documentation, and emerging AI tools while collaborating with senior analysts, technical leads, and stakeholders.

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

Performance Metrics

• Leads smaller-scope projects, tasks, or workstreams with appropriate guidance from senior analysts or technical leads
• Can explain insights, assumptions, risks, and technical findings to clients, stakeholders, or internal team members
• Produces clear documentation of data sources, report logic, process steps, validation checks, prompts, and technical decisions
• Demonstrates proactivity in identifying issues, asking clarifying questions, proposing solutions, and taking ownership of assigned work
• Delivers timely and accurate data analysis, reporting, automation, and application-support deliverables
• Creates dashboards, reports, visualizations, and technical outputs that are clear, accurate, useful, and easy for stakeholders to understand
• Supports AI-enabled tools, prototypes, and workflows through careful data preparation, testing, documentation, and implementation support
• Adheres to data integrity, security, validation, documentation, automation, and database best practices
• Collaborates effectively with senior analysts, technical leads, developers, stakeholders, and cross-functional team members
• Demonstrates growth toward broader ownership of analytics, reporting, automation, and AI-enabled solution delivery

Requirements

• 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

Preferred Qualifications

• Experience with APIs, Python-based automation, lightweight application development, or AI-enabled prototypes
• Experience with AWS, Azure, or other cloud platforms
• Experience with front-end or user-interface technologies such as HTML, JavaScript, AngularJS, jQuery, or similar technologies
• Experience with AI application concepts such as prompt workflows, retrieval-augmented generation, embeddings, structured outputs, agents, or evaluation workflows
• Energy utility domain knowledge
• Microsoft Certified Data Analyst Associate Certificate, AWS Cloud Practitioner Certificate, or similar certification

Benefits

• Salary: $70,000-$110,000+ depending upon qualifications and experience
• Fully remote work from home
• 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