PowerBI Data Analyst

Meridian Technologies, Inc.
Raleigh / durham / CH, NC
13 Oct 2024

Vacancy expired!

Individuals have primary responsibility for the design, development, and maintenance of reporting, dashboard, and data warehouse solutions (Power BI, SSAS models, SSRS, SQL, etc.) that support decision making within the Customer Delivery (Distribution) 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
  • 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 conclusions
  • Additional Preferred Qualifications
  • Familiarity with Agile fundamentals
  • Report development, metrics and analytics experience
  • Experience with BI tools such as Power BI
  • Extensive knowledge of SQL (Oracle or SQL Server)
  • Extensive knowledge of Data Warehousing fundamentals
  • Experience with advanced Excel features (pivot tables, vlookup, etc.)
  • Knowledge of SQL Server Reporting Services (SSRS)
  • Demonstrated experience with Tabular or Multi-dimensional Models in PowerPivot or SQL Server Analysis Services (SSAS)
  • Understanding of Power Automate and/or Power Apps
  • Experience with Teams and SharePoint
  • Strong communication skills
  • Demonstrated problem solving skills
Assesses complex data systems and programs in support of ad-hoc and standing management or customer requests. Creates programs, methodologies, and files for analyzing and presenting data. Examines data quality, applications, and functions. Produces output and sustains operation. Researches new data sources and analytical tools. Contributes to new product development and improvement in product delivery and presentation. Develops awareness of and familiarity with issues and events affecting organization, department, and/or customer. Uses and supports database applications and analytical tools. Uses timely and appropriate participation of users/customers in data collection and query systems. 3-5 years of experience.