Senior Data Engineer (T-SQL & SSIS, Data Warehousing & ETL Specialist)
Senior Data Engineer (T-SQL & SSIS, Data Warehousing & ETL Specialist)
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Job Summary
Synechron is seeking a highly skilled Senior Data Engineerspecializing 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
SYNECHRONS 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 applicants gender gender identity sexual orientation race ethnicity disabled or veteran status or any other characteristic protected by law.
Required Experience:
Senior IC
Employment Type
Full-Time
