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

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 organization’s 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

• Bachelor’s 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

S​YNECHRON’S DIVERSITY & INCLUSION STATEMENT
 

Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.

All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.

Candidate Application Notice