Data Analyst

Job Description

Job Description

Performs data collection, analysis, validation, cleansing, and reporting. Designs, codes, tests, debugs, and documents ETL processes, SQL queries, and stored procedures. Extracts and analyzes data from various sources, including databases, manual files, and external websites. Responds to data inquiries from various groups within an organization. Creates and publishes regularly scheduled and ad hoc reports. Documents reporting requirements and processes and validates data components as required. Requires experience with relational databases and knowledge of query tools and/or statistical software. Strong analytical and organizational skills also essential. Must possess expert level knowledge of MS Excel.

1. Explain what the scope of the work/project is? Project Overview, deliverables (what is this person responsible for).

a. Create dashboards and scorecards for the Design and Planning organization. The role will support additional groups including the Control Center, Trouble Group, Contracting Group, and Operations. Responsibilities include building and enhancing dashboards in Power BI, pulling data from HANA, SAP, and Salesforce, and providing visibility into timelines, productivity, workloads, efficiencies, process adherence, and overall work flow. Some dashboards will be built from scratch while others require enhancements and modifications.

1. What are the top 3-5 skills and qualifications (technology/application/software, etc.) required?

a. Power BI

b. SAP

c. HANA

d. Salesforce data extraction and reporting

e. AI tools and analytics familiarity

f. SQL query experience

g. Experience building dashboards and data visualization solutions

2. What non-technical skills are necessary (i.e., such as communication, problem solving, team player)?

a. Strong communication skills

b. Ability to take direction and improve upon requirements

c. Strategic thinking

d. Problem solving

e. Ability to ask insightful questions

3. Ideal candidate background and how many years required?

a. The manager values aptitude over years of experience. No minimum years of experience are required. Experience building dashboards is preferred. Utility or construction industry experience is beneficial but not required.

4. Are there any specific companies/industries you like to see on a candidate's resume?

a. Utility industry or construction industry experience is preferred but not required.

5. Are there any certifications/education that the candidate must possess?

a. No specific certifications or education requirements.

6. Are there any preferred or "nice to have" skills?

a. Utility industry knowledge

b. Construction industry knowledge

c. Coding experience

d. AI tool experience

e. Ability to perform data validation and reasonability checks