Connor Johnston
Brooklyn,NY
Summary
Results-driven Software Engineer with expertise in data engineering, ETL processes, and business intelligence. Proven success delivering Power BI dashboards and Power Automate workflows to support operational efficiency in enterprise environments.
Overview
6
6
years of professional experience
Work History
Power BI & Automation Engineer
The TJX Companies, Inc.
01.2023 - Current
- Develop and maintain Power BI reports for major incidents, service requests, and SLA breaches to support data-driven operational decisions for End User Services Operations
- Create and manage Power Automate flows to automate communications, validate data, and enforce governance, significantly reducing manual effort
- Completed IT Yellow Belt training in Continuous Improvement; applied Plan-Do-Check-Act model to improve access request handling workflows
- Trained in Agile methodologies and software development as part of a 6-month Engineering Cohort
- Collaborated on a capstone team project to build a mock online store database using Microsoft SQL Server for managing orders and customer data
Data Engineer Co-op
Putnam Investments
01.2020 - 01.2023
- Designed and maintained 10+ ETL pipelines to support Tableau visualizations and deliver insights on finance-related data
- Built backend processes using Python and Oracle SQL to support market data dashboards
- Worked on a Scrum team and used Agile practices to manage tasks and deliverables
- Tools used: Python, SQL, Pandas, Git, Alteryx
Software Development Intern
Analog Devices
06.2019 - 12.2019
- Created a Python-based application with GUI to visualize TLP testing data and automate graph generation
- Built scripts for file conversion and Excel task automation to streamline internal data preparation
- Developed reports using QlikView to support data analysis and tracking of customer-reported issues across product lines
- Python tools and automations scripts were used weekly by 5+ team members in the ESD (Electrostatic Discharge) group to support test result visualization and technical documentation
Education
Bachelor of Science - Computer Science
University of Massachusetts, Lowell
Lowell, MA05-2022
Skills
- Data Modeling
- ETL Development
- SQL (Querying, Joins, CTEs)
- Business Intelligence (Power BI, reporting)
- Data Integration
- Python (Scripting, automation, data processing)
Timeline
Power BI & Automation Engineer
The TJX Companies, Inc.
01.2023 - Current
Data Engineer Co-op
Putnam Investments
01.2020 - 01.2023
Software Development Intern
Analog Devices
06.2019 - 12.2019
Bachelor of Science - Computer Science
University of Massachusetts, Lowell
Similar Profiles
Suzanne TurcotteSuzanne Turcotte
Financial Analyst at The TJX Companies, Inc.Financial Analyst at The TJX Companies, Inc.
Noah KidanemariamNoah Kidanemariam
Merchandise Associate at The TJX Companies, Inc.Merchandise Associate at The TJX Companies, Inc.
Daria BykovaDaria Bykova
Associate Consultant at The TJX Companies, Inc.Associate Consultant at The TJX Companies, Inc.
Cara VogelCara Vogel
Adult Literacy Tutor at New Lots Public Library Literacy ZoneAdult Literacy Tutor at New Lots Public Library Literacy Zone
Jesus MarshallJesus Marshall
Information Technology Director at Brooklyn Borough HallInformation Technology Director at Brooklyn Borough Hall