ETL Developer

1 day ago

Albany, New York, United States redShift Full time $70,000 - $80,000 per year


Position Title: ETL Developer
 Location: Near Albany, NY (onsite) Employment Type: Full-Time Salary: $85,000 - $100,000
Overview Our client is seeking a skilled ETL Developer to design, build, and maintain data integration solutions that support business intelligence and operational reporting. This role is responsible for developing and optimizing ETL (Extract, Transform, Load) processes, ensuring data integrity, and collaborating with technical and business teams to deliver high-quality, reliable data pipelines. The ideal candidate has a strong background in SQL, data modeling, and performance tuning, along with hands-on experience using modern ETL tools and techniques.
Key Responsibilities ETL Development & Integration

  • Design, develop, and maintain ETL pipelines to extract data from multiple structured and unstructured sources.
  • Implement both incremental and full data load processes while maintaining high standards for data quality and consistency.
  • Build reusable ETL components to improve efficiency and standardization across data workflows.
Data Modeling & Performance Optimization
  • Support the development and optimization of data warehouse and operational data store models.
  • Apply indexing, partitioning, and other performance techniques to ensure efficient data access.
  • Monitor and fine-tune ETL performance through query optimization, parallel processing, and process automation.
Data Quality & Validation
  • Develop and implement data validation, error handling, and reconciliation procedures to ensure data accuracy and completeness.
  • Collaborate with data governance and analytics teams to support data quality and compliance initiatives.
Collaboration & Documentation
  • Partner with analysts, developers, and business stakeholders to gather data requirements and translate them into technical specifications.
  • Maintain detailed documentation for ETL workflows, data mappings, and system dependencies.
  • Contribute to knowledge sharing and cross-functional collaboration within the data engineering team.


Qualifications Education:

  • Bachelor's degree in Computer Science, Data Science, Information Systems, or a related field (or equivalent work experience).
Experience:
  • 2-5 years of experience developing and maintaining ETL processes in a data-centric environment.
Technical Skills:
  • SQL / T-SQL: Advanced proficiency in writing, optimizing, and troubleshooting complex queries.
  • ETL Tools: Experience with one or more tools such as SSIS, Azure Data Factory, Informatica, Pentaho, or similar platforms.
  • Databases: Strong understanding of relational and dimensional database concepts, query optimization, and schema design.
  • Data Warehousing: Familiarity with star schema and dimensional modeling concepts.
  • Data Quality: Knowledge of data cleansing, validation, and profiling techniques.
  • Problem Solving: Ability to diagnose and resolve complex data issues with attention to detail and analytical rigor.
  To see a full listing of all our open positions, please visit:
    redShift Recruiting is the region's premier recruiting agency with over 100 years of combined experience in the recruiting field. We specialize in permanent, temporary, and temp-to-hire positions. Our superior service combined with our highly qualified and carefully selected bank of candidates sets us apart.    

  • ETL Developer

    3 days ago

    Albany, New York, United States Brilliant Infotech Inc. Full time $80,000 - $140,000 per year

    Role:ETL DeveloperLocation:Albany, NY (On-Site / Hybrid)Type:Full-Time | Direct HireJob Description:Seeking an experienced ETL Developer skilled in Azure and Microsoft data technologies to design, build, and maintain end-to-end data integration pipelines. You'll ensure high data quality, performance, and reliability while supporting analytics and reporting...

  • Informatica Developer With BDE

    3 days ago

    Albany, New York, United States Atria Group Full time $60,000 - $90,000 per year

    Company Description We specialize in Staffing, Consulting, Software Development, and Training along with IT services to small to medium size companies. AG's primary objective is to help companies maximize their IT resources and meet the ever-changing IT needs and challenges.In addition, AG offers enterprise resource planning and enterprise application...

  • Data Engineer

    3 days ago

    Albany, New York, United States NEW YORK EHEALTH COLLABORATIVE INC Full time $80,000 - $120,000

    Job Details Job Location:    Albany or NYC Office - Albany or New York, NY Position Type:    Full Time Education Level:    4 Year Degree Salary Range:    $ $ Salary Travel Percentage:    Occasional Job Shift:    M - F 9am - 5pm DescriptionNew York eHealth Collaborative – Data EngineerNew York eHealth Collaborative (NYeC) is a...

  • Information Technology Specialist

    2 days ago

    Albany, New York, United States LiRo-Hill Full time $60,000 - $72,000 per year

    Overview:We're looking for a SQL Information Technology Specialist in Albany, NYCome join our team We are looking to build services and capabilities through the growth of our key asset- our staff. Ranked among the nation's top A/E firms by Engineering News-Record, LiRo-Hill provides construction management, engineering, environmental, architectural, and...

  • Information Technology Specialist

    2 days ago

    Albany, New York, United States The LiRo Group Full time $60,000 - $72,000 per year

    We're looking for aSQL Information Technology Specialistin Albany, NYCome join our team We are looking to build services and capabilities through the growth of our key asset- our staff. Ranked among the nation's top A/E firms by Engineering News-Record, LiRo-Hill provides construction management, engineering, environmental, architectural, and program...

  • Information Technology Specialist 4

    3 days ago

    Albany, New York, United States State of New York - Information Technology Services, Office of Full time $60,000 - $120,000 per year

    The duties that the incumbent of the vacancy will be expected to perform. Duties Description Under the direction of a Manager Information Technology Services 1, SG27, within the Dedicated Support team, NYS DMV portfolio, the resource will work under an ITS manager within the Data Managment team supporting the DMV Modernization DQ Implementation Project and...

  • Information Technology Specialist 2

    4 days ago

    Albany, New York, United States New York State Insurance Fund (NYSIF) Full time

    Duties DescriptionResponsibilities Include, But Are Not Limited To:Analyze and gather requirements for software systems.Design, develop, and modify relational and multidimensional database structures and data flows.Design, develop, and modify database procedures/packages to perform data extraction, transformation, and loading into Data Warehouse.Identify and...

  • Information Technology Specialist 2 Programming

    2 days ago

    Albany, New York, United States State of New York - Information Technology Services, Office of Full time $90,000 - $120,000 per year

    The duties that the incumbent of the vacancy will be expected to perform. Duties Description Under the direction of an Information Technology Specialist 4, SG25, within the Dedicated Support Division for the Office of Temporary and Disability Assistance (OTDA), the Information Technology Specialist 2 (Programming) incumbent will perform application and...

  • Manager Information Technology Services 1

    4 days ago

    Albany, New York, United States State of New York - Information Technology Services, Office of Full time $120,000 - $180,000 per year

    The duties that the incumbent of the vacancy will be expected to perform. Duties Description ITS provides operational support to state agencies on a 24x7x365 basis; some positions may be required to provide this critical service at any time.Under the direction of an Assistant Director Information Technology Services 1, M-4, within the Chief Technology...

  • ETL Developer

    4 weeks ago

    Albany, United States Red Shift Full time

    Position Title: ETL Developer Location: Near Albany, NY (onsite) Employment Type: Full-Time Salary: $85,000 - $100,000 Overview Our client is seeking a skilled ETL Developer to design, build, and maintain data integration solutions that support business intelligence and operational reporting. This role is responsible for developing and optimizing ETL...

  • ETL Developer

    2 days ago

    Albany, NY, United States Mindlance Full time

    Provide a short description of the Position: These Data warehouse and business intelligence positions are required to support the continued development and maintenance of DW/BI solutions in response to critical agency requirements for the WCB. These positions will also develop and maintain Pentaho ETL solutions, Pentaho BI schemas, executive dashboards and...

  • ETL Developer

    1 week ago

    Albany, NY, United States Mindlance Full time

    Provide a short description of the Position: These Data warehouse and business intelligence positions are required to support the continued development and maintenance of DW/BI solutions in response to critical agency requirements for the WCB. These positions will also develop and maintain Pentaho ETL solutions, Pentaho BI schemas, executive dashboards and...

  • ETL Data Warehouse Lead

    4 weeks ago

    Albany, United States InterSources Full time

    ETL Data Warehouse Lead Location: Albany, NY, 12226 Duration: 2 years Contract Position Requirements 84 Months experience developing and testing query solutions using Oracle PL/SQL query 84 Months UNIX Shell Scripting experience 84 Months ETL design/Data Warehouse development experience using SQL and PL/SQL programming/ IBM DataStage 84 Months experience...

  • ETL Data Warehouse Lead

    2 weeks ago

    Albany, United States Staffing Full time

    ETL Data Warehouse LeadLocation: Albany, NY, 12226 Duration: 2 years ContractPosition Requirements:84 months experience developing and testing query solutions using Oracle PL/SQL query84 months UNIX Shell Scripting experience84 months ETL design/Data Warehouse development experience using SQL and PL/SQL programming/ IBM Da...

  • Data Warehouse Developer — Oracle BI/ETL

    1 week ago

    City of Albany, United States Elegant Enterprise-Wide Solutions, Inc. Full time

    A leading IT consulting firm is seeking a Mid-Senior level Database Developer to maintain and develop SQL and PL/SQL for the PARIS Application, enhance ETL processes, and perform database modeling for both OLTP and OLAP systems. Candidates should have at least five years of experience in Oracle database development and three years in OBIEE. This role is...

  • ETL developer

    2 weeks ago

    Albany, NY, United States Mindlance Full time

    Provide a short description of the Position:This position will design and implement software solutions and ensure current and new technologies are effectively integrated to fulfill the business needs. Provide a list of the day to day tasks to be performed by the Selected Candidate:This individual will be expected to participate in the following activities:...

  • OBIEE Developer

    3 days ago

    Albany, United States V Group Inc. Full time

    For more details, please connect with Afra Aleem at 609-371-5400 Ext 112 or email her at afraa@vgroupinc.com **Local to NY or nearby candidates required (5 days Onsite role)**Job Title: OBIEE DeveloperDuration: 05 YearsStart Date: ASAPLocation: Albany ,New York (onsite)Position Type: ContractInterview Type: In person/WebCamCeipal ID: SNY_OBI002_AF Required...

  • Data Warehouse Developer

    3 days ago

    Albany, United States Elegant Enterprise-Wide Solutions, Inc. Full time

    About this Position:Job Title: Data Warehouse DeveloperDuties include:Maintaining and developing SQL and PL/SQL for the PARIS Application.Maintaining, converting, and developing all BI Publisher Reports for the PARIS application.Performing database modeling in the context of an online transaction processing (“OLTP”) system.Performing database modeling in...

  • Data Warehouse Developer

    1 day ago

    Albany, United States Elegant Enterprise-Wide Solutions, Inc. Full time

    About this Position:Job Title: Data Warehouse DeveloperDuties include:Maintaining and developing SQL and PL/SQL for the PARIS Application.Maintaining, converting, and developing all BI Publisher Reports for the PARIS application.Performing database modeling in the context of an online transaction processing (“OLTP”) system.Performing database modeling in...