Business Intelligence Analyst

SERC Reliability Corp seeks Business Intelligence Analyst in Charlotte, NC.

Duties:
Review and analyze nuanced data to identify trends and patterns in data and provide recommendations for improvement, optimization, or value opportunities. Collect, clean, and analyze data from various sources using statistical methods and tools such as SQL, Python, or Excel. Combine data from various sources and document data relationships (data modeling). Conduct ad-hoc data analysis to support business decisions and strategic planning.

Communicate data insights to leadership and other stakeholders via presentations or by maintaining reports, dashboards, and visualizations. Design digital maps using geospatial data and analyze spatial and non-spatial information. Develop, implement and follow policies, procedures, and process for the collection and analysis of data. Locate and define process improvement opportunities. Facilitate and coordinate data submittals through SERC and NERC systems.

Monitor and assist SERC entities with data entries into NERC's Availability and Analysis Data Systems for Transmission, Generation and Protection System Misoperations. Participate in a team of subject matter experts providing support and leadership in pursuance of the department and organization's goals.

Part-time Telecommuting permitted.

Background Check Required.

Requires Bachelor's or foreign equivalent degree in Information Management, Computer Science, Data Analytics, Economics, Statistics, Business Intelligence, Business Administration, or in a closely related field and 2 years of experience in the job offered or in an analyst-related occupation in a data-intensive environment.

• 2 years of experience with mathematical skills including statistics (descriptive and inferential), probability distributions, or linear algebra (matrices and vectors).
• 2 years of experience writing SQL queries for data extraction, transformation, validation, and analysis. Experience with SQL must include skills such as complex joins, subqueries, common table expressions, or query optimization techniques.
• 2 years of experience maintaining reports, dashboards, and visualizations using business intelligence tools such as Power BI, Tableau, or SAS.
• 2 years of experience performing data cleaning, data validation, and data quality review on large or disparate datasets using any combination of Excel, SQL, or Python.
• 2 years of experience applying analytical techniques, including descriptive, predictive, and prescriptive analysis, to identify trends, patterns, and anomalies in data.
• 1 year of experience using Python for data cleaning, analysis, automation, or reporting.
• 1 year of proficiency with data modeling and the ability to design, structure, and organize data, including combining data from multiple sources and documenting data relationships, using tools such as SQL or business intelligence platforms like Power BI.

40 hours/week. Must also have authority to work permanently in the U.S.