Lead Analytics Engineer

Your success is a train ride away!

As we move America’s workforce toward the future, Amtrak connects businesses and communities across the country. We employ more than 20,000 diverse, energetic professionals in a variety of career fields throughout the United States. The safety of our passengers, our employees, the public and our operating environment is our priority, and the success of our railroad is due to our employees.

Are you ready to join our team?

Our values of ‘Do the Right Thing, Excel Together and Put Customers First’ are at the heart of what matters most to us, and our Core Capabilities, ‘Building Trust, Accountability, Effective Communication, Customer Focus, and Proactive Safety & Security’ are what every employee needs to know and do to be most impactful at Amtrak. By living the Amtrak values, focusing on our capabilities, and actively embracing and fostering diverse ideas, backgrounds, and perspectives, together we will honor our past and make Amtrak a company of the future.

Summary of Duties:‍

The Cyber Analytics Engineer will play a critical role transforming the Cybersecurity program by fusing, integrating, and presenting large data sets into simple to understand visualizations for business leaders. If you are someone who enjoys looking through data sets, creating data models, developing dashboards, and driving transparency, this position is for you.

Our team’s mission is simple: build a world-class Cybers Analytics team.

Our team’s objective is simple: transparency.

Our team’s goal is simple: excel together.

Essential Functions:

‍Drives the data component on projects that may span a broad range of systems. Requires expertise in multiple technical environments and possesses an increased level of business knowledge. Responsibilities include, but may not be limited to, the following:
• Creates and maintains optimal data pipeline architecture.
• Assembles large, complex data sets that meet functional/non-functional business requirements.
• Identifies, designs, and implements internal process improvements, automates manual processes, optimizes data delivery, re-designs infrastructure for greater scalability.
• Builds the infrastructure required for optimal extraction, transformation and loading of data from a wide variety of data sources using Structured Query Language (SQL) and Cloud Big Data technologies.
• Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency, and other key business performance metrics.
• Works with stakeholders including the Executive, Product, Data and Design Teams to assist with data-related technical issues and support their data infrastructure needs.
• Creates data tools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader.
• Works with data and analytics experts to strive for greater functionality in our data systems.
• Adheres to quality standards and procedures. Reviews modules for quality assurance and checks compliance with application architecture standards and Service Level Agreements.
• Defines data related development guidelines and standards to be utilized in software development/integration.
• Provides ongoing maintenance of applications.
• As the subject matter expert, provides technical guidance or system process expertise.
• Develops reports and presentations for senior management, as needed.

Minimum Qualifications:

• Bachelor’s Degree in Computer Science, Information Systems, Software Engineering, Software Development, Applied Data Science and Machine Learning, or relevant field, or 6+ years of relevant experience.
• Must possess 3+ years of relevant experience ability with Business Intelligence and Performance Analytics products.

Extensive experience programming and systems analysis experience. Have a broad level of understanding surrounding application architecture standards, data analytics environments and tools that include:
• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
• Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
• Strong analytic skills related to working with unstructured data sets.
• A successful history of manipulating, processing, and extracting value from large, disconnected data sets.
• Experience using the following software/tools or equivalence:
o Experience with big data tools
o Experience with SQL/NoSQL databases
o Experience with data pipeline and workflow management tools
o Experience with cloud services
o Experience with stream-processing systems
o Experience with both scripting and general-purpose object-oriented programming languages
• Must possess the ability to utilize adaptable communication skills to effectively translate between technical and business language.
• Ability to identify, propose and oversee the execution of business solutions as well as interpret documents communicating business needs and requirements.

‍Preferred Qualifications:

• Experience with Microsoft PowerBI, Salesforce Tableu, ServiceNow.
• Must possess effective communication and interpersonal skills, work well with others in an integrated team environment, and must be self-motivated.

‍Work Environment:‍

• On-site, or Hybrid options available.
• May require occasional travel up to 10%% of the time.
• May require occasional on-call status.
• May require occasional after hours, weekend, or periodic shift work.

Communications and Interpersonal Skills:

Must have excellent oral and written communication skills.

The salary/hourly range is $123,810 - $140,400.

‌