Data Analyst

We are currently hiring a Business Analyst to support our team out of Nashville, TN. The Business Data Analytics & API Integration Analyst will support the development, integration, and optimization of enterprise reporting and analytics platforms across project, cost, schedule, and operational data sources. This role will focus on connecting business systems through APIs, developing Power BI dashboards, managing SQL-based data models, and leveraging AI technologies to improve reporting efficiency and business insights. This position is ideal for a technology-oriented professional with 2-5 years of experience in business intelligence, data analytics, system integrations, or enterprise reporting. **Essential Duties & Responsibilities:** Data Analytics & Reporting - Develop, maintain, and enhance Power BI dashboards and reports for executive, operational, and project teams. - Create data models, measures, and calculations using Power BI and DAX. - Analyze business data to identify trends, risks, opportunities, and performance indicators. - Support development of KPI frameworks and automated reporting solutions. - Validate data quality, consistency, and accuracy across multiple data sources. API & System Integration - Assist with the design, development, and maintenance of API integrations between enterprise platforms. - Connect data from systems such as ERP, PMIS, Smartsheet, SharePoint, and other business applications. - Support automation of data collection, transformation, and reporting processes. - Troubleshoot integration and data synchronization issues. - Maintain documentation for integrations, workflows, and data mappings. Database & Data Management - Develop and optimize SQL queries, stored procedures, and data extracts. - Support data warehouse and data pipeline initiatives. - Manage data imports, exports, and transformation processes. - Assist in implementing data governance and quality control standards. AI & Advanced Analytics - Utilize AI and machine learning tools to improve reporting efficiency and decision support. - Support implementation of Copilot, AI-powered analytics, and workflow automation solutions. - Research emerging AI technologies and recommend practical applications for business operations. - Develop AI-assisted reporting and data summarization solutions. Collaboration & Support - Work closely with Project Controls, Finance, Construction Technology, and Operations teams. - Gather business requirements and translate them into dashboard and reporting solutions. - Provide end-user support and training for analytics tools and reporting platforms. - Participate in continuous improvement initiatives across data and reporting processes. **Knowledge & Skills Required:** - Advanced proficiency in Power BI, including DAX, Power Query, and data modeling. - Strong knowledge of SQL and relational database concepts. - Experience connecting and transforming data from multiple sources. - Understanding of REST APIs, JSON, and API-based integrations. - Experience with Microsoft Power Platform components. - Strong analytical and problem-solving skills. - Ability to interpret complex business requirements and convert them into actionable reporting solutions. - Experience with data visualization best practices and dashboard design. - Strong communication and stakeholder engagement skills. - Ability to manage multiple priorities in a fast-paced environment. - Detail-oriented with a strong focus on data accuracy and quality. - Proficiency in Microsoft Excel. **Preferred Education and Experience:** - Bachelor's degree in Data Analytics, Information Systems, Computer Science, Engineering, Business Analytics, Mathematics, or a related field. - 2-5 years of experience in business intelligence, data analytics, reporting, or system integration. - Experience developing dashboards in Power BI. - Experience writing advanced SQL queries and managing large datasets. - Experience integrating business systems through APIs. - Familiarity with AI platforms, Microsoft Copilot, Claude, Azure AI or OpenAI - Experience with Python, Power Automate, or other automation tools. - Experience working with cloud platforms such as Microsoft Azure. - Experience with enterprise platforms such as Oracle, Aconex, Procore, Smartsheet, SharePoint, or similar systems. - Experience supporting large capital projects, construction programs, or enterprise business operations is a plus. The salary range for this full-time role is $82,700.00-$110,300.01 per year. Ranges are determined based on the position, geography, client and industry experience and level, and represent a good faith effort to provide a fair and equitable salary. This range reflects base salary only, and not the total compensation package. Cumming Group reserves the right to pay more or less than the posted range, depending on a candidate’s experience, skills, and qualifications, including client requirements. In addition to base salary, Cumming Group offers a comprehensive benefits package including: - Medical - Dental Insurance - Vision Insurance - 401(k) - 401(k) Matching - Paid Time Off - Paid Holidays - Short and long-term disability - Employee Assistance Program #LI-PJ1