Find Jobs
Find Jobs Near You – Available Work in Your Location
Senior Data Engineer RCMP
Job Description
Location:
2401 Mill Road, Alexandria, VA, 22314
WMATA Reference:
255 The Senior Data Engineer leads the development, analysis, and maintenance of telematics solutions for the Authority. This role develops and optimizes incoming data sources, models, and architecture to enable predictive/condition-based monitoring, transforming operational data into actionable insight to prevent unplanned downtime. This role builds reliable data systems that identify emerging failure patterns, quantify risk against defined thresholds, and support automated and/or technician-driven mitigations. This role supports reliability improvement through data-driven reliability centered maintenance strategies and continuous performance optimization.
Principal Job Duties Data Pipeline Development:
Develop, automate, and maintain data workflows (ETL
•extract, transform, load) from telematic systems using Microsoft Fabric Data Factory and Python.
•20%
Condition Monitoring Development:
Organize and deploy data management systems to monitor real-time and historical data from condition monitoring and telematic systems.
•15%
Dataflow Maintenance:
Diagnose and resolve data workflows issues and proactively address data performance challenges to minimize downtime and ensure data availability.
•12%
Business Intelligence Development:
Design and develop AI-assisted data transformations, semantic models, and Power BI reports to support operational decisions and identify early signs of component degradation or failure.
•10%
Database Management:
Build and maintain large-scale relational databases to facilitate ETL processes and ensure quality and integrity of the data.
•10%
Data Integration:
Lead efforts to integrate telematics data with enterprise computerized maintenance management systems for automated alerts and maintenance repair record creation.
•8%
Predictive Maintenance:
Develop and refine predictive maintenance strategies and thresholds.
•8% Asset Health /
Failure Analysis:
Analyze equipment health indicators (vibration, temperature, pressure, fault codes, etc.) to detect abnormal trends.
•7%
Collaboration:
Collaborate with reliability engineers, asset engineers, maintenance teams, and IT teams to ensure continuous integration and operations of condition monitoring processes.
•5%
Performance Reporting:
Develop and monitor key performance indicators (KPIs) related to asset health and condition monitoring program compliance.
•3%
Continuous Improvement:
Support continuous improvement initiatives to enhance equipment reliability and asset lifecycle performance.
•2% Other Duties Maintain documentation, reports, and dashboards for system health and performance. Evaluate telematics data against established thresholds, failure modes, and reliability models. Perform root cause analysis (RCA) on failures and near-misses. Recommend strategies and processes to enhance data reliability, efficiency, and quality. Train peers and end users on all tools developed for monitoring assets health and performance. Research and provide feedback to engineering teams on available condition monitoring technologies, predictive maintenance tools, and opportunities for incorporation on existing equipment. Maintains and promotes awareness and accountability with safety policies and procedures while performing job functions. Promotes a positive safety culture and encourages reporting of safety concerns consistent with our Agency Safety Plan, other regulatory requirements within the Safety Management System and just culture principles. The functions listed are not intended to limit specific duties and responsibilities of any particular position. Nor is it intended to limit in any way the right of managers and supervisors to assign, direct and control the work of employees under their supervision. Responsibilities Knowledge Knowledge of how telematic systems can be leveraged to improve reliability Knowledge and understanding of at least one programming language (i.e., SQL, Informatica, Python) Knowledge of using a Computerized Maintenance Management System (CMMS) to analyze, query and collect history of maintenance activities Skills Strong skills in manipulating large data sets using data analysis tools including Microsoft Excel, Tableau, or Power BI.
Communication:
Strong communication and influencing skills, including the ability to convey high level technical concepts with non-experts and business leaders
Presenting:
Skill in developing and presenting reports, findings, analysis, and recommendations to different audiences within the Authority.
Initiative:
Thinks creatively to make improvements to current business processes and initiates creative ways of improving internal customer service. Abilities Ability to translate business priorities into clear plans, delivery roadmaps, and measurable outcomes Ability to prioritize work and manage multiple responsibilities Ability to organize and summarize large data sets into key findings Ability to be available 24 hours 7 days a week. Machine, Tools, Equipment, Software, Hardware Required Maximo
•Computerized Maintenance Management System Oracle Databases SQL Developer Microsoft Office Suite (Excel, Access, Word, Power Point) Microsoft Visual Studios Data Visualization Software (MS Power BI, Cognos BI) Supervisory Responsibility Not responsible for supervising others. Qualifications Minimum Education Bachelor's degree in Computer Science, Reliability, Electrical, Mechanical, or related engineering field (i.e., Data Science). In lieu of a bachelor's degree, the following will be considered: a High School Diploma or GED and four (4) years of experience in an electrical, mechanical maintenance role or data analytics in addition to the experience stated below, will be considered. Minimum Experience Minimum of seven (7) years of progressive experience in engineering, reliability, maintenance, data science, data analytics, and/or related technical field. Minimum 2 years of experience with ETL (extract, transform, load) processes Preferred Qualifications Experience in a reliability engineer role Experience with ETL / data pipeline modernization Experience with Machine Learning Proficiency in either Python, R, SQL, or Dax ASQ-CRE or CMRP certification preferred Experience with mechanical/engineering systes About Us The Washington Metropolitan Area Transit Authority (WMATA), known as Metro, is the region's leading public transportation provider. Serving a 2,054-square-mile jurisdiction, Metro operates six rail lines, 98 stations, 126 bus routes, and Metro Access, a shared-ride paratransit service. As one of the nation's busiest transit systems, Metro connects communities, supports economic growth, and provides safe, reliable transportation.
Evaluation Criteria:
Consideration will be given to applicants whose resumes demonstrate the required education and experience. Applicants should include all relevant education and work experience. Evaluation criteria may include one or more of the following: Skills and/or behavioral assessment Personal interview Verification of education and experience (including certifications and licenses) Criminal background check (a criminal conviction is not an automatic bar to employment) Medical examination including a drug and alcohol screening (for safety-sensitive positions) Review of a current motor vehicle report
Closing:
WMATA is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other status protected by applicable federal law. This posting is an announcement of a vacant position under recruitment. It is not intended to replace the official job description. Job descriptions are available upon confirmation of an interview.
Apply Before:
10/11/2026, 9:00 p.m. To apply for this position, visit WMATA's Career Center Equal Employment Opportunity
Benefits
- Dental Insurance