Business Data Analyst

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. Being “Powered by Difference” means we respect and value diverse perspectives. Within Capital Electric, we offer a supportive culture and great benefits, and as part of the larger Sonepar group, we can offer exciting opportunities to grow your career. Job Title: Business Data Analyst Location: Upper Marlboro, MD (On-site) Department: Finance Operations & Analytics Reports To: Finance Operations & Analytics Manager Job Summary 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. Key Responsibilities 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 to ensure knowledge transfer and continuity. Train team members and stakeholders on using new reports or analytical tools as needed. Compliance & Data Integrity: Ensure data accuracy, quality, and security in all reporting activities. Support data governance efforts by validating data against source systems and working with IT or data engineers to resolve data quality issues. Assist in internal or external audits by providing required data and documentation, ensuring that reports comply with company policies and financial controls. Continuous Learning: Continually monitor industry trends and best practices in financial analytics, business intelligence, and AI applications in finance. Proactively propose innovative solutions or tools (e.g., improved visualization techniques, new analytics platforms) that could benefit the Finance Operations & Analytics team and the organization’s decision-making capabilities. Required Qualifications Education & Experience: Bachelor’s degree or 4 years of Data Analytics experience. Technical Skills: Proficiency in Microsoft Power BI and Excel is required, with a proven ability to create complex spreadsheets, pivot tables, macros, and interactive dashboards. Familiarity with data analysis techniques (e.g., data modeling, trend analysis) and experience in building reports and visualizations for business or finance operations. Analytical Abilities: Strong quantitative and analytical skills, with experience interpreting large datasets to derive insights and support decision-making. Ability to perform data validation, detect anomalies or trends, and translate data into meaningful conclusions for business strategies. Communication Skills: Excellent written and verbal communication skills, including the ability to present findings and complex analysis in a clear, concise manner to both technical and non-technical stakeholders. Collaboration: Demonstrated ability to work effectively in a cross-functional team environment, collaborating with colleagues from finance, operations, IT, and other departments. A track record of building positive working relationships and influencing others to achieve project goals. Attention to Detail: Strong commitment to accuracy and detail in data handling, report generation, and documentation. Must be able to ensure data quality and consistency across all reports. Problem-Solving: Proven ability to approach challenges with a problem-solving mindset. Capable of identifying the root cause of business issues and recommending data-driven solutions or process improvements. Summary: $75,000 - $90,000 with bonus potential What We Offer You Paid time off Paid parental leave 401(k) retirement savings with company match Professional and personal development programs Opportunity to become a shareholder Employer-paid short- and long-term disability Employer-paid life insurance for spouse and dependents Robust wellness program Gym reimbursement Employee Assistance Program (EAP) We’re proud to be a military-friendly company, and our many employee resource groups (ERGs) help you make connections and feel supported. EEO is the Law Applicants and employees are protected under Federal law from discrimination. To learn more, Click here. Pay Transparency Non-Discrimination Provision Sonepar follows Executive Order 11246, including the Pay Transparency Nondiscrimination Provision. To learn more, Click here. Sonepar is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to their race, color, creed, religion, national origin, citizenship status, ancestry, sex, age, physical or mental disability unrelated to ability, marital status, family responsibilities, pregnancy, genetic information, sexual orientation, order of protection status, protected veteran or military status, or an unfavorable discharge from military service, or any other categories protected by federal, state or local law. Sonepar and our family of brands are committed to the full inclusion of all qualified individuals. In keeping with our commitment, we will take the steps to assure that people with disabilities are provided reasonable accommodations. Accordingly, if a reasonable accommodation is required to fully participate in the job application or interview process, to perform the essential functions of the position, and/or to receive all other benefits and privileges of employment, please call View phone number on click.appcast.io or email View email address on click.appcast.io . #J-18808-Ljbffr