Data Analyst II

Gravity Hair Salon, LLC

Raleigh, NC, United States

6 days ago

Role details

Contract type

Temporary contract

Employment type

Full-time (> 32 hours)

Compensation

$100,000.0 - $125,000.0

Working hours

Regular working hours

Job source

www.gravityitresources.com

Tech stack

Microsoft Excel Agile Methodology Artificial Intelligence Data Analysis Extract Transform Load (ETL) Data Warehousing Relational Databases Database Queries Database Schema Excel Formulas Microsoft SQL Server Oracle (Applications)

+11 more

Performance Tuning Pivot Tables Primavera Power BI Microsoft SharePoint SQL Stored Procedures SQL Databases SQL Server Reporting Services SQL Server Analysis Services Microsoft Power Automate Powerapps

Job description

We are seeking a Data Analyst II to join an enterprise analytics team responsible for designing, developing, and maintaining reporting, dashboard, and data warehouse solutions that support critical business operations and decision-making. This role works closely with business stakeholders and technical teams to gather requirements, automate manual processes, and deliver scalable reporting and business intelligence solutions., * Partner with business users to gather reporting requirements and translate business needs into technical solutions.

Design, develop, and maintain dashboards, reports, and data warehouse solutions using Power BI, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Power Automate, and related Microsoft technologies.
Aggregate, transform, and analyze data from multiple enterprise systems to automate manual reporting processes and improve operational efficiency.
Develop medium to complex SQL queries, stored procedures, tables, and views using Oracle and/or SQL Server databases.
Design, maintain, and optimize tabular models and multidimensional cubes using PowerPivot and SQL Server Analysis Services (SSAS).
Support data warehouse architecture, documentation, and knowledge sharing to ensure maintainable and scalable reporting solutions.
Collaborate with IT and cross-functional teams including Finance, Project Management, Resource Management, and other business units to deliver data-driven solutions.
Coordinate technical requests with enterprise technology teams while ensuring reporting solutions align with business objectives.
Apply structured problem-solving and project management principles to deliver complex reporting initiatives from requirements through implementation.

Requirements

Experience developing enterprise reporting and business intelligence solutions using Power BI, SSRS, SSAS, and SQL.
Strong SQL development experience, including complex queries, stored procedures, database objects, and performance optimization in Oracle and/or SQL Server.
Solid understanding of data warehousing concepts, relational database design, ETL principles, and data modeling.
Experience using Power Automate and/or Power Apps to streamline business processes.
Experience with Python for data analysis, automation, or reporting.
Strong analytical, troubleshooting, documentation, and communication skills with the ability to work directly with business stakeholders., * Experience working in Agile development environments.
Experience developing enterprise dashboards, KPIs, metrics, and business analytics solutions.
Knowledge of Primavera P6 Project Portfolio Management.
Advanced Microsoft Excel skills, including Pivot Tables, advanced formulas, lookups, and data analysis.
Experience with Microsoft Teams and SharePoint.
Familiarity with AI tools and their application in reporting, analytics, or process automation.
Proven ability to solve complex business problems through scalable reporting and data-driven solutions.