Sr IT Operations / Enterprise Data & Analytics - Hybrid

Simple Solutions•Wilmington, DE

8d•Hybrid

About The Position

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.

Requirements

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

Nice To Haves

Experience with IQMS

Responsibilities

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.