Sr IT Operations / Enterprise Data & Analytics - Hybrid
contract•Wilmington
About this role
Data Platform Engineer
Duration: 6-Month Contract to Hire
Location: Wilmington, DE (Hybrid – Onsite 4 days/week)
Department: IT Operations / Enterprise Data & Analytics
Healthcare Company
Position Overview
We are seeking a Data Platform Engineerwith 8–10 years of hands-on experience in SQL Server development, SQL Server administration, ETL using Microsoft Visual Studio, Stored Procedures, schema design, and enterprise data integration. The role includes building ETL pipelines, designing and maintaining SQL Server databases, implementing dimensional models, and supporting secure, reliable data flows across the organization. Responsibilities include ingesting data from diverse sources and delivering processed data to downstream applications via direct integrations or structured flat file outputs.
Key Technical Skills
Data Platform Development & Support
Duration: 6-Month Contract to Hire
Location: Wilmington, DE (Hybrid – Onsite 4 days/week)
Department: IT Operations / Enterprise Data & Analytics
Healthcare Company
Position Overview
We are seeking a Data Platform Engineerwith 8–10 years of hands-on experience in SQL Server development, SQL Server administration, ETL using Microsoft Visual Studio, Stored Procedures, schema design, and enterprise data integration. The role includes building ETL pipelines, designing and maintaining SQL Server databases, implementing dimensional models, and supporting secure, reliable data flows across the organization. Responsibilities include ingesting data from diverse sources and delivering processed data to downstream applications via direct integrations or structured flat file outputs.
Key Technical Skills
- SQL Server Development & Administration (installation, configuration, tuning, maintenance)
- T?SQL Expertise (Stored Procedures, functions, triggers, complex queries, performance tuning)
- ETL Development using Microsoft Visual Studio (SSIS or equivalent Visual Studio-based workflows)
- Database Design & Architecture (schemas, tables, indexes, partitions, constraints)
- User/Role Administration & Security Management (permissions, access control, least privilege)
- Data Ingestion from diverse sources (databases, APIs, CSV, Excel, JSON, XML, SFTP)
- Downstream Data Delivery (direct integrations, scheduled flat?file exports)
- Dimensional Modelling (facts, dimensions, star/snowflake schemas)
- Data Validation & Quality Controls
- Troubleshooting of SQL Server, ETL jobs, pipelines, performance issues, and integration failures
- Working knowledge of Cognos (reporting objects, data structures, SQL behind models)
- Experience with IQMS (advantage but NOT required)
Data Platform Development & Support
- Build, configure, and maintain SQL Server databases, schemas, indexing, and data structures.
- Develop and optimize Stored Procedures, T?SQL logic, and ETL components using Visual Studio.
- Manage data ingestion from databases, APIs, and file-based sources (CSV, Excel, JSON).
- Deliver processed data to downstream systems via direct integrations or flat?file exports.
- Monitor and troubleshoot ETL jobs, scheduled tasks, and automated workflows.
- Investigate discrepancies, system issues, and integration failures to ensure data reliability.
- Support operational and financial month?end data processes.
- Maintain enterprise dataflows, transformation logic, and data validation checks.
- Design and maintain dimensional models, including fact and dimension tables.
- Ensure modeling consistency for reporting and analytical usage.
- Maintain data models and scheduled reporting workflows.
- Support Excel-based financial and operational reporting processes.
- Manage SQL Server roles, users, permissions, and access controls.
- Maintain logs, backup reports, and audit trails.
- Conduct security and access?compliance reviews.
- Maintain documentation for dataflows, ETL processes, integrations, and operational procedures.
- Provide periodic project updates, issue logs, and summaries to leadership.
- 8–10 years of hands-on experience with SQL Server development, administration, and ETL using Microsoft Visual Studio.
- Strong T?SQL skills, Stored Procedure development, query tuning, and schema design.
- Experience implementing and managing SQL Server security frameworks.
- Strong background in Dimensional Modelling (fact/dimension design, star/snowflake schemas).
- Proven ability to ingest data from multiple source systems and deliver to downstream systems via integrations or flat files.
- Experience supporting enterprise data warehouses or reporting environments.
- Strong analytical, troubleshooting, communication, and documentation capabilities.
- Knowledge in Cognos/Power BI .
What you'll do
- The Data Platform Engineer will build, configure, and maintain SQL Server databases, develop and optimize ETL components, and manage data ingestion from various sources. They will also monitor and troubleshoot ETL jobs and ensure data reliability across the organization.
About Simple Solutions
Simple Solutions is a Management System Consultancy Company, which has since its inception given seed to innovate concepts in developing integrated management system development for service & manufacturing sectors in the country.
Our area of expertise includes the following:
Management System Consultancy:
We have extensive expertise in providing Management System Consultancy in the following sectors applicable for all categories of industry.
• Quality Management System - ISO 9001:2000
• Environmental Management System - ISO 14001: 2004
• Occupational Health & Safety Management System - OSHAS 18001:2007
• Food Safety Management System – ISO 22000:2005
• Information Security Management System – ISO 27001
• Social Accountability Standard - SA 8000
• Corporate Social Responsibility Systems – CSR
• Ethical Standards Management System Implementation for Vendor Enlistment.
• Hazard Analysis & Critical Control Point (HACCP) - especially for food
processing industry
• Current Good Manufacturing Practices (cGMP) standards for food & pharmaceutical industries.
Product Certification System & Country Specific System Certification for Exporters
• Safe Quality Food (SQF 2000CM) - Product Certification for Food Industry from
Food Marketing Institute, USA
• British Retail Consortium (BRC) Certification for Food Exporters to UK.
• International Food Standard (IFS) Certification for Food Exporters.
Environmental Impact Assessment Studies & Statutory Environmental Clearance
Ready to join Simple Solutions?
Take the next step in your career journey
Frequently Asked Questions
What does a Sr IT Operations / Enterprise Data & Analytics - Hybrid do at Simple Solutions?
As a Sr IT Operations / Enterprise Data & Analytics - Hybrid at Simple Solutions, you will: the Data Platform Engineer will build, configure, and maintain SQL Server databases, develop and optimize ETL components, and manage data ingestion from various sources. They will also monitor and troubleshoot ETL jobs and ensure data reliability across the organization..
Is the Sr IT Operations / Enterprise Data & Analytics - Hybrid position at Simple Solutions remote?
The Sr IT Operations / Enterprise Data & Analytics - Hybrid position at Simple Solutions is based in Wilmington, Delaware, United States. Contact the company through Clera for specific work arrangement details.
How do I apply for the Sr IT Operations / Enterprise Data & Analytics - Hybrid position at Simple Solutions?
You can apply for the Sr IT Operations / Enterprise Data & Analytics - Hybrid position at Simple Solutionsdirectly through Clera. Click the "Apply Now" button above to start your application. Clera's AI-powered platform will help match your profile with this opportunity and guide you through the application process.