Data Analyst

At City Electric Supply, we encourage our people to ask questions, create, discover, and learn.

If you're passionate about what you do and think you can contribute, we encourage you to apply even if you don't meet every requirement listed. Your unique experiences and perspectives could be exactly what we need to grow and innovate.

Let's build something great together!

About CES:

CES is a global electrical wholesaler, providing electrical products to people in the industry known for its extensive range of products and commitment to customer service. Founded in 1951 in the United Kingdom, it has since expanded to over 1,000 locations across multiple countries, including the United States, Canada, Australia, and Europe. 

We in IT are delivering value to our business and our customers with the innovative solutions that enable our business to better serve our customers today and in the future. We recognize that technology and data are at the forefront of this. 

Our Global IT team deliver a portfolio of transformative work, expand our digital options, upgrade and future-proof our systems to place us at the forefront of the marketplace. 

To do this, we need talented and creative people across all areas to join us in delivering our evolution to enable our forward-thinking business over the next few years and beyond, and this is where you come in... 

Summary:

We are seeking a skilled Data Analyst to support the Data Management team by creating internal reports and building team-level metrics dashboards. This role will focus on developing and maintaining reports that track productivity and data quality, while working closely with the data technicians to inform people about changes needed to prepare our data for use across the business. The ideal candidate will play a crucial role in ensuring that the data we manage is accurate, actionable, and aligned with standards. 

• Design and develop internal reports to monitor the performance of the data management team, focusing on productivity, data quality, and operational efficiency. Reports will be used to track team metrics, performance, and areas requiring attention.
• Build and maintain real-time metrics dashboards to visualize key performance indicators (KPIs) and other internal team metrics. Leverage BI tools to create dashboards that are easy to interpret and align with team goals.
• Work closely with data technicians to identify and inform them of any data quality issues or inconsistencies that need to be addressed. Provide clear and actionable insights to drive improvements in data quality and structure.
• Write and optimize SQL queries to extract the necessary data for reports and dashboards. Ensure data accuracy and consistency in all reporting outputs.
• Automate report generation and dashboard updates to minimize manual effort and enhance the efficiency of internal reporting workflows.
• Assist in preparing the data for AI initiatives by identifying data quality gaps. Collaborate with data technicians to ensure that the data is clean, properly structured, and ready for use in AI models and predictive analytics.
• Regularly review data quality metrics and reports, ensuring the data being tracked and reported is accurate and complete. Provide feedback to data technicians to help guide data improvements.
• Maintain documentation related to reporting processes, SQL queries, and dashboard metrics to ensure consistency and transparency in data management practices.
• Continuously identify and recommend improvements to reporting processes, data collection methods, and the overall management of internal metrics to drive productivity and data quality. 

• 3+ years of experience in data reporting, analytics, and dashboard development.
• Experience with SQL, BI tools (Power BI, Tableau), and data reporting in a business or technical context.
• Experience with process automation and reporting efficiency tools.
• Familiarity with data governance practices and how they impact internal reporting.
• Familiarity with ETL (Extract, Transform, Load) tools (e.g., Talend, Alteryx) to support data pipelines (preferred).
• Experience with cloud-based data storage or analytics platforms (e.g., AWS) (preferred).
• Knowledge of integrating data from multiple systems (e.g., ERP, CRM) into a unified reporting structure (preferred).

• Advanced proficiency in SQL for querying and extracting data from relational databases, including writing complex queries for reporting and analysis.
• Experience with BI tools (e.g., Power BI, Tableau) for creating reports and dashboards to track team performance and metrics.
• Understanding of data profiling techniques and the ability to recognize and communicate data quality issues to technicians.
• Proven ability to build and maintain dashboards to track KPIs and performance metrics for internal teams.
• Strong analytical skills in designing reports that track team performance, operational efficiency, and support data-driven decisions.
• Experience automating report generation and dashboard updates using BI tools' automation features or scripting.
• Strong interpersonal and communication skills to work with data technicians and other team members to ensure data accuracy and process improvements.
• Understanding of AI data readiness and the ability to collaborate with technical teams.
• Ensuring data accuracy in reports and dashboards, identifying discrepancies, and resolving them with the team.

• Medical, Dental, Vision Insurance.
• 401(k) company match program.
• Telehealth.
• Short-term and Long-term disability insurance.
• Basic and AD&D Life Insurance paid for by the company.
• Critical Illness, Hospital Confinement, Accident Insurance, Supplemental Life Insurance.
• Employee Assistance Program.
• Mental, physical, financial wellness.
• Auto and Home Insurance discount.
• Paid Time Off and 7 paid Holidays.
• Paid Pregnancy, Parental, and Adoption Leave programs.
• Employee Discount Program.
• Training Programs.
• Internal growth opportunities in a fast-growing company.
• In some jurisdictions, state or local laws address sick leave or other leaves of absence. The Company complies with all such laws. This policy shall apply only to the extent it does not conflict with applicable law.

EEO Statement 

City Electric Supply (CES) provides equal employment opportunities (EEO) to all employees and candidates for employment without regard to race, color, religion, sex, national origin, age, disability, genetics, veteran status, or other protected class status.  In addition to the federal law requirements, CES complies with applicable state and local laws governing nondiscrimination in employment.  CES also makes reasonable accommodations to qualified individuals with disabilities, in accordance with the ADA.  This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfers, leaves of absence, compensation, and training. 

Attention Applicants: If you have a disability and need a reasonable accommodation to complete any part of the application process, or if you have difficulty accessing or using the online application process and need an alternative method, please contact us at HRServices@cityelectricsupply.com or 1-855-571-2477.

City Electric Supply is a drug free workplace. 

For further information about CES, visit our website at www.cityelectricsupply.com.