Senior Database Engineer (SSIS)
Core
Design, develop, and maintain enterprise data integration solutions and data warehouses to support business intelligence, analytics, and operational reporting.
Role type
Senior Data Warehouse Developer (SSIS/SQL Server)
Builds
Enterprise data warehouses, data marts, ETL pipelines, and optimized SQL reporting structures.
Domain
Life Sciences / Data Engineering
Required skills
SSIS package development, T-SQL programming, data modeling (Star/Snowflake schemas), SQL Server performance tuning, ETL/ELT methodologies, data governance, Azure DevOps/Git
Preferred skills
Azure Data Factory, Azure SQL Database/Synapse Analytics, Power BI semantic models, data lake architectures
Technologies
Microsoft SQL Server 2016/2019/2022, SSIS, SSRS, T-SQL, Azure DevOps, Git, Power BI, Tableau
Responsibilities
Design and develop SSIS packages for data extraction, transformation, and loading; write complex T-SQL queries and stored procedures; design and maintain dimensional data models; optimize database performance through indexing and query tuning; implement data validation and governance processes; support BI tools and ad-hoc analysis requests.
Seniority
Senior, hands-on IC