Data Engineer

Nisum; United States; Remote; USD 90,000 - 130,000; Full time

Job summary

Nisum is seeking a Data Engineer to design, develop, and maintain scalable data integration and warehousing solutions. You will work with Informatica, SQL, Python, and Azure Data Factory to move data from multiple sources into the data warehouse and support BI deliverables.

You will collaborate with Data Engineers, BI developers, and business stakeholders to ensure data quality, reliability, and timely delivery of insights.

Qualifications

• Experience designing and maintaining ETL pipelines and data warehousing solutions.
• Strong SQL skills and proficiency with MSSQL.
• Hands-on with Azure Data Factory and Python for data processing.

Responsibilities

• Design, develop, and maintain robust ETL/data integration pipelines using Informatica.
• Develop and maintain data warehouse and data lake solutions.
• Design and implement data models to support analytical and reporting requirements.
• Develop, schedule, monitor, and troubleshoot Informatica workflows and ETL processes.
• Develop complex SQL queries, stored procedures, transformations, and data validation processes using SQL/MSSQL.
• Work with Azure Data Factory (ADF) for data integration and pipeline orchestration.
• Develop data processing solutions using Python and PySpark where required.
• Implement data quality, validation, reconciliation, and data cleansing processes.
• Identify and resolve data pipeline failures, performance issues, and data quality problems.

Skills

Informatica

ETL

Data Warehousing

SQL

Python

Azure Data Factory

PySpark

Data quality

Job description

Data Engineer

Department:Software & Data Services (SDS)

Role Synopsis

The Data Engineer will be responsible for developing and maintaining our data infrastructure, as well as developing and implementing data pipelines to move data from our various sources into our data warehouse, leveraging Microsoft Fabric and related technologies. The Data Engineer will work closely with the other Data Engineers, Power BI Developers, and to help deliver data projects and BAU tasks.

Job Summary

We are looking for an experienced Data Engineer with strong hands‑on expertise in Informatica, ETL, Data Warehousing, SQL, Python, and Azure Data Factory (ADF).

The Data Engineer will be responsible for designing, developing, and maintaining scalable data integration solutions and data pipelines. The role involves working with data from multiple sources, implementing data quality processes, supporting data warehouse solutions, and collaborating with Data Engineers, BI Developers, and business stakeholders to deliver reliable and high‑quality data solutions.

Key Responsibilities

• Design, develop, and maintain robust ETL/data integration pipelines using Informatica.
• Develop and maintain data warehouse and data lake solutions.
• Design and implement data models to support analytical and reporting requirements.
• Develop, schedule, monitor, and troubleshoot Informatica workflows and ETL processes.
• Develop complex SQL queries, stored procedures, transformations, and data validation processes using SQL/MSSQL.
• Work with Azure Data Factory (ADF) for data integration and pipeline orchestration.
• Develop data processing solutions using Python and PySpark where required.
• Implement data quality, validation, reconciliation, and data cleansing processes.
• Identify and resolve data pipeline failures, performance issues, and data quality problems.