Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Director, Data Engineering

$112.29k - $161.28k

DigitasLBi

PHM Data Warehouse Developer

PHM is the leading health media agency in the US, built for the modern healthcare experience. Here, industry depth meets media scale, where data becomes direction, where creativity and storytelling bring truth to life, and where orchestration replaces fragmentation. Dedicated to making brands discovered, PHM redefines what media can do through data, content, and creativity. Because in modern healthcare, the brands that are found are the ones that lead. And when brands lead, advantage follows. Go deeper. Be found.

Overview of Job Function: Responsible for developing and supporting data products, this resource plays a critical role in the development of data warehouse/data lake solutions utilized by internal and external stakeholders. Design and develop warehouse solutions built on the Microsoft SQL Server and AWS technology stacks. These solutions include ETL, data modeling, data quality assessment and data delivery.

Key Responsibilities:

  • Create high performance data products by monetizing warehouse and ETL solutions using SSIS, python and Spark
  • Performance tuning and optimization of ETL, SQL and database structures
  • Design and develop tables, views, triggers, indexes, constraints and stored procedures
  • Monitor long running transactions and can optimize query executions using best practices and methodologies
  • Assist/support in the design process on an as needed basis
  • Design data models for enterprise-wide data integration incorporating: structured and unstructured data real time, on-demand, batch and varying timing schedules
  • Build data flow automation to retrieve, transform and load data
  • Manage data warehouse structure and file storage rules
  • Data management functions including: metadata management create, alter, delete, grant permissions, indexing, updating query tuning maintain best practices for handling, storing and using data

Tools: SQL Server/SSIS Python/Java Web Analytics Platforms – Google, Adobe, etc. BI Platforms – Tableau, Datorama, etc Cloud Technologies – AWS, Azure, Google

Requirements:

  • BS Degree in one of the following subject areas; Computer Science, Information Technology or related field preferred
  • Minimum of 5+ years of experience developing large scale complex database solutions
  • Demonstrated experience with BI database design
  • Ability to track and resolve database related incidents as well as requests
  • Strong understanding of database structures, theories, principles, and practices
  • Strong understanding of ETL and data warehouse principles
  • Good interpersonal, written and oral communication skills
  • Technical documentation skills
  • Ability to present complex ideas in user-friendly language
  • Self-motivated and directed, with keen attention to detail
  • Able to prioritize and execute tasks in a team-oriented, high-pressure environment

Specific Skills Required:

  • Minimum 6 years SQL experience, 5 years of ETL experience, 7 years analyzing data sets
  • Strong data warehouse knowledge
  • Experience with JSON, XML, ORC,AVRO and Parquet file formats
  • Experience with large data sets Java, C# or R experience a plus
  • Experience with REST API calls
  • Experience with Web and Digital marketing data a plus

Compensation Range: USD $112,290.00 - USD $161,280.00/Annually.

Vacancy posted 3 days ago
Similar jobs that could be interesting for youBased on the Director, Data Engineering in Chicago, IL vacancy
  • $112.29k - $161.28k

     ...PHM Data Warehouse Developer PHM is the leading health media agency in the US, built for the modern healthcare experience. Here, industry depth meets media scale, where data becomes direction, where creativity and storytelling bring truth to life, and where orchestration... 
    Suggested
    Temporary work
    Freelance
    Flexible hours

    PHM Corp

    Chicago, IL
    3 days ago
  • $200k - $275k

    Are you ready to make an impact?West Monroe has an opportunity for a strategic Director, Data Engineering & AI to join our Technology practice. This leader will structure, lead, support, drive, and grow West Monroe’s Technology Data Engineering practice and associated... 
    Suggested
    Work at office
    Local area
    Immediate start
    Flexible hours
    2 days per week
    1 day per week

    West Monroe Partners

    Chicago, IL
    1 day ago
  • $229k - $309k

     ...looking to apply your relevant experience to a new industry, join our team as we help shape a brighter way forward. Sr. Director, Data Engineering (REMS)About JLL and JLL TechnologiesJLL is a leading professional services firm that specializes in real estate and investment... 
    Suggested
    Full time
    Local area

    Jones Lang LaSalle

    Chicago, IL
    4 days ago
  • $205k - $225k

     ...Job Description Job Description Job Title: Director of Data Engineering & Analytics Primary Location: Chicago, IL – Hybrid (3 days onsite per week) Position Type: Direct Hire / Full-Time Salary: $205,000 – $225,000 annually Benefits Overview TalentFish... 
    Suggested
    Full time
    Contract work
    3 days per week

    TalentFish LLC

    Chicago, IL
    24 days ago
  •  ...trusted by leading Fortune 500 and Global 2000 enterprises for data-driven decision-making. Founded in 2016, MathCo builds custom AI...  ...'. Job Description: We are seeking an experienced Data Engineering Manager with expertise in Pharmaceutical / Life Sciences... 
    Suggested
    Work experience placement
    3 days per week

    MathCo

    Chicago, IL
    4 days ago
  • $160k - $190k

     ...our current needs and planned growth we are very pleased to offer a new opportunity to join our dedicated team as a Manager, Data Engineering. Job Description The Manager, Data Engineering leads the design, delivery, and reliability of TAG's enterprise data... 
    Work at office

    The Aspen Group

    Chicago, IL
    a month ago
  • $162.7k - $199.3k

     ...the value and liquidity of the world’s buildings, while enhancing the productivity and happiness of those that occupy them. The Data Engineering team builds and operates the data products and pipelines that power JLL’s Corporate Functions, including areas such as finance... 
    Daily paid
    Full time
    Local area

    Jones Lang LaSalle

    Chicago, IL
    1 day ago
  • $124k - $335k

     ...ApplicableSpecialismSoftware EngineeringManagement LevelSenior ManagerJob Description & SummaryThe OpportunityAs a Forward Deployed Data Engineering - Senior Manager, you will be at the forefront of developing innovative software solutions to drive digital transformation and... 
    Full time
    H1b

    PwC

    Chicago, IL
    2 days ago
  • $147k - $260.7k

     ...why there’s nowhere like RSM.RSM US LLP is looking for a dynamic Pre-Sales Engineer (PSE) Director that will have a primary focus on facilitating the growth of our consulting practice.The Data Analytics/AI Pre-Sales Engineer (PSE) Director supports sales productivity and... 
    Full time
    Work experience placement
    Internship
    Local area
    Work from home
    Flexible hours

    RSM International

    Chicago, IL
    5 days ago
  • $148.2k - $211.2k

    Reporting to the Data Platform and Engineering Director, the Data Engineering Senior Manager leads the design, build, and optimization of the scalable data platforms that power analytics, machine learning, and AI across the firm. As a hands-on leadership role, it will... 
    Full time

    Sidley Austin

    Chicago, IL
    5 days ago
  • $150k

     ...ApplicableSpecialismSoftware EngineeringManagement LevelDirectorJob Description & SummaryThe OpportunityAs a Forward Deployed Data Engineering - Director, you will lead the charge in developing innovative software solutions that drive digital transformation and enhance... 
    Full time
    H1b

    PwC

    Chicago, IL
    2 days ago
  • We Are The beginning of a new Data & AI decade that will reshape work and society has begun. Accenture is stepping boldly into this...  ..., and Power Ecosystem automation.The WorkWe are seeking a Data Engineering, Management & Governance Manager to own the technical integrity... 
    Live in
    Work at office
    Local area

    Accenture

    Chicago, IL
    4 days ago
  •  ...consumer technology business is looking for a Senior Manager of Data Science to play a key role in shaping how data science and...  ...work at the intersection of data science, product innovation, and engineering. You'll have the autonomy to shape the data science roadmap,... 

    Saragossa

    Oak Brook, IL
    12 days ago
  • Sr Data Engineering & Data Governance Architect  Our talented Data & AI team is made up of globally recognized experts - and there's room for more analytical and ambitious data professionals. If you're passionate about helping clients transform their business with the... 

    Avanade

    Chicago, IL
    3 days ago
  • $99k - $266k

     ...ApplicableSpecialismSoftware EngineeringManagement LevelManagerJob Description & SummaryThe OpportunityAs a Forward Deployed Data Engineering - Manager, you will play a pivotal role in developing innovative software solutions to drive digital transformation and enhance... 
    Full time
    H1b

    PwC

    Chicago, IL
    2 days ago
  • $161.5k - $299.7k

     ...development.Job SummaryHCSC is recruiting for a leader in our Data Science Engineering function. The team is responsible for the engineering...  ...deployment, MLOps, monitoring, and reliability. The Senior Director will lead a team of machine learning engineers who partner... 
    Full time
    Work experience placement
    Work at office
    3 days per week

    Health Care Service

    Chicago, IL
    3 days ago
  •  ...government sectors to become more optimized, digitally enabled, and data-driven organizations through our comprehensive business...  ...Group is seeking an experienced Senior Manager, Data Solutions Engineering - Tax & Accounting to support enterprise data modernization initiatives... 
    Temporary work

    Itero Group

    Chicago, IL
    4 days ago
  • $102.3k - $209.5k

     ...Data Center Manager Oversees the completion ongoing Data Center critical infrastructure maintenance and repair for all service...  ...with promptly. Guides team in applying operating knowledge of engineering systems for advanced diagnostics and repairs. Applies knowledge... 
    Contract work
    Temporary work
    For contractors
    Flexible hours

    Oracle

    Chicago, IL
    1 day ago
  • $155k - $175k

    How you’ll make an impact: As the Manager of Data Platform Engineering, you will lead the platforms that power our data and analytics capabilities, with Snowflake at the center. This is a hands-on leadership role. You will lead a small team while personally designing, automating... 
    Work experience placement

    Strata Decision Technology

    Chicago, IL
    2 days ago
  •  ...our beliefs in integrity, inclusion and belonging.Your Impact Starts the Day You Do!What We Need:We are looking for a Manager, Data Engineering - Platform to join our Decision Science team. This position can be located in Muscatine, Iowa or Chicago, IL. The Manager,... 

    HNI Corporation

    Chicago, IL
    4 days ago
  •  ...decentralized finance (DeFi). The Chainlink stack provides the essential data, interoperability, compliance, and privacy standards needed to...  ...Chainlink Reserve. Learn more at chain.link.The roleThe Engineering Manager for Data Feeds will lead a critical area of the... 
    Remote work

    Chainlink Labs

    Chicago, IL
    5 days ago
  • $110k - $140k

     ...Type: Full time Remote Type: Job Family Group: Information Technology Job Description Summary: The Principal Data Engineer is responsible for designing, developing, and optimizing scalable data pipelines, data products, and cloud-based solutions that... 
    Full time
    Work at office
    Remote work
    Work from home
    Flexible hours
    2 days per week

    Breakthru Beverage Group

    Chicago, IL
    3 days ago
  •  ...the design and development of tools and solutions working with data scientists, data integration teams and visualization experts to...  ...from an accredited college/university or foreign equivalent in engineering, computer science, information systems, management information... 
    Local area

    KPMG

    Chicago, IL
    2 days ago
  • $200k - $250k

     ...Principal Data Engineer Opportunity Location: Chicago, IL or New York, NY Base Salary Range: $200,000 - $250,000 (Base salary is only one part of Group One Trading's total compensation, which includes an annual discretionary bonus.) The Opportunity Our Principal... 
    Flexible hours

    Group One Trading

    Chicago, IL
    4 days ago
  •  ...areas of inspiration and expand your capabilities, then consider a career in Advisory.KPMG is currently seeking a Manager, Data Science Engineer to join our Consulting practice.Responsibilities:Translate advanced business analytics problems into technical approaches that... 
    H1b
    Local area

    KPMG

    Chicago, IL
    3 days ago
  •  ...investment in our people, our future, and what we stand for as a firm.KPMG is currently seeking a Senior Manager, Ignition - Tax Data Engineer to join our Tax Ignition practice.Responsibilities:Lead and direct cross-functional teams (data engineers, tax technologists,... 
    Local area

    KPMG

    Chicago, IL
    2 days ago
  • $88.54k - $127.16k

     ...attention of a boutique agency with the unrivaled resources and expertise of a global powerhouse. Overview Overview: The Manager, Data Engineering will help build the technical foundation that enables scalable analytics, automation, and AI-powered capabilities across... 
    Temporary work
    Freelance
    Flexible hours

    Publicis Groupe

    Chicago, IL
    22 hours ago
  •  ...strongly in building a unique culture that fosters growth, personal development and camaraderie. Role Summary At Tovala, the Data Engineering Manager leads the Data Engineering team and owns the pipelines, platform, and data applications that every data consumer at... 
    Full time

    tovala

    Chicago, IL
    5 days ago
  • $160k - $190k

     ...digital transformation firm focused on delivering solutions around data-driven enterprise, IT modernization, customer experience,...  ...Qualifications Ability to create working environments for data engineers and scientists, and general knowledge of ML, AI, LLMs, and... 
    Full time

    Reply

    Chicago, IL
    28 days ago
  •  ...proposals, estimation, statements of work, and requests for proposals Contributing to and overseeing the successful delivery of data platform, analytics, and data science projects while liaising with clients to meet their needs Providing leadership, coaching, and... 
    Full time
    Flexible hours

    Reply

    Chicago, IL
    6 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Director, Data Engineering. Be the first to apply!