Lead AWS BI Data Engineer

Role: Lead AWS BI Data Engineer

Location: Rochester, NY (2-3 Days Onsite every week)

Duration: Long Term

Important Note: Must be in Rochester area, probably going direct at some point (maybe 4/1/26),, hybrid 2-3 days onsite, office on westside of Rochester (Buffalo Rd)

Position Summary

The Data Engineer will be responsible for the design, development, implementation, and continuous improvement of Transcat s reporting platform and architecture. This position will be responsible for Business Intelligence (BI) and Data Analytics, providing high-value, timely data solutions to internal and external data stakeholders. Regular collaboration will occur with business, technology, and software development teams to ensure we exceed expectations for data, information, and reporting.

Essential Duties and Responsibilities

• Data Warehouse/Data Lake Architecture and Development

Data Modeling & Architecture

• Design and maintain the architecture in reporting platforms, including the QuickSight
• Synthesize many disparate data sources into one centralized data platform
• Lead efforts to design, develop and implement database enhancement to improve efficiency and streamline the use for analytics, business analysis
• Scope out and develop data enhancement plans for company initiatives
• Implement and enforce data validation procedures.
• Make suggestions for improvements to the data team and team processes
• Produce complete and accurate reports to business entities and users.
• Other duties as assigned

Required Knowledge, Skills, and Abilities

• Expert level in AWS data tools (QuickSight)
• Expert level user of Microsoft SQL Server tools and SQL
• Expert level working knowledge of The Python language
• Experience validating databases for accuracy
• Experience working with API architectures.
• Experience working with ETL/ELT Pipelines
• Knowledge of how data entities and elements should be structured to assure accuracy, performance, understanding, operational, analytical, reporting, and data science efficiencies
• Applied knowledge of cloud computing and RPA programming/machine learning
• Applied knowledge of data modeling principles (e.g., dimensional modeling and star schemas)
• Must be a self-directed professional with the ability to work effectively in a fast-paced demanding environment, handle multi-tasks, problem solve and effectively follow-through
• Work collaboratively with internal partners/departments

Education and Experience

• Bachelor s degree required in Data Science, Software Engineering, Information Technology, or a related field
• Minimum 5 years hands experience. with AWS Data Tools

2+ years of experience as a technical lead on data and analytics projects

5+ years of experience architecting and maintaining enterprise data platforms

Thanks

John

NetStrive Consulting, LLC

450, E. 22^nd St, Suite 178,

Lombard, IL 60148

Direct:

Desk No: Ext-404

Fax:

Web:

Email:

Note: This email is not intended to be a solicitation. Please accept our apologies and reply in the subject heading with REMOVE to be removed from our mailing list.