Logo of Huzzle

Home

Matches

Explore

Manage

Sr Data Analyst

image

CPKC

Sep 25

  • Job
    Full-time
    Senior Level
  • Data
  • Kansas City, +1

AI generated summary

  • You need a bachelor's degree, 5+ years of experience, proficiency in DAX, R, Python, SQL, data visualization (Power BI), ETL processes, and strong communication skills. Up to 10% travel may be required.
  • You will lead BI-SDLC projects, translate business needs into technical specs, design data models, conduct testing, and collaborate with teams to deliver effective data solutions.

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
  • 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
  • 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

Responsibilities

  • 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.

FAQs

What is the primary purpose of the Sr Data Analyst position at CPKC?

The primary purpose of the Sr Data Analyst position is to research, analyze, and translate business requirements into technical specifications while designing logical and physical data models to support the BI Enterprise Data Warehouse development efforts.

What are the key responsibilities of this position?

Key responsibilities include leading BI-SDLC projects, collaborating with various teams, developing business and technical requirements, designing data models, documenting processes, establishing data dictionaries, and performing data analysis and testing.

What educational qualifications are required for this role?

A Bachelor's degree from an accredited university or college, preferably in a job-related major field of study, is required.

How many years of relevant professional experience is required for this position?

A minimum of five (5) years of relevant professional experience or an equivalent combination of education and experience is required.

Are there any preferred qualifications for applicants?

Yes, preferred qualifications include 3+ years of hands-on experience with DAX, R, Python, MML, SAS Enterprise Miner, experience with ETL tools, knowledge of database platforms like SAP and MS SQL Server, proficiency in Power BI, and experience with data governance and unit testing.

What are the working conditions for this role?

The Sr Data Analyst may work with diverse data sources, and will need to apply statistical, machine learning, or deep learning models. The position requires strong communication skills to relay technical recommendations to non-technical audiences.

What is the work schedule for this position?

The position has a regular full-time schedule with a normal work week from Monday through Friday, although there may be occasional work after hours or on weekends.

What travel requirements are associated with this role?

The position may require minimal travel, up to 10% of the time.

What benefits does CPKC offer to employees?

CPKC offers a flexible and competitive benefits package, an employer-funded retirement plan, an employee share purchase plan, performance incentive programs, and an annual fitness subsidy.

Are background checks required for this position?

Yes, the successful candidate will need to complete clearances, including a criminal history check, reference check, education verification, and driving history check, among others.

Is CPKC an equal opportunity employer?

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

image

CPKC

Transportation
Industry
1001-5000
Employees

Mission & Purpose

Go places no one else can go with CPKC. As the only single-line rail network connecting North America, CPKC provides innovative and efficient freight transportation services to key markets across the continent elevating safety, improving service and driving sustainability. We are changing supply chains, connecting communities and fueling economic growth in Canada, the United States and Mexico.