Power BI / Power Automate Specialist

HCLTech
Hartford County, CT

Job Title: Power BI / Power Automate Senior Specialist (USC Only)

📍 Location: Remote

🛂 Work Authorization: U.S. Citizens Only (ITAR Compliance Requirement)

Job Overview

We are seeking a Senior Architect with strong expertise in Power BI and Microsoft Power Platform (Power Automate) to lead data visualization, business intelligence, and automation initiatives. This role requires deep technical capability combined with strong business acumen to translate data into impactful insights.

Key Responsibilities

  • Design and develop executive-level dashboards and reports using Power BI
  • Lead end-to-end data modeling, transformation, and visualization strategy
  • Build scalable data models and create advanced DAX measures
  • Develop and optimize Power Automate workflows for process automation
  • Work with stakeholders to gather requirements and translate into BI solutions
  • Create data storytelling narratives to drive business decision-making
  • Ensure best practices in dashboard design, usability, and performance
  • Integrate data from multiple sources using SQL and Power Query

Required Skills

  • Strong expertise in:
  • Power BI (Desktop, Service, Report Builder)
  • Power Automate (Flow design, automation architecture)
  • Data Modeling & DAX
  • SQL (data extraction, transformation, performance tuning)
  • Deep understanding of:
  • Power Query, Power Pivot, and BI architecture
  • Data visualization best practices (charts, layouts, UX/UI)
  • KPI frameworks and business metrics
  • Strong communication skills for stakeholder engagement and presentations

Preferred Qualifications

  • Experience with end-to-end BI solution architecture
  • Exposure to other BI/analytics tools (Tableau, etc.)
  • Basic knowledge of data analytics / statistics
  • Strong data storytelling capability
  • Microsoft Certifications:
  • Power BI Certification (preferred)
  • Microsoft Power Platform App Maker Associate (plus)

Why Join Us

  • Opportunity to lead enterprise-scale BI & automation initiatives
  • Work with cross-functional teams to drive data-driven transformation
  • High visibility role impacting strategic decision-making

Compliance Note

Due to export control regulations, only U.S. Citizens are eligible to apply (ITAR requirement).



Pay and Benefits

Pay Range Minimum: $ 110000 per year

Pay Range Maximum: $ 145,000 per year


HCLTech is an equal opportunity employer, committed to providing equal employment opportunities to all applicants and employees regardless of race, religion, sex, color, age, national origin, pregnancy, sexual orientation, physical disability or genetic information, military or veteran status, or any other protected classification, in accordance with federal, state, and/or local law. Should any applicant have concerns about discrimination in the hiring process, they should provide a detailed report of those concerns to [email protected] for investigation.

A candidate’s pay within the range will depend on their skills, experience, education, and other factors permitted by law. This role may also be eligible for performance-based bonuses subject to company policies. In addition, this role is eligible for the following benefits subject to company policies: medical, dental, vision, pharmacy, life, accidental death & dismemberment, and disability insurance; employee assistance program; 401(k) retirement plan; 10 days of paid time off per year (some positions are eligible for need-based leave with no designated number of leave days per year); and 10 paid holidays per year

How You’ll Grow


At HCLTech, we offer continuous opportunities for you to find your spark and grow with us. We want you to be happy and satisfied with your role and to really learn what type of work sparks your brilliance the best. Throughout your time with us, we offer transparent communication with senior-level employees, learning and career development programs at every level, and opportunities to experiment in different roles or even pivot industries. We believe that you should be in control of your career with unlimited opportunities to find the role that fits you best.

// // //