Data Analyst

Copper State Bolt & Nut Co. is a family- and women-owned supplier of fasteners, construction products, industrial supplies, and safety items. The Data Analyst supports data integration, business intelligence, reporting, and automation initiatives by developing and maintaining data solutions, integrating systems, validating data, automating processes, and creating reporting solutions.

What you'll do:

• Assist in the development, maintenance, and support of data integration solutions between internal systems, cloud services, and third-party applications
• Develop and maintain REST API and webhook integrations
• Create and maintain Python scripts for data ingestion, transformation, validation, automation, and file processing
• Develop and maintain Power Automate workflows to automate business processes
• Develop and support Microsoft Power Apps that improve operational efficiency and streamline business processes
• Write, test, optimize, and troubleshoot SQL queries
• Analyze, validate, reconcile, and troubleshoot data from multiple source systems
• Develop, publish, troubleshoot and maintain Power BI semantic models, datasets, dashboards, and reports
• Develop DAX calculations
• Perform testing and validation of integrations, applications, reports, and data pipelines to ensure accuracy, completeness, and reliability
• Monitor automated processes, scheduled jobs, API integrations, and report refreshes, investigating and resolving failures as needed
• Work with structured and semi-structured data including SQL tables, JSON, CSV, XML, and Excel files

What they're looking for:

• Associate's or Bachelor's degree in Computer Science, Information Systems, Data Analytics, Business Information Systems, or a related field, or equivalent work experience
• Experience writing SQL queries
• Strong analytical and problem-solving skills
• Excellent verbal and written communication skills
• Ability to learn new technologies and business processes quickly
• Strong organizational skills and attention to detail
• Experience with Microsoft Power BI
• Experience with Python
• Experience working with REST APIs and JSON
• Experience with Microsoft Power Automate
• Experience with Microsoft Power Apps
• Experience with Microsoft Fabric or Azure data services