Data Analyst II

To Apply for this Job Click Here

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.

To Apply for this Job Click Here

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.