Data Engineer

RTS - Regional Transit Service • Full-time • Rochester, NY, US • $80k - $90k / year • 4d ago

Job Overview

As a Data Engineer, you will be an integral member of the Business and Data Insights department, responsible for designing, building, and maintaining robust data infrastructure. You will work with a variety of data sources and systems, support the development of our enterprise data warehouse, and enable advanced analytics through scalable data solutions. Your work will directly support operational efficiency, performance monitoring, and strategic initiatives across the organization.

This is a hybrid position working out of Rochester, NY. Please note, RTS does not cover any relocation expenses.

REPORTS TO: Director of Business & Data Insights

COMPENSATION:$80,000-$90,000 annually (depending on experience)

Benefits Include

Staying Healthy: Medical, Dental,and Vision (Dental & Vision currently free), Flexible Spending Account (FSA)
Feeling Secure: Disability Insurance, Pension Plan, NY State Deferred Compensation Plan, Life & Accidental Death & Dismemberment (AD&D) Insurance, Accident Insurance, Group Specified Disease Insurance and Hospital Insurance
Work-Life Balance: Paid Time Off (PTO:3 weeks + 2 days grantedupon hire; accrue additional time after 1 year), Employee Assistance Program, Paid Holidays, Verizon Wireless Discount, On-site Fitness Center open 24/7, Employee Wellness Program, Culture & Inclusion Council, BJ's Wholesale Club Discount, and more!

Click here to view current medical plan rates!

Key Responsibilities

Leverage data to develop solutions that address complex business challenges.
Design, develop, and maintain scalable data pipelines and architecture to support enterprise analytics and reporting needs.
Interface with various databases and data sources, understand schema and data flows, and ensure efficient data integration.
Lead the development, maintenance, and enhancement of the enterprise data warehouse (EDW).
Collaborate with cross-functional teams to establish data validation processes that ensure data is accurate, consistent, and reliable across all sources.
Execute complex ETL tasks involving extraction, transformation, and loading of data from multiple sources, supporting both batch and incremental methods.
Design and build datasets to support data mining and advanced analytical initiatives.
Responsible for the deployment and automation of data processes and data mining algorithms.
Ability to stay current with emerging technologies, conduct evaluations, and recommend tools or platforms that align with organizational goals.
Ensure data practices align with company policies and comply with relevant data protection regulations, promoting security and privacy best practices.
Develop and maintain comprehensive documentation for data products, architectures, and data flows.
Other duties as assigned.

Education And Experience

Bachelor's degree in computer science, Information Systems, Engineering, or a related field (Master's degree preferred).
Minimum of 2 years of experience in data engineering, with a proven track record in building data architectures, ETL pipelines, and working with data warehouses.

Knowledge, Skills And Abilities

Strong analytical and problem-solving skills, effective communication skills, and the ability to work collaboratively in a team-oriented environment.
Proficiency in SQL, Python and PowerBI
Hands-on experience with relational databases like MS SQL Server, cloud platforms (e.g., AWS, Azure).
Experience with dimensional modeling and Kimball's methodology for building enterprise data warehouses is a plus.
Familiarity with data warehousing solutions like Snowflake, Redshift, or Big Query is a plus.
Experience with data pipeline tools such as SSIS or similar ETL frameworks.
Familiarity with data governance, data quality, and data cataloging practices.
Strong knowledge of data modeling and data architecture best practices.
Transit industry experience is a plus.

Physical Demands & Work Environment

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is regularly required to sit while using hands to finger, handle, or feel objects, tools, or controls. The employee frequently is required to walk, talk, hear, see, and use a computer. Specific vision abilities required by this job include close vision, peripheral vision, depth perception, and the ability to adjust focus. The employee is occasionally required to stand, reach with hands and arms, and stoop, kneel, crouch, or crawl.

The employee must regularly lift and/or move up to 20 pounds. The noise level in the work environment is usually moderate. The employee may occasionally be required to travel commercially.

This position is eligible to participate in a hybrid work model. Hybrid work is a flexible working model where employees work partly in the office and partly remote from an approved location. All employees must adhere to the Company Telecommuting Policy & Agreement if they choose to participate in the hybrid work model.

Please note that RTSdoes not provide sponsorship for employment visas at this time; candidates must be authorized to work in the United States without sponsorship.

Additional Information

Rochester Genesee Regional Transportation Authority (RGRTA) is committed to equal opportunity for all, without regard to race, religion, color, national origin, citizenship and/or immigration status, sex, sexual orientation, gender identity, pregnancy, age, veteran status, disability, genetic information, or any other protected characteristic under applicable federal or state law. RGRTAwill make reasonable accommodations for known physical or mental limitations of otherwise qualified employees and applicants with disabilities unless the accommodation would impose an undue hardship on the operation of our business.