CincinnatiOHRecruiter Since 2001
the smart solution for Cincinnati jobs

Sr. Data Engineer

Company: First Transit
Location: Cincinnati
Posted on: October 17, 2020

Job Description:

Job Purpose: The Sr. Engineer will be responsible for maintaining large and complex data sets, building data architecture for data extraction, and modeling data in data warehouse. The scope includes building dimensional models in data warehouses, columnar store databases, OLAP cubes, Microsoft tabular models, Bigdata Hadoop / distributed filesystem, and other logical and physical organization techniques. The ideal candidate will have hands on experience in big data architecture and data warehousing principles as well as hands on experience in full information lifecycle for large scale big data environments -- from data origination to data consumption. Major Responsibilities:

  • Maintains the end-to-end vision of the data flow diagram and develop logical data models into one or more physical data repositories
  • Document logical data integration (ETL) strategies for data flows between disparate source/target systems for structured and unstructured data into common data lake and the enterprise information repositories.
  • Prepare plans and ensure implementation of EDW as per business requirements.
  • Responsible for leading continuous improvement efforts to enhance performance and provide increased analytics and business intelligence capabilities
  • Design and develop the architecture, roadmap, and standards for the enterprise data warehouse that will align with the customer business and IT objectives
  • Collaborates with internal and external data science and engineering teams, architects and developers throughout FGA network to ensure alignment with the enterprise data strategy.
  • Develop deep and comprehensive understanding of the FS business and associated data.
  • Implementation including loading from disparate data sets, preprocessing using Spark Hadoop/HDInsight, Spark, and Hive. Experience & Skills Required:
    • S. degree in Information systems, engineering, computer science, or equivalent technical field.
    • A graduate degree in a related field a plus.
    • Big data certification is a plus.
    • 7+ years of experience with data warehouse technical architectures, ETL/ ELT, and advanced knowledge and expertise with data modelling skills.
    • Advanced SQL with SQL data warehouse and/or Redshift. AWS and/or Azure knowledge preferred.
    • Experience with scripting (Python experience is a strong plus).
    • Experience working with MPP data warehouse (e.g. Azure SQL data Warehouse or Redshift)
    • Experience in ETL design and tools (e.g. Azure Data Factory, etc.)
    • Experience in working with Map-Reduce systems (Hadoop, Spark)
    • Experience with NoSQL systems (Cosmos DB/Dynamo DB)
    • In depth understanding of Data Warehousing concepts, dimensional data models and experience in creating data warehouse schemas using Kimball methodology.
    • Must be able to perform impact data analysis and data profiling on source data systems and determine best way to model data.
    • Good analytical and problem-solving skills
    • Ability to work in a self-directed work environment.
    • Ability to work in a team environment. FirstGroup is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status.

Keywords: First Transit, Cincinnati , Sr. Data Engineer, Engineering , Cincinnati, Ohio

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other Engineering Jobs


College Intern - Environmental Engineering
Description: Job Title:College Intern - Environmental EngineeringJob Description: br br JOIN THE TEAM THAT'S POWERING PROGRESS br br Building cities. Driving commerce. Saving lives. For over 100 years, Allison (more...)
Company: Allison Transmission
Location: Indianapolis
Posted on: 10/22/2020

School Bus Mechanic
Description: br br School Bus Mechanic Hourly Wage Our First Student facility in Indianapolis, IN needs a reliable A Level Diesel Mechanic with 5 years of hands-on diesel and/or gas engine experience. Our (more...)
Company: First Student
Location: Indianapolis
Posted on: 10/22/2020

Sr. Engineer, Furnishings (Job #1298)
Description: POSITION SUMMARY: br br Provides all levels of engineering drawings related to interior cabin furnishing and components in support of VIP aircraft completions. Mentors other engineers on department (more...)
Company:
Location: Indianapolis
Posted on: 10/22/2020


Valvoline Instant Oil Change: Lube Technician
Description: Job Description:Geared for the Driven During these uncertain times of COVID-19, Valvoline Instant Oil Change SM VIOC is proud to serve those who need to be on the road, including first responders and (more...)
Company: Valvoline Instant Oil Change
Location: Fishers
Posted on: 10/23/2020

HOURLY - Stationary Engineering Powerhouse
Description: Job Title:HOURLY - Stationary Engineering PowerhouseJob Description: br br General Description br ul br li Operates, adjusts and maintains all powerhouse machinery, equipment and controls (more...)
Company: Allison Transmission
Location: Indianapolis
Posted on: 10/22/2020

Senior Engineer, Furnishings (Job #1241)
Description: POSITION SUMMARY: br br Provides all levels of engineering drawings related to interior cabin furnishing and components in support of VIP aircraft completions. Mentors other engineers on department (more...)
Company:
Location: Indianapolis
Posted on: 10/22/2020

Diesel Technician/Mechanic II
Description: br br Position Location: 4304 West Morris Street Indianapolis, IN 46241 br br Position Summary: br Penske Technician II will generally assist in the repair and diagnosis of major components (more...)
Company: Penske
Location: Indianapolis
Posted on: 10/22/2020

Auto Technician Part-Time/Full-Time - E 96th St
Description: Geared for the Driven-------------- During these uncertain times of COVID-19, Valvoline Instant Oil Change SM VIOC is proud to serve those who need to be on the road, including first responders and (more...)
Company: Valvoline Instant Oil Change
Location: Indianapolis
Posted on: 10/22/2020

Geospatial Engineer
Description: You can play an important part in disaster relief missions as a Geospatial https://cicad.us/2WPcFue for the Army National Guard. In this role, you will extract and supply geographic data that supports (more...)
Company: Army National Guard
Location: Indianapolis
Posted on: 10/22/2020

Senior Engineer Structures (Job #1316)
Description: POSITION SUMMARY: br br The Senior Structures Engineer is responsible for design, documentation, and installation tasks on Transport Category Aircraft for Interior Completion STC projects and smaller (more...)
Company:
Location: Indianapolis
Posted on: 10/22/2020

Log In or Create An Account

Get the latest Ohio jobs by following @recnetOH on Twitter!

Cincinnati RSS job feeds