Sr Data Analyst

1 week ago

Kansas City, United States CPKC Full time

Canadian Pacific (CP) and Kansas City Southern (KCS) are now CPKC. As the only truly North American railway, we are making big moves Drawing on our strong foundations and heritage, CPKC moves essential goods across our 20,000-mile network to support economic growth throughout Canada, the U.S. and Mexico. Be a part of history as we connect a continent and create exciting career opportunities across our new transnational network. Visit cpkcr.com to learn about the CPKC advantage, our purpose and culture.

 

PURPOSE OF THE POSITION:

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.

 

POSITION ACCOUNTABILITIES:

  • Functions as the lead for BI-SDLC (Business Intelligence Software Delivery Lifecycle) projects.
  • Collaborates and work closely with Business, System Integration, 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 SQL 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 CPKC Vision, Values, and Culture interactions with coworkers, business partners, customers and stakeholders.

 

POSITION REQUIREMENTS:

  • 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

Preferred

  • 3+ years of hands-on experience with DAX, 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.
  • Knowledge of various database platforms SAP,MS SQL Server
  • Data Visualization software preferably Power BI
  • 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.

 

 

WHAT CPKC HAS TO OFFER:

  • Flexible and competitive benefits package
  • Employer Funded Retirement Plan
  • Employee Share Purchase Plan
  • Performance Incentive Program
  • Annual Fitness Subsidy
  • Part-time Studies Program

 

 

ADDITIONAL INFORMATION:

As an employer with North American presence, the possibility does exist that the location of your position may be changed based on organizational requirements.

 

Drug Test Elements:

CPKC is committed to the safety and health of its employees and the general public.  All new hires are required to undergo a drug screen.  We appreciate your cooperation in keeping CPKC safe and drug free. 

 

Background Investigation:

The successful candidate will need to successfully complete the following clearances:       

 

  • Criminal history check
  • Reference check
  • Education verification
  • Driver’s License Verification
  • Last 3 years of driving history
  • Last 7 years of employment history; includes military service
  • Social Security number verification

 

Management Conductor Program:

Becoming a qualified conductor or locomotive engineer is the single best way for a management employee to learn the business at CPKC. You may be required to obtain a certification or to maintain your current certification/qualification as a conductor or locomotive engineer.

 

CPKC is an equal opportunity/affirmative action employer, inclusive of protected veterans and individuals with disabilities. 

 

 

 

 

 

With Job Requisition Fields

  • Req ID: 102977
  • Department: Strategic Planning
  • Job Type: Full-Time
  • Position Type: Non-Union
  • Location: Kansas City, Missouri
  • Country: United States
  • % of Travel: 0-10%
  • # of Positions: 2
  • Job Grade: 4
  • Compensation Rate:

Job Available to: Internal & External

  • Sr. Data analyst

    4 weeks ago

    Jersey City, United States Diverse Lynx Full time

    Sr. Data analyst Charlotte/ New Jersey Hybrid We are looking for a strong Sr. Data Analyst 3.Experience 8to10Yrs 4.Required Skills ,Data Architect Roles & Responsibilities Gathering and maintaining functional and data requirements Completing complex data mappings from source to target Completing complex data modeling and data flow diagrams Creating and...

  • Sr. Data analyst

    2 weeks ago

    Jersey City, United States Diverse Lynx Full time

    Sr. Data analyst Charlotte/ New Jersey Hybrid We are looking for a strong Sr. Data Analyst 3.Experience 8to10Yrs 4.Required Skills ,Data Architect Roles & Responsibilities Gathering and maintaining functional and data requirements Completing complex data mappings from source to target Completing complex data modeling and data flow diagrams Creating and...

  • Sr Data Analyst

    3 weeks ago

    Kansas City, United States Lockton Full time

    Job Summary: We are seeking a talented Senior Data Analyst to join our dynamic team. In this role you will help manage client and industry data, assist in development of new internal data processes, analyze data to support research and development and mentor junior analysts. In addition, you will consult with end users on recommendations for new reports and...

  • Sr Data Analyst

    6 days ago

    Kansas City, United States Lockton, Inc. Full time

    Job Summary: We are seeking a talented Senior Data Analyst to join our dynamic team. In this role you will help manage client and industry data, assist in development of new internal data processes, analyze data to support research and development and mentor junior analysts. In addition, you will consult with end users on recommendations for new reports and...

  • Sr Data Analyst

    1 month ago

    Kansas City, Missouri, United States Lockton, Inc. Full time

    Job Summary:We are seeking a talented Senior Data Analyst to join our dynamic team. In this role you will help manage client and industry data, assist in development of new internal data processes, analyze data to support research and development and mentor junior analysts. In addition, you will consult with end users on recommendations for new reports and...

  • Sr Data Analyst

    2 weeks ago

    Kansas City, United States Lockton, Inc. Full time

    Job Summary: We are seeking a talented Senior Data Analyst to join our dynamic team. In this role you will help manage client and industry data, assist in development of new internal data processes, analyze data to support research and development and mentor junior analysts. In addition, you will consult with end users on recommendations for new reports and...

  • Sr Data Analyst

    4 weeks ago

    Kansas City, United States Lockton, Inc. Full time

    Job Summary: We are seeking a talented Senior Data Analyst to join our dynamic team. In this role you will help manage client and industry data, assist in development of new internal data processes, analyze data to support research and development and mentor junior analysts. In addition, you will consult with end users on recommendations for new reports and...

  • Sr. Data Analyst

    2 weeks ago

    Texas City, Texas, United States Diverse Lynx Full time

    Job Title: Sr. Data Analyst Location: Remote Duration: Permanent/Full-Time DESCRIPTION: Expertise in processing and moving around large amounts of data, preferably Healthcare data. Candidate should have experience In HIPPA . Expertise in SQL Server, complex T-SQL, ETL tools such as SSIS, preferably basic database administration Experience in using Microsoft...

  • Sr. Data Analyst

    2 weeks ago

    Texas City, United States Diverse Lynx Full time

    Job Title: Sr. Data Analyst Location: Remote Duration: Permanent/Full-Time DESCRIPTION: Expertise in processing and moving around large amounts of data, preferably Healthcare data. Candidate should have experience In HIPPA . Expertise in SQL Server, complex T-SQL, ETL tools such as SSIS, preferably basic database administration Experience in using...

  • Sr. Data Analyst

    4 weeks ago

    Texas City, United States Diverse Lynx Full time

    Job Title: Sr. Data Analyst Location: Remote Duration: Permanent/Full-Time DESCRIPTION: Expertise in processing and moving around large amounts of data, preferably Healthcare data. Candidate should have experience In HIPPA . Expertise in SQL Server, complex T-SQL, ETL tools such as SSIS, preferably basic database administration Experience in using Microsoft...

  • Sr Data Analyst

    1 month ago

    Kansas City, Missouri, United States Hallmark Full time

    WHO WE AREThe Insights & Analytics team provides powerful consulting along with key reporting and insightful analyses to the Hallmark Brand business. We focus on using data to understand our consumers, leveraging a vast number of sources to our advantage. We focus on complete storytelling to form an understanding of what has happened and use trends and...

  • Sr Data Analyst

    1 week ago

    Kansas City, Missouri, United States CPKC Full time

    Canadian Pacific (CP) and Kansas City Southern (KCS) are now CPKC. As the only truly North American railway, we are making big moves Drawing on our strong foundations and heritage, CPKC moves essential goods across our 20,000-mile network to support economic growth throughout Canada, the U.S. and Mexico. Be a part of history as we connect a continent and...

  • Sr. Renewables Regulatory Analyst, NERC and FERC

    7 days ago

    Kansas City, United States ThinkBAC Consulting Full time

    Job DescriptionJob DescriptionSr. Renewables Regulatory Analyst - Energy Storage (BESS)Locations: FULLY REMOTE (Anywhere in the USA)This an opportunity to join an industry leading renewable energy venture and IPP with strong private equity backing that is focused on the development/execution of dynamic utility-scale energy storage projects. They are at the...

  • Sr. Cloud Financial Analyst

    2 weeks ago

    Kansas City, United States Burns & McDonnell Full time

    Description The Senior Cloud Financial Analyst role is responsible for supporting the management of the cloud portfolio while optimizing the value, cost, and financial management of our cloud providers. The Senior Cloud Financial Analyst primary focus will be ensuring efficient cloud resource utilization, cost tracking, and identifying opportunities for...

  • Sr Data Delivery Analyst

    1 week ago

    Salt Lake City, United States TME Full time

    ** Sr Data Delivery Analyst** **Job Category****:** Engineering/Designers **Requisition Number****:** SRDAT002279 Showing 1 location **Job Details** **Description** Bernhards core mission is delivering innovative engineering, construction, and energy solutions that empower our clients and promote a sustainable future. Bernhard is comprised of four divisions:...

  • Senior Business Analyst

    2 weeks ago

    Oklahoma City, Oklahoma, United States NTT DATA Full time

    Req ID:280277 NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Senior Business Analyst to join our team in Oklahoma City, Oklahoma (US-OK), United States (US). The Senior...

  • Data Analyst

    4 weeks ago

    Kansas City, United States Hallmark Cards Full time

    GATHER data from various sources utilizing tools such as SQL, Python and R Studio ORGANIZE data utilizing tools such as Tableau, Power. BI and Excel ANALYZE the data for insights and look past the numbers to uncover what's meaningful. Identify trends Data Analyst, Analyst, Remote, Data, Manufacturing, Technology

  • Sr. IT Business Analyst

    2 weeks ago

    Kansas City, United States Associated Wholesale Grocers Full time

    Sr. IT Business Analyst Location: Kansas Avenue Kansas City, KS Department: Information Technology AWG is in search of the best IT Business Analysts to support our strategic, business-transforming projects in Information Technology Service and Support. This role assists with the prioritization of needs and serves as a liaison between AWG...

  • Data Analyst

    4 weeks ago

    Kansas City, United States eGourmet Solutions Inc Full time

    About this role We are seeking a highly skilled Data Analyst to join our team. This role combines expertise in data analysis, Python scripting, SQL databases, Azure Data Factory, PowerBI, and predictive analytics tools such as Akkio. The ideal candidate will be responsible for enhancing our customer experience through insightful data analysis and predictive...

  • Sr. SEO Analyst

    2 weeks ago

    Kansas City, Missouri, United States Innova Solutions Full time

    Sr. SEO Analyst Information TechnologyJob ID:Kansas City , MOJob Type:Contract Added - 04/29/24Job Description Innova Solutions is immediately hiring for a Sr. SEO Analyst Position type: ContractDuration: 6 + monthsLocation: Remote As a SEO Specialistyou will:Responsibilities Lead the implementation of advanced search optimization solutions to enhance...