Synechron
Data Engineer with ETL, SSIS
Synechron, Charlotte, North Carolina, United States, 28245
Job Title: Data Engineer with ETL, SSISLocation: Charlotte, NCFull Time/ PermanentContact: Syed.Khaliq@The RoleResponsibilities: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 packageA multinational organization with 58 offices in 21 countries and the possibility to work abroadLaptop and a mobile phone10 days of paid annual leave (plus sick leave and national holidays)Maternity & Paternity leave plansA comprehensive insurance plan including: medical, dental, vision, life insurance, and long-/short-term disability (plans vary by region)Retirement savings plansA higher education certification policyCommuter benefits (varies by region)Extensive training opportunities, focused on skills, substantive knowledge, and personal developmentOn-demand Udemy for Business for all Synechron employees with free access to more than 5000 curated coursesCoaching opportunities with experienced colleagues from our Financial Innovation Labs (FinLabs) and Center of Excellences (CoE) groupsCutting edge projects at the world's leading tier-one banks, financial institutions and insurance firmsA flat and approachable organizationA truly diverse, fun-loving and global work cultureS YNECHRON'S DIVERSITY & INCLUSION STATEMENTDiversity & 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.