Data Analyst II

Gravity IT Resources; Raleigh (NC); Hybrid; USD 85,000 - 110,000; Full time

Job summary

Gravity IT Resources is seeking a Data Analyst II to join an enterprise analytics team in Raleigh/Charlotte, hybrid with three days onsite. The role focuses on designing, developing, and maintaining reporting, dashboards, and data warehouse solutions to support critical business operations.

You will work with stakeholders and IT to automate manual processes, develop SQL queries, and build scalable BI solutions using Power BI, SSRS, SSAS, and related Microsoft technologies.

Qualifications

• Experience building enterprise BI reports and dashboards.
• Strong SQL development including complex queries and procedures.
• Solid understanding of data warehousing, ETL, and data modeling.
• Experience with Power Automate/Power Apps to streamline processes.
• Python experience for data analysis or automation.
• Excellent analytical, troubleshooting, documentation, and communication skills.

Responsibilities

• Partner with business users to gather reporting requirements and translate needs into technical solutions.
• Design, develop, and maintain dashboards, reports, and data warehouse solutions using Power BI, SSRS, SSAS, and related Microsoft technologies.
• Aggregate, transform, and analyze data from multiple enterprise systems to automate reporting and improve efficiency.
• Develop medium to complex SQL queries, stored procedures, tables, and views in Oracle and/or SQL Server.
• Design, maintain, and optimize tabular models and OLAP cubes using SSAS and PowerPivot.
• Support data warehouse architecture, documentation, and knowledge sharing for scalable reporting.
• Collaborate with IT and cross-functional teams to deliver data-driven solutions.
• Coordinate technical requests with enterprise technology teams while aligning with business objectives.
• Apply structured problem-solving and project management to reporting initiatives from requirements to implementation.

Skills

Requirements gathering

Analytical thinking

Data-driven decision making

Stakeholder communication

Tools

Power BI

SSRS

SSAS

Power Automate

Power Apps

Python

Oracle

SQL Server

Job description

Data Analyst II
Location: Raleigh, NC or Charlotte, NC (Hybrid – 3 days onsite)
Duration: 3-Year Contract

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.

Key Responsibilities

• 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.

Required Qualifications

• 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.

Preferred Qualifications

• 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.

Equal Employment Opportunity Statement

Gravity IT Resources is an Equal Opportunity Employer. We are committed to creating an inclusive environment for all employees and applicants. We do not discriminate on the basis of race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, age, disability, genetic information, veteran status, or any other legally protected characteristic. All employment decisions are based on qualifications, merit, and business needs.