Data Analyst

HCL Technologies is seeking a Data Analyst in Farmington Hills, MI to support business operations through data analysis, reporting, and process automation. The role focuses on building Power BI dashboards, preparing trusted datasets with Power Query and SQL, and turning results into actionable insights for stakeholders.

Responsibilities

• Collaborate with business and client stakeholders to understand objectives, challenges, and opportunities.
• Gather, analyze, and interpret data from multiple sources to support decision-making.
• Design, develop, and maintain Power BI dashboards and reports for business performance and operational KPIs.
• Clean, transform, and integrate data from multiple sources using Power Query and SQL.
• Analyze productivity, quality, customer satisfaction (CSAT), SLA compliance, and workforce performance metrics to identify trends and improvement opportunities.
• Create scorecards, ranking models, eligibility calculations, and executive-level reports to inform business decisions.
• Develop and maintain Power Apps and Power Automate workflows to streamline operational processes and reduce manual effort.
• Maintain data accuracy through validation, troubleshooting, and continuous monitoring of reporting processes.
• Prepare presentations and reports for leadership with insights and recommendations based on analysis.

Requirements

• 2-3 years of experience in Data Analytics, Business Analytics, or a similar role.
• Strong presentation and data storytelling skills, including the ability to communicate insights to business and executive stakeholders.
• Strong SQL skills with experience working on large and complex datasets.
• Hands-on experience with Power BI, including dashboard development and data modelling.
• Advanced Excel skills, including Pivot Tables, Power Query, lookups, and data analysis functions.
• Proficiency in Microsoft 365 tools: SharePoint, Excel, Outlook, Teams, Word, PowerPoint, OneNote.
• High attention to detail to ensure accuracy and quality of deliverables.
• Strong analytical and problem-solving capabilities.
• Excellent verbal and written communication skills.

Technologies

• Power BI
• Power Query
• SQL
• Power Apps
• Power Automate
• Excel
• Microsoft 365
• SharePoint
• Outlook
• Teams
• Word
• PowerPoint
• OneNote
• Pivot Tables

Pay

Pay Range: USD 70,000 - 75,000 per year

Pay Range Minimum: $70,000 annually

Pay Range Maximum: $75,000 annually

Benefits

• 401(k)
• 401(k) 3% Match
• 401(k) matching
• AD&D insurance
• Dental insurance
• Disability insurance
• Flexible spending account
• Health insurance
• Health savings account
• Life insurance
• Paid holidays
• Paid time off
• Prescription drug insurance
• Vision insurance

Good To Have

• Microsoft Power BI Certification (PL-300) or equivalent Business Intelligence certification.
• Google Cloud Platform (GCP), AWS, or Azure cloud certification, or experience working with cloud-based data platforms, data warehouses, and modern analytics ecosystems.
• Demonstrated ability to identify opportunities for process improvement and drive data-led innovation initiatives.
• Experience working in a client-facing, consulting, or stakeholder-intensive environment.

Application Questions

• Do you have Strong SQL skills with experience working on large and complex datasets?
• Do you have Hands-on experience with Power BI, including dashboard development and data modelling?
• Do you have Advanced Excel skills, including Pivot Tables, Power Query, lookups, and data analysis functions?

Work Location and Schedule

• Location: Farmington Hills, MI (onsite)
• Ability to commute: Farmington Hills, MI 48331 (Required)
• Work location: In person