Kansas City Southern Railway Data Analysis and Visualization Specialist in Kansas City, Missouri

Data Analysis and Visualization Specialist

Tracking Code

219326-021

Job Description

POSITION SUMMARY:

The primary responsibility of the Data Analyst/Business Intelligence Visualization Developer is to support the business in all their dashboard and analytics needs and provide a clear mechanism for self-service reporting. This role is also responsible for administration of the tools and technologies related to Business Intelligence from a platform and solution perspective. Factor in operational simplicity, resiliency, and efficiency into recommendations. The Business Intelligence Visualization Developer is a “hands on” technologist and is responsible for outlining the architecture as well as building visual analytics solutions.

POSITION REQUIREMENTS:

EDUCATION:

Bachelor's degree from a four-year accredited College/ University.with an emphasis in Data Science, Finance, Mathematics, Economics, Statistics, Analytics or related area of study preferred

PREFERRED CERTIFICATIONS:

Power BI

EXPERIENCE & SKILLS

  • 3+ years of related work experience within the Railroad industry..

  • 3+ years of Senior Business Intelligence level role in Analytics, Business Intelligence or Dashboards experience

  • Ability to be detail-oriented, self-motivated, and an excellent, creative problem-solver, with proven ability to successfully manage multiple disparate streams of work in a challenging, dynamic environment

  • Experience with the Software Development Life Cycle and ETL Processes. Technical expertise regarding data mining, database design development, data modelling, data governance and unit testing.

  • Ability to analyze, identify, extract, translate and transform business requirements into data points. Document data requirements, definitions, data dependencies and relevant business rules through various methods including independent data analysis and group discussions.

  • Strong interpersonal and consultative skills to translate and understand reporting requirements. Ability to work as part of a team, as well as work independently or with minimal direction

  • Collaborate and work closely with Business analyst, System and Cloud data architects, ETL Integration specialists and Power BI dashboard development team to develop source to target technical mapping document.

  • Proficient in data transformation, consolidating data from multiple disparate sources, develop process workflows and wireframe sketches to help business design effective dashboard solutions.

  • Design and develop data models using Erwin Data Modeler and apply best practices for optimum performance of the models.

  • Excellent communication and presentation skills and must possess exceptional ability to work well with individuals and teams at all levels, across all division’s.

  • Proficiency in developing creative Power point visual presentations to effectively communicate and articulate the value of analytic deliverables.

  • Demonstrate solid organizational and time management skills with ability to perform detailed tasks with high degree of accuracy and work and perform under pressure.

  • Document project specific processes and data flows, data dependencies, data definitions and relevant business rules. Establish data dictionaries to support the buildout of a data governance infrastructure.

  • Leverage industry best practices in establishing repeatable BI practices, principles & processes SSIS, SSRS

  • Advanced Knowledge of Microsoft Word

  • Advanced Knowledge of Microsoft Excel

  • Advanced Knowledge of Microsoft PowerPoint

  • Business Intelligence Knowledge: Tableaus

  • Windows/Linux Server environment

PREFERRED KNOWLEDGE OR SKILLS:

  • Keyboard Skills (Typing, data entry, etc.)

  • Microsoft Windows/Linux

  • Microsoft Access

  • Physical and Virtual Business Warehouse Solutions

  • Business Objects

  • SAP BW

  • Power BI

JOB DUTIES:

  • Develop and design visual Business Intelligence solutions, including Developing dashboards in

  • Power BI for financial analytics based on SAP and non-SAP sources and developing dashboards for Train Operations such as Train Delays, Operating Map.

  • Design and architect data integration process needed for business visualizations. Deliver key business metrics and their related analytics and develop logical data flow maps required for business analytics.

  • Define optimum joins between tables based on the functional requirement.

  • Design data models and data architecture. Integrate various datasets and build data models for visualization in Power BI or using data gateways. Develop quick prototype using local datasets while working in parallel with data integration team for data automation.

  • Test analytics solutions with in-place testing of data and its integration. Perform data validation during data automation process and write test scripts and record defects.

  • Knowledge of railroad industry and KPI’s supporting Financial, Operational and Performance metrics.

    The duties listed are representative of the job; however, it in no way states or implies that these are the only duties a person may be required to perform. The omission of specific statements of duties does not exclude them from the position if the work is similar, related or is an essential function of the position.

We are proud to be an EEO/AA employer/Veteran/Disabled. We maintain a drug-free workplace and perform pre-employment substance abuse testing.

Job Location

Kansas City, Missouri, United States

Position Type

Full-Time/Regular