Data Engineer with ETL, SSIS
Synechron, Charlotte, NC, United States
Our Challenge:
Looking for Data Engineers need in-depth knowledge of SQL Server SSIS, ETL.
The Role
Responsibilities:
- Design, develop, and implement ETL processes to extract data from various sources, transform it into a usable format, and load it into data warehouses.
- Collaborate with data architects and analysts to understand data requirements and translate them into technical specifications.
- Optimize ETL processes for performance, scalability, and maintainability.
- Monitor ETL jobs for errors and performance issues, troubleshooting and resolving any problems as they arise.
- Ensure data quality and integrity through validation and testing processes.
- Document ETL processes and workflows for future reference and compliance.
- Stay updated with industry trends and best practices in data engineering and ETL technologies.
Requirements:
You are:
- Proven experience in data engineering, including developing and maintaining data pipelines, ETL processes, and data integration solutions.
- Proficient in developing with Microsoft SQL Server and SSIS stack.
- Expertise in designing and managing cloud-based data solutions on Azure .
- Knowledge or experience in Apache tools, including Airflow, Spark, and Hadoop.
- Strong programming skills in Java, Python or C#.
- Experience with real-time data streaming and event-driven architecture, such as Apache Kafka or Azure Service Bus.
- Strong leadership skills with the ability to mentor and guide a team of engineers.
- Knowledgeable in data governance and data quality best practices.
- Ability to understand and optimize current database architecture for enhanced performance and scalability.
- Proven ability to optimize data performance and efficiency by tuning SQL queries and ETL processes.
- Collaborate with cross-functional teams to understand data requirements, design scalable data solutions, and ensure data integrity and security.
- Familiarity with DevOps practices and tools for CI/CD in data engineering.
- Strong analytical and problem-solving skills with attention to detail.
- Excellent communication skills to effectively convey technical concepts to non-technical stakeholders.
We can offer you:
- A highly competitive compensation and benefits package
- A multinational organization with 58 offices in 21 countries and the possibility to work abroad
- Laptop and a mobile phone
- 10 days of paid annual leave (plus sick leave and national holidays)
- Maternity & Paternity leave plans
- A comprehensive insurance plan including: medical, dental, vision, life insurance, and long-/short-term disability (plans vary by region)
- Retirement savings plans
- A higher education certification policy
- Commuter benefits (varies by region)
- Extensive training opportunities, focused on skills, substantive knowledge, and personal development
- On-demand Udemy for Business for all Synechron employees with free access to more than 5000 curated courses
- Coaching opportunities with experienced colleagues from our Financial Innovation Labs (FinLabs) and Center of Excellences (CoE) groups
- Cutting edge projects at the world’s leading tier-one banks, financial institutions and insurance firms
- A flat and approachable organization
- A truly diverse, fun-loving and global work culture
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 ‘Synclusive’ 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.