What are the responsibilities and job description for the Senior Data Integration & ETL Engineer position at Jobs via Dice?
Location : One Day in a week on site Albany NY
Duration : Long-term Contract
Client : Government Agency
Start Date : ASAP
About The Role
We are seeking a highly skilled Senior Data Integration & ETL Engineer to support a large-scale data analytics and data interchange initiative for a government client. The ideal consultant will have deep experience building and maintaining complex data pipelines, integrating diverse data sources, and supporting analytics environments.
This role requires a strong foundation in ETL development, data modeling, SQL, and data interchange systems. Candidates must meet all minimum qualifications to be considered.
Minimum Qualifications (Required)
Candidates must meet all of the following:
(Master s or PhD may substitute)
Preferred Qualifications (Nice To Have)
P1 Python scripting experience
P2 Tableau Server Administration (1 year)
P3 Customer-facing experience in data validation, troubleshooting, or requirements gathering
P4 Statistics coursework or 1 year using statistics professionally
P5 SQL or PL/SQL database development
P6 ETL pipelines supporting Tableau analytics
Key Responsibilities
P7 ETL experience supporting a government data analytics program
Duration : Long-term Contract
Client : Government Agency
Start Date : ASAP
About The Role
We are seeking a highly skilled Senior Data Integration & ETL Engineer to support a large-scale data analytics and data interchange initiative for a government client. The ideal consultant will have deep experience building and maintaining complex data pipelines, integrating diverse data sources, and supporting analytics environments.
This role requires a strong foundation in ETL development, data modeling, SQL, and data interchange systems. Candidates must meet all minimum qualifications to be considered.
Minimum Qualifications (Required)
Candidates must meet all of the following:
(Master s or PhD may substitute)
- M1 Education
- Bachelor s degree in Computer Science, Information Technology, or a related field
- M2 Data Interchange Systems (4 years)
- Flat files
- Direct database connections
- XML transactions
- Multiple heterogeneous data sources
- M3 ETL Tools (4 years)
- Informatica, Talend, SSIS, DataStage, Pentaho
- Azure Data Factory, AWS Glue, or similar
- M4 Data Modeling (4 years)
- Logical and physical data models
- Dimensional models (star/snowflake)
- Data warehouse schemas
- M5 Analytics-Focused ETL (4 years)
- Data analytics
- BI environments
- Data warehouses or analytical datasets
- M6 SQL (4 years)
- Complex joins
- Stored procedures
- Query optimization
- Data transformations
Preferred Qualifications (Nice To Have)
P1 Python scripting experience
P2 Tableau Server Administration (1 year)
P3 Customer-facing experience in data validation, troubleshooting, or requirements gathering
P4 Statistics coursework or 1 year using statistics professionally
P5 SQL or PL/SQL database development
P6 ETL pipelines supporting Tableau analytics
Key Responsibilities
P7 ETL experience supporting a government data analytics program
- Develop and maintain ETL pipelines to support analytics and reporting
- Integrate data from diverse sources including flat files, XML, and direct DB connections
- Design and optimize data models for analytics
- Collaborate with business users on data validation and requirements
- Support data quality, data governance, and troubleshooting efforts
- Work with BI teams to ensure data readiness for dashboards and reporting
- ETL development
- SQL (advanced)
- Data modeling
- Data integration
- XML, flat files, relational databases
- Analytics-focused data engineering