Remote Software Data Engineer
Long term contract
Must Have: Data ingestion, ETL/ELT, replication, SQL Server, SSIS, AWS data services, and production support.
A Software Engineer, Business Intelligence Data Movement provides technical leadership while actively contributing to the design, development, and support of complex data ingestion pipelines and platform services. This role works across multiple systems to ensure reliable data movement, system performance, and production stability, while contributing to architectural decisions and assisting other engineers. Explores emerging technologies and anticipates industry disruptions. Documents and demonstrates solutions by developing documentation, flowcharts, layouts, diagrams, charts, code comments, and conforms to coding standards.
ESSENTIAL JOB FUNCTIONS
Long term contract
Must Have: Data ingestion, ETL/ELT, replication, SQL Server, SSIS, AWS data services, and production support.
A Software Engineer, Business Intelligence Data Movement provides technical leadership while actively contributing to the design, development, and support of complex data ingestion pipelines and platform services. This role works across multiple systems to ensure reliable data movement, system performance, and production stability, while contributing to architectural decisions and assisting other engineers. Explores emerging technologies and anticipates industry disruptions. Documents and demonstrates solutions by developing documentation, flowcharts, layouts, diagrams, charts, code comments, and conforms to coding standards.
ESSENTIAL JOB FUNCTIONS
- Design, build, and maintain data ingestion pipelines and synchronization processes (full load, incremental, and change tracking).
- Develop and support SQL Server-based and API-based data pipelines to ingest data into centralized data platforms.
- Troubleshoot and resolve production incidents, including data issues, pipeline failures, and performance bottlenecks.
- Contribute to system design decisions, including tradeoffs for scalability, performance, reliability, and cost Implement and maintain monitoring, alerting, and validation to ensure data quality and pipeline reliability.
- Collaborate with cross-functional teams (source systems, data transformation, architecture) to ensure end-to-end data flow success.
- Participate in code reviews, design reviews, and best practice adoption
- .NET-based data processing systems and Python for data engineering use cases
- Familiarity with AWS data services (S3, Lambda, Glue, Athena, CloudWatch/CloudTrail) and cloud-native pipeline design
- Experience evaluating architectures against the AWS Well-Architected Framework
- Data validation, reconciliation, and data quality checks
- Ability to design monitoring, alerting, and observability for pipelines and data systems
- Experience with source control and release management workflows (Git/Bitbucket)
- Familiarity with modern data transformation tools such as DBT (Data Build Tool)
- Data integration platforms such as CData or similar connector-based ingestion tools
- Awareness of data governance, lineage, and ownership practices
- Experience with data ingestion and replication patterns (full load, incremental, CDC/change tracking)
- Hands-on experience building and supporting ETL/ELT pipelines within a data lake or data warehouse ecosystem
- Experience developing and operating SSIS-based data movement pipelines and similar orchestration tools
- Design, build, and maintain data ingestion pipelines and synchronization processes (full load, incremental, and change tracking)
- Strong SQL and SQL Server expertise (query tuning, indexing, performance troubleshooting, blocking/locking analysis) and SSIS
- Familiarity with AWS data services (S3, Lambda, Glue, Athena, CloudWatch/CloudTrail) and cloud-native pipeline design
Remote Software Data Engineer - SSIS/Ingestion/AWS Services in Remote at Unknown Company
This position is listed as contract and able to be worked remotely.