Data Engineer (SQL Server/SSIS + AWS)
Contract Corp To Corp
Contract W2
Contract Independent
24 Months
No Travel Required
On-site
Depends on Experience
Nineteen Eleven Solutions
Fitment
Dice Job Match Score™
🫥 Flibbertigibetting...
Job Details
Skills
- .NET
- Amazon S3
- Amazon Web Services
- Business Intelligence
- API
- Data Engineering
- Data Flow
- Data Governance
- Data Integration
- Data Lake
- Data Loading
- Data Processing
- Data Quality
- Data Warehouse
- Design Review
- ELT
- Extract, Transform, Load
- Microsoft SQL Server
- Microsoft SSIS
- Python
- SQL
- Git
- Orchestration
- Query Optimization
- Bitbucket
Summary
Job Title: Data Engineer (SQL Server/SSIS + AWS)
Location: Memphis, TN (Local candidates only)
Location: Memphis, TN (Local candidates only)
Duration: 12+ Months Contract
A Software/Data Engineer (SQL Server/SSIS + AWS) 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
REQUIREMENTS
- .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
Technical Skillset
- 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
Top Skills Required
- 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
Please anwere Screening questions: (Add these on top of resume to receive first preference)
Q1: Walk me through how you''d design an SSIS package to handle incremental loads with change tracking, versus a full load. What''s your trigger for choosing one over the other?
Q2: A pipeline that normally runs in 10 minutes is now taking 2 hours. How do you troubleshoot it in SQL Server?
Q3: Give me a specific example of a data pipeline task you built in .NET, and a separate one in Python. What made you choose one language over the other for each?
Q4: Describe a time you used Glue, Lambda, or Athena in a data pipeline. What problem were you solving, and why that service instead of an alternative?
Q5: How would you evaluate a new pipeline design against the AWS Well-Architected Framework? Which pillar tends to get overlooked?
Q6:"How do you validate that a data load completed correctly — not just that it ran without errors, but that the data itself is right?
Q7: Tell me about a pipeline failure you''ve dealt with in production — what broke, how did you find out, and how did you fix it long-term (not just patch it)?
Q8: Have you used DBT? Walk me through a model you built.
Q9: Have you worked with connector tools like CData, Fivetran, or similar? What was the pipeline it powered?
Q10: How do you approach data lineage or documenting where data comes from and who owns it?
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
- Dice Id: 90925516
- Position Id: 9030792
- Posted 2 days ago
Company Info
About Nineteen Eleven Solutions
Nineteen Eleven Solutions: Your Trusted Business Consulting Partner
At Nineteen Eleven Solutions, we provide tailored consulting services to help your business thrive in a competitive landscape. Our expertise spans multiple industries, ensuring that we deliver the right solutions for your unique needs.
Nineteen Eleven Solutions is dedicated to offering exceptional business consulting services. As a certified Minority Business Enterprise (MBE), we are committed to enhancing diversity-spend initiatives and delivering prompt, responsive solutions. Our core principles include identifying the best solutions, collaborating with clients we admire, and treating everyone with respect and integrity. Our mission is to empower businesses with innovative solutions and strategic insights, partnering with them to achieve their goals.
Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs