Data Analyst II

Strategic Staffing Solutions; Raleigh (NC); Hybrid; USD 65,000 - 90,000; Full time

Job summary

Strategic Staffing Solutions seeks a Data Analyst II in the Charlotte or Raleigh area on a hybrid, 2+ year contract. You will design, develop, and maintain reporting, dashboards, and data warehouse solutions to support decision making for Power Grid Operations.

You will collaborate with Finance, PMO, Lighting, and Resource Management teams, develop medium to complex SQL for Oracle/SQL Server, and leverage Power BI/SSRS/SSAS tools to automate processes.

Qualifications

• Design, development, and maintenance of reporting, dashboard, and data warehouse solutions (Power BI, SSAS models, SQL, Power Automate, SSRS) to support decision making.
• Experience in developing reporting warehouses or local warehouses to support solution delivery.
• Ability to aggregate data from various sources to automate business processes.

Responsibilities

• Work with internal customers on the development of reporting requirements.
• Develop medium to complex SQL against Oracle or SQL Server databases.
• Develop solutions to complex business problems in a systematic manner.
• Coordinate with IT and internal organizations to facilitate solution delivery.

Skills

Data analysis

SQL

Python

Power BI

SSAS

SSRS

Power Automate

Power Apps

Data warehousing fundamentals

Communication skills

Problem solving

Tools

Power BI

SSAS

SSRS

Power Automate

Power Apps

Oracle

SQL Server

Job description

Data Analyst II

Location: Charlotte, NC OR Raleigh, NC (Hybrid)

Duration: 2+ Year Contract

Overview:

Individuals have primary responsibility for the design, development, and maintenance of reporting, dashboard, and data warehouse solutions (Power BI, SSAS models, SQL, Power Automate, SSRS, etc.) that support decision making within the Power Grid Operations organization.

Duties and Responsibilities

• Work with internal customers on the development of reporting requirements
• Uses technical understanding of existing reporting warehouses, or may develop local warehouses when necessary to support the development of solutions
• Aggregate data from various data sources to automate a manual business process
• Development of medium to complex solutions using Power BI or SQL Server Reporting Services (SSRS)
• Support creation and maintenance of tabular models and cubes in PowerPivot or SQL Server Analysis Services (SSAS)
• Develop medium to complex SQL against either Oracle or SQL Server databases
• Extensive knowledge of Data Warehousing fundamentals
• Experience in database design, creating table and views, or writing stored procedures
• Experience with Power Automate and/or Power Apps
• Experience with Python programming language
• Document warehouses to support cross training of co-workers
• Interface with internal organizations such as Finance, Project Management, Lighting, or Resource Management to facilitate solution delivery
• Coordinate with Information Technology on requests
• Develop solutions to complex business problems in a systematic manner
• Using Project Management fundamentals to help drive projects and initiatives to successful conclusion

Additional Preferred Qualifications

• Familiarity with Agile fundamentals
• Report development, metrics and analytics experience
• Experience with Primavera P6 Project Portfolio Management application
• Experience with BI tools such as Power BI
• Extensive knowledge of SQL (Oracle or SQL Server)
• Experience with advanced Excel features (pivot tables, vlookup, etc.)
• Experience with AI tools
• Knowledge of SQL Server Reporting Services (SSRS)
• Demonstrated experience with Tabular or Multi-dimensional Models in PowerPivot or SQL Server Analysis Services (SSAS)
• Experience with Teams and SharePoint
• Strong communication skills
• Demonstrated problem solving skills