> Markdown version of [/jobs/ext/1935592-data-analyst-ii](https://www.wearedevelopers.com/jobs/ext/1935592-data-analyst-ii). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Analyst II - **Company:** Gravity Hair Salon, LLC - **Location:** Raleigh, NC, United States - **Salary:** $100,000.0 - $125,000.0 - **Contract:** Temporary contract - **Skills:** 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), 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 - **Published:** August 5, 2026 - **Apply:** https://www.gravityitresources.com/job/9601 ## About the Role * 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. ## 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. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) - [From Global Capability Centers to AI-Powered Command Centers](https://www.wearedevelopers.com/videos/100096-from-global-capability-centers-to-ai-powered-command-centers) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Dev Digest 120 - Apple and peers](https://www.wearedevelopers.com/magazine/455-dev-digest-120-apple-and-peers) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany)