Data Analyst- COK

Title: Sr Data Analyst
Company: Kansas Southern Railway
Start Date: 05/19/2022
End Date: 11/18/2022
Location: Kansas City, MO, United States
Description:
**Remote - Opportunity to be a Hybrid Model - the worker will be expected to be onsite once the office reopens, but will work remotely at first. After the office reopens, the opportunity to work both onsite and remote could be an option**
Description
This position is responsible for researching, analyzing and translating business requirements into technical specs and designing the logical and physical models that support the BI Enterprise DW development effort. This position is responsible for managing customer expectations by taking ownership as a Business Analyst and Data Analyst for complex Capital projects.
Works independently and receives minimal guidance. Solves complex problems; takes a new perspective using existing solutions. Leads projects with moderate scope, risks, and resource requirements. Acts as a resource for colleagues with less experience. Develops and manages operational initiatives to deliver tactical results.
Accountabilities
Engage with business Analyst to understand requirements and needs and translate that into Analytical reports and dashboards
Functions as the lead for BI-SDLC (Business Intelligence Software Delivery Lifecycle) projects.
Collaborates and work closely with Business, System Integration and Cloud data architects, ETL (Extract, Transform, Load) Integration specialists and Power BI dashboard development team.
Analyzes and translate business requirements into technical requirements.
Develops BRD and/or TDD independently.
Designs and develops data models and applies best practices for optimum performance of the models.
Documents project specific processes and data flows, data dependencies, data definitions and relevant business rules.
Establishes data dictionaries to support the buildout of a data governance infrastructure.
Converts functional requirements into technical specifications.
Performs data analysis, data mapping, functional testing, unit testing, and test case preparation using required tools based on project needs.
Designs and develops DDL scripts, ad hoc queries and data models for high performance projects and deliverables.
Works with project teams and business stewards to refine business requirements that produce well-designed and developed solutions.
Exemplifies KCS Vision, Values, and Culture in each and every interaction with team, clients, and stakeholders.
Preferred
3+ years of hands-on experience with R, Python, MML, SAS Enterprise Miner or similar tools in support of on-demand, real-time analytic services.
Experience with warehouse data extraction/transformation and load tools, as well as metadata repository tools.
Advanced proficiency in relational Database concepts, Database design using star, snowflake and data vault schema along with ability to write and execute complex SQL queries and stored procedures.
Knowledge of various database platforms (DB2, SAP,MS SQL Server) required and experience with one or more of the following, Power BI, Informatica, Azure Cloud, IoT, MuleSoft, AQT, ErWin Data Modeling.
Proficient with MS Office tools like PowerPoint, MS Project, Visio, Excel and Word and shell scripting.
Understands and evaluates existing SQL scripts and Data Models.
Experience with the SDLC and ETL Processes, data mining, database design development, data modelling, data governance and unit testing.
Proficient in data transformation, consolidating data from multiple disparate sources, develop process workflows and wireframe sketches to help business design effective dashboard solutions.
Working Conditions
Works with diverse set of data sources, such as Streaming Data, Time series data, semi-structured and unstructured data.
Works to apply and develop appropriate statistical, machine learning, and/or deep learning models and algorithms to classify structured or unstructured data.
Demonstrates ability to communicate technical recommendations to a non-technical audience in a clear and concise manner.
Demonstrates ability to understand logical relationships and to ensure that programming faithfully replicates these relationships.
Demonstrates ability to test and validate programming steps.
Demonstrates strong written and oral communication skills.
Exhibits attention to detail, self-motivation creative problem solving, with proven ability to successfully manage multiple disparate streams of work in a challenging, dynamic environment
Demonstrates solid organizational skills, performs detailed tasks with high degree of accuracy, and performs under pressure.
Multitasks, prioritizes and manages time effectively.
Displays excellent communication and presentation skills and must possess exceptional ability to work well with individuals and teams at all levels, across all divisions.
Works in a structured environment and performs in high-pressure ad hoc mode to address urgent needs.
This position has a regular full time schedule with a normal work week of Monday through Friday. There may be a need for occasional work after hours or weekends.
This position may require minimal travel up to 10% of the time.
Bachelor's degree from an accredited university or college, preferably in a job related major field of study
Minimum five (5) years of relevant professional experience, or equivalent combination of education and experience




View this email in your browser:



https://abovoinc.bmetrack.com/c/v?e=1461745&c=108136&l=7878B23F&email=oE6NJtd8Q0Fxqw%2Br%2BqiPUkD%2Bo%2BFWB4v%2B6PlCCEw9Ep03Ih4P1WxctQ%3D%3D&relid=A0B1AB1



You are receiving this email because of your relationship with Ab Ovo, Inc.. Please reconfirm your interest in receiving emails from us. If you do not wish to receive any more emails, you can unsubscribe here.



https://abovoinc.bmetrack.com/c/opt?e=1461745&c=108136&l=7878B23F&email=oE6NJtd8Q0Fxqw%2Br%2BqiPUkD%2Bo%2BFWB4v%2B6PlCCEw9Ep03Ih4P1WxctQ%3D%3D&relid=A0B1AB1



https://abovoinc.bmetrack.com/c/su?e=1461745&c=108136&l=7878B23F&email=oE6NJtd8Q0Fxqw%2Br%2BqiPUkD%2Bo%2BFWB4v%2B6PlCCEw9Ep03Ih4P1WxctQ%3D%3D&relid=A0B1AB1







This message was sent to hotlisthouse.today24@blogger.com by namrata@abovoinc.com



You can modify/update your subscription via the link below.



Unsubscribe from all mailings



https://abovoinc.bmetrack.com/c/su?e=1461745&c=108136&l=7878B23F&email=oE6NJtd8Q0Fxqw%2Br%2BqiPUkD%2Bo%2BFWB4v%2B6PlCCEw9Ep03Ih4P1WxctQ%3D%3D&relid=A0B1AB1



Manage Subscription



https://abovoinc.bmetrack.com/c/s?e=1461745&c=108136&l=7878B23F&email=oE6NJtd8Q0Fxqw%2Br%2BqiPUkD%2Bo%2BFWB4v%2B6PlCCEw9Ep03Ih4P1WxctQ%3D%3D&relid=A0B1AB1



Email Marketing

benchmarkemail.com

[https://abovoinc.bmetrack.com]



2320 Walsh Ave Suite H, Santa Clara, CA, 95051



Manage Subscription: https://abovoinc.bmetrack.com/c/s?e=1461745&c=108136&l=7878B23F&email=oE6NJtd8Q0Fxqw%2Br%2BqiPUkD%2Bo%2BFWB4v%2B6PlCCEw9Ep03Ih4P1WxctQ%3D%3D&relid=A0B1AB1