Senior Data Analyst: Power BI & Automation

K&A Engineering; Hartford (CT); On-site; USD 118,000 - 125,000; Full time

Benefits offered by this job

Medical Insurance

401K with company match

Parental Leave

Paid Holidays

Flexible PTO

Tuition Reimbursement

EAP

Parking and Transit Reimbursement

Pet Insurance

Job summary

K&A Power Group in Hartford, Connecticut is seeking a Data Analyst III to join our team. You will have the opportunity to develop and maintain project reporting, transform data, and support analytics across engineering and procurement to improve performance. The role emphasizes Power BI dashboards, automated workflows with Power Automate, and collaboration with cross-functional teams. Strong communication and a deep understanding of data warehousing and related tools are essential.

Qualifications

• Bachelor's Degree in business-related fields.
• Ten (10) years of experience performing this specific job function with minimal managerial oversight/direction.
• 10 years of experience is required to be considered for this position
• Strong verbal and written communication skills
• Demonstrable quantitative and analytical skills
• Proficiency in MS Word, Excel, PowerPoint, and SharePoint.
• Demonstrate a high level of personal initiative and ability to interact with stakeholders positively and collaboratively.
• Proficiency in Power BI, Power Automate, and SQL.
• Familiarity with DAX, SSRS, SSIS, and data warehousing concepts.
• Fully functional and interactive Power BI dashboards.
• Automated reporting workflows.
• Data Integration and process improvement
• Documentation of data models, transformation logic, and process flows.
• Monthly performance reports and KPI summaries

Responsibilities

• Developing and maintaining project reporting to monitor performance, costs, trends, and schedules.
• Support data analytics, reporting automation, and performance monitoring initiatives to enhance project execution.
• Design and deploy Power BI dashboards and executive scorecards.
• Develop automated workflows using Microsoft Power Automate.
• Perform data extraction, transformation, and analysis from systems such as Maximo, Oracle Primavera, Workday, and Fieldglass.
• Creating and maintaining KPI reports for Engineering and Supplier performance.
• Supporting cross-functional teams including Engineering, Project Controls, Procurement, and other operational areas.
• Provide following deliverables: Fully functional and interactive Power BI dashboards; Automated reporting workflows; Data Integration and Process Improvement; Documentation of data models, transformation logic, and process flows.
• Monthly performance reports and KPI summaries

Skills

Power BI

Power Automate

SQL

DAX

SSRS

SSIS

Data warehousing

Analytical thinking

Education

Bachelor's degree in business-related fields

Tools

Power BI

Power Automate

SQL

Excel

Word

PowerPoint

SharePoint

Job description

K&A Power Group in Hartford, Connecticut is seeking a Data Analyst III to join our team. You will have the opportunity to develop and maintain project reporting, transform data, and support analytics across engineering and procurement to improve performance. The role emphasizes Power BI dashboards, automated workflows with Power Automate, and collaboration with cross-functional teams. Strong communication and a deep understanding of data warehousing and related tools are essential.