Senior Data Engineer ( T-SQL & SSIS,Data Warehousing & ETL Specialist)

Job Description

Job Summary Synechron is seeking a highly skilled Senior Data Engineer specializing in T-SQL and SSIS to lead and advance our data integration and warehousing initiatives. In this role, you will design, develop, and optimize complex ETL processes and database solutions to support enterprise data needs. Your expertise will enable efficient data flow, ensure data integrity, and facilitate actionable insights, contributing to our organizations commitment to data-driven decision-making and operational excellence. Software Requirements Required Skills: Proficiency in SQL Server, advanced T-SQL querying, stored procedures, functions, and scripting Expertise in SQL Server Integration Services (SSIS), including design, deployment, and troubleshooting Deep understanding of data warehousing concepts, schema design, and ETL best practices Experience in performance tuning, query optimization, and troubleshooting SQL and SSIS packages Hands-on experience with database security, compliance, and data masking standards Familiarity with source system analysis and complex data migration Preferred Skills: Experience with cloud platforms (Azure Data Factory, AWS Glue) Knowledge of Azure SQL, Amazon RDS or other cloud-based data services Experience with scripting languages like PowerShell or Python for automation Overall Responsibilities Design, develop, and maintain robust ETL workflows using SSIS to meet diverse data integration requirements Write optimized, scalable T-SQL queries, stored procedures, and functions aligned with data quality standards Develop and manage data warehouse schemas, tables, and relationships to support reporting and analytics Ensure data accuracy, security, and compliance across all data processes Collaborate closely with business analysts and other stakeholders to understand data requirements and translate them into technical solutions Troubleshoot and resolve performance issues in SQL Server and SSIS packages Document data workflows, schemas, and data mappings to support ongoing maintenance and audits Participate in code reviews, performance tuning, and implementing best practices for ETL and database management Support data migration projects and facilitate seamless data transfers between systems Technical Skills (By Category) Programming Languages: Essential: T-SQL, SQL Preferred: PowerShell, Python, or similar scripting languages for automation and scripting Databases & Data Management: Essential: SQL Server (2016 or higher), relational data modeling, ETL processes Preferred: Azure SQL, Amazon RDS, or other cloud-based databases Frameworks & Libraries: Essential: SSIS (SQL Server Integration Services) packages and components Preferred: Data analysis libraries (e.g., Pandas, Power BI integrations) Development Tools & Methodologies: Essential: SQL Server Management Studio (SSMS), Visual Studio, SQL Server Data Tools (SSDT), version control (Git) Preferred: Azure Data Factory, DevOps pipelines, automated deployment tools Design & Architecture: Data warehouse schema design (star schema, snowflake) Data flow and process automation best practices Security & Compliance: Basic understanding of database security, access control, and data masking standards Experience Requirements Minimum of 5+ years working in database development, data warehousing, or ETL processing Proven experience designing and optimizing large-scale ETL workflows in enterprise environments Demonstrated proficiency in writing complex T-SQL queries, stored procedures, and functions Experience with SSIS, including package development, deployment, and troubleshooting Background in data migration and data governance is preferred Industry experience in financial services, banking, or large enterprise environments is advantageous Alternative pathways include extensive hands-on experience or relevant professional training in ETL and database management Day-to-Day Activities Develop, test, and deploy robust ETL workflows using SSIS to meet business needs Build and optimize T-SQL queries, stored procedures, and functions for performance and reliability Analyze source system data structures, identify best-fit schemas, and design data warehouse models Monitor and troubleshoot ETL processes, resolving performance bottlenecks and errors Collaborate with stakeholders to gather requirements and translate them into technical designs Review and optimize database performance and security configurations Document data models, mappings, and processes for operational clarity Engage in regular team meetings, code reviews, and process improvement initiatives Qualifications Bachelors degree or higher in Computer Science, Information Technology, or related field Relevant certifications such as Microsoft Certified: Data Engineer or SQL Server certifications (preferred) Proven track record of designing and maintaining enterprise data warehouses and ETL processes Professional Competencies Critical thinking and analytical skills to troubleshoot complex data issues Strong communication skills for effective stakeholder engagement and documentation Ability to work independently and collaboratively in a fast-paced environment Adaptability to evolving data technologies and requirements Results-oriented with excellent time and priority management Commitment to continuous improvement and learning new data management techniques.