14d 3h ago
Data Analyst
Data Analyst / BI Analyst
🏢Hybrid
|Charlotte, United States of Americapower_bipythonsqlssrs
Data Analyst
Data Analyst / BI Analyst
Hybrid
Contract
United States of America, Charlotte, Raleigh
Position:
Data Analyst II
Company:
Not Specified
Location:
United States, Charlotte, NC OR Raleigh, NC (Hybrid)
Employment type:
Contract
Short Summary:
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.
Responsibilities:
- Work with internal customers on the development of reporting requirements
- Use technical understanding of existing reporting warehouses, or develop local warehouses when necessary
- Aggregate data from various data sources to automate a manual business process
- Develop 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
- Document warehouses to support cross training of co-workers
- Interface with internal organizations such as Finance, Project Management, Lighting, or Resource Management
- Coordinate with Information Technology on requests
- Develop solutions to complex business problems systematically
- Use Project Management fundamentals to help drive projects and initiatives to successful conclusion
Requirement:
- Extensive knowledge of Data Warehousing fundamentals
- Experience in database design, creating tables and views, or writing stored procedures
- Experience with Power Automate and/or Power Apps
- Experience with Python programming language
- 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
Data Analyst II
Company:
Not Specified
Location:
United States, Charlotte, NC OR Raleigh, NC (Hybrid)
Employment type:
Contract
Short Summary:
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.
Responsibilities:
- Work with internal customers on the development of reporting requirements
- Use technical understanding of existing reporting warehouses, or develop local warehouses when necessary
- Aggregate data from various data sources to automate a manual business process
- Develop 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
- Document warehouses to support cross training of co-workers
- Interface with internal organizations such as Finance, Project Management, Lighting, or Resource Management
- Coordinate with Information Technology on requests
- Develop solutions to complex business problems systematically
- Use Project Management fundamentals to help drive projects and initiatives to successful conclusion
Requirement:
- Extensive knowledge of Data Warehousing fundamentals
- Experience in database design, creating tables and views, or writing stored procedures
- Experience with Power Automate and/or Power Apps
- Experience with Python programming language
- 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
Required Skills
power_bipythonsqlssrs
Required Languages
🇬🇧 English
Key competency: Data Analyst / BI Analyst