Warehouse & Data Integration Developer (ETL/ELT, SQL, Data Warehousing & BI)
Not Disclosed•Full-TimeHybrid
location_on21, Mount Hope Drive, Mount Hope, City of Albany, Albany County, New York, 12202, United States
About the Role
We are seeking a Warehouse & Data Integration Developer with over 14 years of experience to lead critical data initiatives within a State Agency environment. This role serves as a bridge between complex business requirements and robust technical solutions, focusing on the design, documentation, and implementation of enterprise data warehousing and master data management strategies.
In this position, you will collaborate closely with business subject matter experts, COTS vendors, and IT teams to define data solutions that enhance operational efficiency and system reliability. Your work will involve orchestrating automated data ingestion, transformation processes, and workflow scheduling to support large-scale enterprise environments. You will also play a key role in modernizing existing database ecosystems, conducting comparative analyses to drive the design of new transactional databases, and applying advanced analytical reasoning to solve complex business challenges.
Application Instructions
If you meet the qualifications outlined above, please submit your application via the link provided on LinkedIn. Kindly do not call the general line to submit your application.
Work location
Work model: Hybrid
21, Mount Hope Drive, Mount Hope, City of Albany, Albany County, New York, 12202, United States
City of Albany, New York
Key Responsibilities
- check_circleDesign and implement enterprise data warehouse solutions with normalized data models
- check_circleDevelop and deploy ETL/ELT pipelines for automated data ingestion and transformation
- check_circleMaintain data integration solutions across heterogeneous systems and BI platforms using SQL
- check_circleConduct comparative database analysis to support design and optimization of database environments
- check_circleImplement error handling, logging, monitoring, and recovery mechanisms for data workflows
- check_circleCollaborate with stakeholders to gather business requirements and define data warehouse solutions
Requirements
- verified14+ years of experience
- verifiedSQL
- verifiedETL/ELT
- verifiedData Warehousing
- verifiedBusiness Intelligence
Similar Job Opportunities
Frequently asked questions about Warehouse & Data Integration Developer (ETL/ELT, SQL, Data Warehousing & BI) at ACS Consultancy Services, Inc
What does a Warehouse & Data Integration Developer (ETL/ELT, SQL, Data Warehousing & BI) at ACS Consultancy Services, Inc do?expand_more
In this Warehouse & Data Integration Developer (ETL/ELT, SQL, Data Warehousing & BI) at ACS Consultancy Services, Inc role, you will design and implement enterprise data warehouse solutions with normalized data models; develop and deploy etl/elt pipelines for automated data ingestion and transformation; maintain data integration solutions across heterogeneous systems and bi platforms using sql; and conduct comparative database analysis to support design and optimization of database environments.
What are the requirements for this Warehouse & Data Integration Developer (ETL/ELT, SQL, Data Warehousing & BI) role?expand_more
To qualify for the Warehouse & Data Integration Developer (ETL/ELT, SQL, Data Warehousing & BI) at ACS Consultancy Services, Inc position, applicants should have: 14+ years of experience; SQL; ETL/ELT; Data Warehousing; and Business Intelligence.
Where is the Warehouse & Data Integration Developer (ETL/ELT, SQL, Data Warehousing & BI) role at ACS Consultancy Services, Inc located?expand_more
Warehouse & Data Integration Developer (ETL/ELT, SQL, Data Warehousing & BI) at ACS Consultancy Services, Inc is based in 21, Mount Hope Drive, Mount Hope, City of Albany, Albany County, New York, 12202, United States. This is a hybrid role.
Is this Warehouse & Data Integration Developer (ETL/ELT, SQL, Data Warehousing & BI) job remote, hybrid, or on-site?expand_more
ACS Consultancy Services, Inc has listed this Warehouse & Data Integration Developer (ETL/ELT, SQL, Data Warehousing & BI) role as hybrid.
How much experience is required for this Warehouse & Data Integration Developer (ETL/ELT, SQL, Data Warehousing & BI) role?expand_more
Warehouse & Data Integration Developer (ETL/ELT, SQL, Data Warehousing & BI) at ACS Consultancy Services, Inc typically requires 14+ years of relevant experience at the lead level.
What skills do you need for the Warehouse & Data Integration Developer (ETL/ELT, SQL, Data Warehousing & BI) role at ACS Consultancy Services, Inc?expand_more
Key skills for Warehouse & Data Integration Developer (ETL/ELT, SQL, Data Warehousing & BI) at ACS Consultancy Services, Inc include Etl; Elt; SQL; Data Warehousing; Bi; Data Warehouse; Enterprise Application Integration; and Master Data Management.
What category does the Warehouse & Data Integration Developer (ETL/ELT, SQL, Data Warehousing & BI) role belong to?expand_more
Warehouse & Data Integration Developer (ETL/ELT, SQL, Data Warehousing & BI) at ACS Consultancy Services, Inc is part of the it job category on Recrutus.
About ACS Consultancy Services, Inc
ACS Consultancy Services, Inc operates within the IT services and IT consulting industry, based in Latham, New York. The firm specializes in delivering comprehensive information technology solutions and strategic consulting support. These services are specifically tailored to meet the complex needs of public sector entities across the region. The organization functions as a small business and holds certification as a Minority and Women-Owned Business Enterprise (MWBE) by both New York State and New York City. This status underscores a commitment to diversity and inclusion within the technology consulting landscape.
Browse more roles: All ACS Consultancy Services, Inc jobs, it jobs on Recrutus.