ETL Architect

  • location: Rolling Meadows, IL
  • type: Temp to Perm
  • salary: $55 - $70 per hour
easy apply

job description

ETL Architect

job summary:
Our client is in need of an ETL Architect and Team Lead for a contract-to-hire opportunity in Rolling Meadows, IL:

  • Collaborate with internal customers, prospects and stakeholders, understand and translates business use cases and/or requirements into data analysis and data mapping and consequently data integration routines which involves moving, cleansing and transforming large amount of data between multiple systems.
  • Identifies data sources, provides data flow diagrams and documents source to target mapping and process.
  • Collaborate with the Data Architect to recommend optimal data models for data ingestion and BI developer for analytic reports
  • Facilitate the development of data integration efforts by leading small teams of 2-3 junior developers
  • Architect/design and develop large complex ETL jobs.
  • Document Data Integration Design to facilitate other developers to develop software code.
  • Design, implement and maintain database objects (tables, views, indexes, etc.) and database security.
  • Validate data integration routines by developing and executing test plans and scenarios including data design, tool design, data extract/transform, networks, and hardware.
  • Maintain the data warehouse performance by optimizing batch processing through parallelization, performance tuning etc.
  • Establish methods and procedures for tracking data quality, completeness, redundancy and improvement.
  • Ensure data quality through creation of audit controls, proactive monitoring and data cleansing techniques
  • Must be able to direct junior team members, lead team, assign tasks, monitor progress and report status
  • Execute on POC's with new technologies, drive innovation and new ideas
  • Must be comfortable to create solution design proposals to Architecture Review Board
Requirements:

  • 10+ years of experience in Data Warehousing and Business Intelligence (experience in a MPP considered a plus).
  • 2+ years of experience in Azure Data Factory, SQL VMs, Azure Data Warehouse
  • 5+ Years in BI development leveraging the Microsoft SQL Server or PDW/APS data environments.
  • 5+ years in SSIS and use of Stored Procedures.
  • Strong understanding data modeling (i.e. conceptual, logical and physical model design, experience with Operation Data Stores, Enterprise Data warehouses and Data Marts).
  • Deep understanding of relational database design concepts and SQL programming
  • Experience guiding/mentoring developers with lesser experience.
  • Requires strong analytical, conceptual and problem-solving abilities.
  • Must have worked with several Terabytes of data and a complex data processing environment
  • Strong experience with business intelligence and data warehousing design principles and industry best practices.
  • DevOps Experience is a plus
  • Bachelor's degree - preference in computer/information sciences or business/commerce.
Work Traits:

  • Very driven with a strong sense of urgency to deliver results
  • Self-starter with strong work ethic
  • Strong communications skills - oral and written
  • Passionate about data integration architecture, learning and experimenting with new technologies.
  • Flexible and resilient, handle various demands planned and unplanned
  • Proven ability to handle multiple tasks and projects simultaneously and work in a fast paced environment
  • Problem solver and desire to close issues, pragmatic and realistic with solutions. Loves to dig deep
  • Professional demeanor, working with senior level managers and vendors
  • Ability to work independently under minimal supervision and meet deadlines.
  • Strong sense of accountability, adaptability, flexibility and a sense of urgency.
  • Demonstrated ability to establish priorities, organize and plan work to satisfy established timeframes.
  • Passionate about continuously improving organizational practices.
  • Ability to learn and apply new technologies quickly and self-directed.
  • Ability to prioritize and multi-task across numerous work streams.
 
location: Rolling Meadows, Illinois
job type: Contract
salary: $55 - 70 per hour
work hours: 9am to 5pm
education: Bachelors
 
responsibilities:
Our client is in need of an ETL Architect and Team Lead for a contract-to-hire opportunity in Rolling Meadows, IL:

  • Collaborate with internal customers, prospects and stakeholders, understand and translates business use cases and/or requirements into data analysis and data mapping and consequently data integration routines which involves moving, cleansing and transforming large amount of data between multiple systems.
  • Identifies data sources, provides data flow diagrams and documents source to target mapping and process.
  • Collaborate with the Data Architect to recommend optimal data models for data ingestion and BI developer for analytic reports
  • Facilitate the development of data integration efforts by leading small teams of 2-3 junior developers
  • Architect/design and develop large complex ETL jobs.
  • Document Data Integration Design to facilitate other developers to develop software code.
  • Design, implement and maintain database objects (tables, views, indexes, etc.) and database security.
  • Validate data integration routines by developing and executing test plans and scenarios including data design, tool design, data extract/transform, networks, and hardware.
  • Maintain the data warehouse performance by optimizing batch processing through parallelization, performance tuning etc.
  • Establish methods and procedures for tracking data quality, completeness, redundancy and improvement.
  • Ensure data quality through creation of audit controls, proactive monitoring and data cleansing techniques
  • Must be able to direct junior team members, lead team, assign tasks, monitor progress and report status
  • Execute on POC's with new technologies, drive innovation and new ideas
  • Must be comfortable to create solution design proposals to Architecture Review Board
Requirements:

  • 10+ years of experience in Data Warehousing and Business Intelligence (experience in a MPP considered a plus).
  • 2+ years of experience in Azure Data Factory, SQL VMs, Azure Data Warehouse
  • 5+ Years in BI development leveraging the Microsoft SQL Server or PDW/APS data environments.
  • 5+ years in SSIS and use of Stored Procedures.
  • Strong understanding data modeling (i.e. conceptual, logical and physical model design, experience with Operation Data Stores, Enterprise Data warehouses and Data Marts).
  • Deep understanding of relational database design concepts and SQL programming
  • Experience guiding/mentoring developers with lesser experience.
  • Requires strong analytical, conceptual and problem-solving abilities.
  • Must have worked with several Terabytes of data and a complex data processing environment
  • Strong experience with business intelligence and data warehousing design principles and industry best practices.
  • DevOps Experience is a plus
  • Bachelor's degree - preference in computer/information sciences or business/commerce.
Work Traits:

  • Very driven with a strong sense of urgency to deliver results
  • Self-starter with strong work ethic
  • Strong communications skills - oral and written
  • Passionate about data integration architecture, learning and experimenting with new technologies.
  • Flexible and resilient, handle various demands planned and unplanned
  • Proven ability to handle multiple tasks and projects simultaneously and work in a fast paced environment
  • Problem solver and desire to close issues, pragmatic and realistic with solutions. Loves to dig deep
  • Professional demeanor, working with senior level managers and vendors
  • Ability to work independently under minimal supervision and meet deadlines.
  • Strong sense of accountability, adaptability, flexibility and a sense of urgency.
  • Demonstrated ability to establish priorities, organize and plan work to satisfy established timeframes.
  • Passionate about continuously improving organizational practices.
  • Ability to learn and apply new technologies quickly and self-directed.
  • Ability to prioritize and multi-task across numerous work streams.
 
qualifications:
Our client is in need of an ETL Architect and Team Lead for a contract-to-hire opportunity in Rolling Meadows, IL:

  • Collaborate with internal customers, prospects and stakeholders, understand and translates business use cases and/or requirements into data analysis and data mapping and consequently data integration routines which involves moving, cleansing and transforming large amount of data between multiple systems.
  • Identifies data sources, provides data flow diagrams and documents source to target mapping and process.
  • Collaborate with the Data Architect to recommend optimal data models for data ingestion and BI developer for analytic reports
  • Facilitate the development of data integration efforts by leading small teams of 2-3 junior developers
  • Architect/design and develop large complex ETL jobs.
  • Document Data Integration Design to facilitate other developers to develop software code.
  • Design, implement and maintain database objects (tables, views, indexes, etc.) and database security.
  • Validate data integration routines by developing and executing test plans and scenarios including data design, tool design, data extract/transform, networks, and hardware.
  • Maintain the data warehouse performance by optimizing batch processing through parallelization, performance tuning etc.
  • Establish methods and procedures for tracking data quality, completeness, redundancy and improvement.
  • Ensure data quality through creation of audit controls, proactive monitoring and data cleansing techniques
  • Must be able to direct junior team members, lead team, assign tasks, monitor progress and report status
  • Execute on POC's with new technologies, drive innovation and new ideas
  • Must be comfortable to create solution design proposals to Architecture Review Board
Requirements:

  • 10+ years of experience in Data Warehousing and Business Intelligence (experience in a MPP considered a plus).
  • 2+ years of experience in Azure Data Factory, SQL VMs, Azure Data Warehouse
  • 5+ Years in BI development leveraging the Microsoft SQL Server or PDW/APS data environments.
  • 5+ years in SSIS and use of Stored Procedures.
  • Strong understanding data modeling (i.e. conceptual, logical and physical model design, experience with Operation Data Stores, Enterprise Data warehouses and Data Marts).
  • Deep understanding of relational database design concepts and SQL programming
  • Experience guiding/mentoring developers with lesser experience.
  • Requires strong analytical, conceptual and problem-solving abilities.
  • Must have worked with several Terabytes of data and a complex data processing environment
  • Strong experience with business intelligence and data warehousing design principles and industry best practices.
  • DevOps Experience is a plus
  • Bachelor's degree - preference in computer/information sciences or business/commerce.
Work Traits:

  • Very driven with a strong sense of urgency to deliver results
  • Self-starter with strong work ethic
  • Strong communications skills - oral and written
  • Passionate about data integration architecture, learning and experimenting with new technologies.
  • Flexible and resilient, handle various demands planned and unplanned
  • Proven ability to handle multiple tasks and projects simultaneously and work in a fast paced environment
  • Problem solver and desire to close issues, pragmatic and realistic with solutions. Loves to dig deep
  • Professional demeanor, working with senior level managers and vendors
  • Ability to work independently under minimal supervision and meet deadlines.
  • Strong sense of accountability, adaptability, flexibility and a sense of urgency.
  • Demonstrated ability to establish priorities, organize and plan work to satisfy established timeframes.
  • Passionate about continuously improving organizational practices.
  • Ability to learn and apply new technologies quickly and self-directed.
  • Ability to prioritize and multi-task across numerous work streams.
 
skills: Our client is in need of an ETL Architect and Team Lead for a contract-to-hire opportunity in Rolling Meadows, IL:

  • Collaborate with internal customers, prospects and stakeholders, understand and translates business use cases and/or requirements into data analysis and data mapping and consequently data integration routines which involves moving, cleansing and transforming large amount of data between multiple systems.
  • Identifies data sources, provides data flow diagrams and documents source to target mapping and process.
  • Collaborate with the Data Architect to recommend optimal data models for data ingestion and BI developer for analytic reports
  • Facilitate the development of data integration efforts by leading small teams of 2-3 junior developers
  • Architect/design and develop large complex ETL jobs.
  • Document Data Integration Design to facilitate other developers to develop software code.
  • Design, implement and maintain database objects (tables, views, indexes, etc.) and database security.
  • Validate data integration routines by developing and executing test plans and scenarios including data design, tool design, data extract/transform, networks, and hardware.
  • Maintain the data warehouse performance by optimizing batch processing through parallelization, performance tuning etc.
  • Establish methods and procedures for tracking data quality, completeness, redundancy and improvement.
  • Ensure data quality through creation of audit controls, proactive monitoring and data cleansing techniques
  • Must be able to direct junior team members, lead team, assign tasks, monitor progress and report status
  • Execute on POC's with new technologies, drive innovation and new ideas
  • Must be comfortable to create solution design proposals to Architecture Review Board
Requirements:

  • 10+ years of experience in Data Warehousing and Business Intelligence (experience in a MPP considered a plus).
  • 2+ years of experience in Azure Data Factory, SQL VMs, Azure Data Warehouse
  • 5+ Years in BI development leveraging the Microsoft SQL Server or PDW/APS data environments.
  • 5+ years in SSIS and use of Stored Procedures.
  • Strong understanding data modeling (i.e. conceptual, logical and physical model design, experience with Operation Data Stores, Enterprise Data warehouses and Data Marts).
  • Deep understanding of relational database design concepts and SQL programming
  • Experience guiding/mentoring developers with lesser experience.
  • Requires strong analytical, conceptual and problem-solving abilities.
  • Must have worked with several Terabytes of data and a complex data processing environment
  • Strong experience with business intelligence and data warehousing design principles and industry best practices.
  • DevOps Experience is a plus
  • Bachelor's degree - preference in computer/information sciences or business/commerce.
Work Traits:

  • Very driven with a strong sense of urgency to deliver results
  • Self-starter with strong work ethic
  • Strong communications skills - oral and written
  • Passionate about data integration architecture, learning and experimenting with new technologies.
  • Flexible and resilient, handle various demands planned and unplanned
  • Proven ability to handle multiple tasks and projects simultaneously and work in a fast paced environment
  • Problem solver and desire to close issues, pragmatic and realistic with solutions. Loves to dig deep
  • Professional demeanor, working with senior level managers and vendors
  • Ability to work independently under minimal supervision and meet deadlines.
  • Strong sense of accountability, adaptability, flexibility and a sense of urgency.
  • Demonstrated ability to establish priorities, organize and plan work to satisfy established timeframes.
  • Passionate about continuously improving organizational practices.
  • Ability to learn and apply new technologies quickly and self-directed.
  • Ability to prioritize and multi-task across numerous work streams.

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

easy apply

get jobs in your inbox.

sign up
{{returnMsg}}

related jobs