Staff Data Engineer

Staff Data Engineer at BNSF Railway

Be part of a team that values safety, inclusion, and excellence. BNSF Railway is one of the largest U.S. railroads, transporting the nation’s freight across 28 western states and 3 Canadian provinces. As a member of our team, you will play a role in supporting the movement of essential products and materials that help feed, clothe, supply, and power communities throughout America and the world.

BNSF | Tech is the technology division making BNSF the preeminent freight and mobility company in North America. We are innovating and transforming the future of freight rail. If you are passionate about making a difference and eager to advance your career in a dynamic and supportive environment, we want you on our team! Join us in reshaping the future of freight rail and discover a fulfilling career where your contributions matter.

We are committed to a culture where all employees are included, belong, and have equal opportunity to achieve their full potential. Come make a difference with us! This is a full-time remote position. Employees may work from anywhere within the contiguous 48 states of the United States. Travel is up to 20%, occasionally to our corporate headquarters in Fort Worth, TX for in-person meetings. Travel expenses for business needs will be covered by BNSF.

About the Role: Data & AI

Lead our charge into the future as an AI company by transforming our data assets into a real-time enterprise.

Key Responsibilities May Include

• Design and implement data streaming solutions to process real-time data efficiently.
• Develop and maintain robust data pipelines for both real-time and batch processing, including data extraction, transformation, and ETL processes to ensure seamless data flow across systems.
• Create and manage large-scale data warehouses to ensure efficient data access and retrieval in support of business intelligence and analytics needs.
• Develop certified datasets by integrating data from diverse data sources to ensure data accuracy, consistency, and reliability.
• Collaborate with data scientists, analysts, and other stakeholders to understand data requirements and deliver effective data solutions.
• Optimize data workflows, monitor data pipelines, and troubleshoot issues to ensure high-performance, reliable, and scalable data flows.
• Ensure data security and compliance with industry standards and regulations.
• Stay current with industry trends and advancements in data engineering, data science, and machine learning.
• Write efficient and well-documented code, ensuring unit tests documentation for all data solutions.
• Implement data engineering solutions into data platforms or production systems by leading the solution design, development, testing, and monitoring.

At BNSF Railway, we encourage individuals from all backgrounds to apply, showcasing their skills, experiences, and development. We provide resources and tools to help you reach your full potential, fostering a supportive and inclusive environment.

Basic Qualifications

• Minimum 6 years experience in software engineering, data engineering, database management, or relevant experience.
• Proficiency in programming languages such as Python, SQL, Java.
• Strong understanding of data warehousing concepts including dimensional modeling and star schema.
• Experience with ETL processes and tools, including cloud-based solutions.
• Familiarity with database management systems (e.g., SQL, NoSQL) and modern lakehouse technologies (e.g., Apache Iceberg, Delta Lake, Apache Trino).
• Experience with data streaming technologies (e.g., Apache Kafka, AWS Kinesis, Apache Flink, and Apache Spark).
• Experience in data engineering, with a focus on data streaming, data pipelines, data orchestration tools, datamart creation, and certified datasets.
• Experience in DevSecOps standards, source control systems, and tools like Jenkins, GitHub.
• Excellent problem-solving skills and attention to detail.
• Strong communication and collaboration skills.
• Intellectual curiosity and ability to thrive in a team environment that is constantly changing.
• Demonstrated ability to learn new technical concepts and to adapt to new technologies quickly.
• Ability to communicate in a clear, concise, professional oral or written manner, to be understood by technical and non-technical colleagues.

Preferred Qualifications

• Bachelor's degree or higher in Computer Science, Information Technology, or a related field.
• Prior experience with Data Engineering tools and architectures.
• Experience in Rail, Shipping, Airline, Logistics, Warehousing, Supply Chain, or other Transportation industries or experience in a High-Tech industry.
• Experience working in an Agile environment (Scrum, Kanban, SAFe).
• Experience with cloud platforms.
• Proficiency in using Jupyter for collaborative data analysis.
• Experience with open-source technologies and tools.
• Knowledge of geospatial data transformation and spatial libraries.

Benefits

At BNSF, you will have access to a comprehensive and competitive benefits package including:

• An industry-leading 401(k) and renowned Railroad Retirement program.
• A range of robust health care options for you and your dependents (including domestic partners), including medical, dental, vision, telemedicine, mental health, cancer support, and high-quality care network options.
• Health care spending accounts (HSA) with employer contributions, as well as life and disability insurance, provided at no cost.
• Family benefits including parental, pediatric and family building support, adoption and surrogacy reimbursement, and dependent care spending account (with employer match).
• Access to discounts on travel, gym memberships, counseling services and wellness support.
• Annual bonus (Incentive Compensation Program).
• Generous leave / time off policies.

Key skills/competency

• Data Streaming
• Data Pipelines
• ETL Processes
• Data Warehousing
• Python
• SQL
• Cloud Platforms
• Apache Kafka
• DevSecOps
• Data Security