What are the responsibilities and job description for the Senior Data Integration & ETL Engineer position at Kriscon?
Senior Data Integration & ETL Engineer
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:
? M1 Education
- Bachelor s degree in Computer Science, Information Technology, or a related field
(Master s or PhD may substitute)
? M2 Data Interchange Systems (4 years)
Experience developing and maintaining data interchange systems involving:
- Flat files
- Direct database connections
- XML transactions
- Multiple heterogeneous data sources
? M3 ETL Tools (4 years)
Hands-on experience with ETL tools such as:
- Informatica, Talend, SSIS, DataStage, Pentaho
- Azure Data Factory, AWS Glue, or similar
? M4 Data Modeling (4 years)
Experience designing:
- Logical and physical data models
- Dimensional models (star/snowflake)
- Data warehouse schemas
? M5 Analytics-Focused ETL (4 years)
Experience developing ETL pipelines specifically to support:
- Data analytics
- BI environments
- Data warehouses or analytical datasets
? M6 SQL (4 years)
Strong SQL experience including:
- Complex joins
- Stored procedures
- Query optimization
- Data transformations
Note: Candidates who do not meet all minimum qualifications cannot be considered.
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
P7 ETL experience supporting a government data analytics program
Key Responsibilities
- 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
Required Skills
- ETL development
- SQL (advanced)
- Data modeling
- Data integration
- XML, flat files, relational databases
- Analytics-focused data engineering