Business Intelligence & Data Analyst

Responsibilities

• Establish and maintain a single source of truth by consolidating data from ERP, CRM, and manufacturing systems into clean, reliable, reportable datasets.
• Build insightful dashboards, reports, and KPI tools using Power BI and advanced Excel for senior and executive leadership.
• Clean, validate, and structure data to ensure accuracy, consistency, and reliability across systems.
• Extract and query data from ERP, CRM, and internal databases using SQL (T-SQL / SSMS or similar).
• Translate business needs into structured data requirements and reporting outputs.
• Analyze data to identify trends, inefficiencies, and business opportunities.
• Partner with operations, engineering, sales, and leadership teams to support data-driven decision-making.
• Support automation of reporting and reduction of manual data processes.
• Lead exploration and adoption of AI tools to improve efficiency and insight generation.
• Act as internal liaison for outsourced IT support, including onboarding, access setup, and ticket coordination.

Qualifications

• Bachelor’s degree in data Analytics, Business Analytics, MIS, Computer Science, Engineering, or related field preferred.
• 4+ years of experience preferred in data analytics, business intelligence, or related role.
• Strong ability to communicate data-driven story lines to technical and non-technical teams.
• Strong SQL skills (T-SQL, querying, joins, filtering datasets).
• Advanced Excel skills.
• Power Query (data extraction, transformation, ETL).
• Power Pivot (data modeling across multiple sources).
• Complex formulas and large dataset handling.
• Experience with Power BI or similar data visualization tools.
• Strong analytical and problem-solving skills with a curiosity-driven mindset.
• Comfortable working in a fast-paced, evolving, cross-functional environment.