Data Analyst II

US Tech Solutions, Inc.

Charlotte, NC, United States

8 days ago

Apply on www.juju.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Compensation

$114,400.0 - $124,800.0

Working hours

Regular working hours

Job source

www.juju.com

Tech stack

Microsoft Excel Agile Methodology Data Warehousing Database Design Dimensional Modeling Python (Programming Language) Lookup Table Microsoft SQL Server Oracle (Applications) Pivot Tables Power BI Microsoft SharePoint

+8 more

SQL Stored Procedures SQL Databases SQL Server Reporting Services SQL Server Analysis Services Data Streaming Microsoft Power Automate Information Technology Powerapps

Job description

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

Requirements

Ability to communicate well with peers and internal customers
Ability to work with internal customers on the development of requirements
Demonstrated experience writing SQL against either Oracle or SQL Server databases
Demonstrated experience writing DAX or MDX code
Demonstrated experience developing/maintaining Power Automate
Demonstrated experience developing/maintaining Power Apps
Development of medium to complex solutions using Power BI Service, Power BI Paginated or SQL Server Reporting Services (SSRS)
Demonstrated experience querying Tabular or Multi-dimensional Models in Power BI or SQL Server Analysis Services (SSAS)
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 conclusions
Extensive knowledge of Data Warehousing fundamentals
Document warehouses to support cross training of co-workers
Uses technical understanding of existing reporting warehouses, or may develop local warehouses when necessary to support the development of solutions

Additional Preferred Qualifications:

Familiarity with Agile fundamentals
Experience with Python programming language
Experience with Power BI Data Flows
Experience working with metrics and performing analyses
Experience with advanced Excel features (pivot tables, vlookup, etc.)
Experience in database design, creating table and views, or writing stored procedures
Experience with Teams and SharePoint
Experience with creation and maintenance of tabular models and cubes in Power BI or SQL Server Analysis Services (SSAS)
Demonstrated problem solving skills