Business Data Analyst

Select how often (in days) to receive an alert:

A career at Capital Electric is more than a job. You’re investing in a brighter, more sustainable future together and joining a team that makes a real difference for our customers. Capital Electric offers electrical products and services to contractors. If it helps bring electricity to an office, home, factory or other building – you can find it here. We operate in Maryland, Virginia, Pennsylvania, West Virginia, North Carolina, South Carolina and Georgia, and are part of the Sonepar group, the world’s #1 electrical distributor with over 45,000 associates around the globe.

Job Title: Business Data Analyst
Location: Upper Marlboro, MD (On-site)
Department: Finance Operations & Analytics
Reports To: Finance Operations & Analytics Manager

We are seeking a Business Data Analyst to join our Finance Operations & Analytics team in Upper Marlboro, MD. This role will focus on reporting automation, data visualization, and AI-driven insights to support data-informed decision-making in our finance and operations functions. The Business Analyst will develop and automate financial and operational reports, build interactive dashboards in Power BI and advanced Excel models, and leverage AI tools to uncover actionable insights.

The Business Analyst will support broader finance operations initiatives by providing analytical expertise and process improvements across the organization. The ideal candidate is a collaborative, detail-oriented professional with strong analytical capabilities, excellent communication skills, and a drive to continuously improve business processes through data and technology.

• Reporting Automation:
  Identify and implement opportunities to automate recurring financial and operational reporting processes, reducing manual work and improving efficiency. This includes developing scheduled automated workflows (e.g., using Power Query or scripting) for regular reports and ensuring data refreshes are timely and accurate.
• Data Visualization & Dashboard Development:
  Design, develop, and maintain interactive dashboards and data visualizations using Microsoft Power BI and Excel to track key performance indicators (KPIs), financial metrics, and operational trends. Ensure that reports and visuals effectively communicate insights and support management in understanding business performance.
• AI-Driven Insights & Advanced Analytics:
  Leverage AI and advanced analytics tools (such as machine learning models or predictive analytics software) to analyze large datasets and generate forward-looking insights (e.g., trend analysis, forecasts, anomaly detection) that inform strategic decisions in finance and operations. Stay current with emerging AI technologies and evaluate their potential to enhance reporting processes and business intelligence capabilities.
• Data Analysis & Insight Generation:
  Gather, analyze, and interpret financial and operational data from various sources to identify patterns, correlations, and opportunities for improvement. Provide actionable insights through data analysis and clearly communicate findings to stakeholders, translating complex data into business recommendations.
• Collaboration & Stakeholder Engagement:
  Work closely with cross-functional teams – including finance, operations, IT, and key stakeholders – to understand reporting needs, define business requirements, and ensure solutions meet those needs. This includes partnering with other Data Analysts on data collection, validation, and analysis efforts to support broad finance operations initiatives and organizational goals.
• Process Improvement:
  Analyze current finance operations processes (such as budgeting, forecasting, expense tracking, and financial reporting) to identify process inefficiencies or bottlenecks. Recommend and help implement improvements or automation (potentially utilizing AI tools or macros) to enhance the accuracy, speed, and efficiency of financial operations and reporting.
• Report Documentation & Supporting Materials:
  Develop and maintain clear documentation for all reporting processes, data definitions, and dashboard usage guidelines…