We are looking for an accomplished SQL Server Data Integration Engineer to join our dynamic team. The ideal candidate will have a deep understanding of SQL Server Integration Services (SSIS) and a proven track record in designing, developing, and implementing data integration solutions. In this role, you will collaborate with cross-functional teams to ensure seamless data flow between systems and optimize data processes to meet business needs.

Primary Responsibilities

1. Design and Development. Create robust data integration solutions using SQL Server Integration Services (SSIS), T-SQL, and Dynamic SQL.
2. Requirements Gathering. Work with stakeholders to understand and gather data integration requirements.
3. Data Structures. Design data structures including staging, intermediate staging, dimension, fact, aggregate tables, and views to meet business requirements.
4. Process Improvement. Analyze and enhance existing data processes for improved performance.
5. Troubleshooting. Identify and resolve issues related to data integration and ETL processes.
6. Performance Optimization. Tune and optimize SSIS packages for better performance.
7. Collaboration. Coordinate with database administrators to ensure data integrity and security.
8. Cross-Functional Teamwork. Collaborate with software developers, business analysts, and other team members for effective data integration.
9. Industry Trends. Stay updated on industry best practices and emerging trends in data integration and ETL processes.
10. Documentation. Provide comprehensive documentation including data mapping, technical specifications, production support, data dictionaries, and test cases.
11. Training. Document technical specifications and offer training to end-users as necessary.
12. Code Reviews. Participate in code reviews and offer constructive feedback to team members.

Technical Skills, Experience, and Qualifications

1. Education. Bachelor’s degree in Computer Science, Information Technology, or a related field.
2. Experience. Minimum of 5 years of industry experience in developing and maintaining enterprise data warehouse solutions, preferably in a financial context.
3. Data Warehousing. Proven expertise in data warehousing and data modeling techniques and methodologies.
4. SQL Proficiency. Advanced skills in dynamic SQL, T-SQL, and SQL Server database development.
5. ETL Optimization. Experience in performance tuning and optimization of ETL processes.
6. Conceptual Knowledge. Strong understanding of data warehousing concepts and methodologies.
7. Problem-Solving. Excellent problem-solving and troubleshooting capabilities.
8. Communication. Strong communication and collaboration skills.
9. Independence. Ability to work effectively both independently and within a team.
10. Certifications. Relevant certifications such as Microsoft Certified, Data Engineer Associate are advantageous.
11. Power BI. Experience with Power BI for data visualization.
12. Azure Knowledge. Familiarity with Azure Synapse Analytics and Azure Data Factory for cloud-based data integration.
13. Programming. Programming skills in C# are a plus.

If you are passionate about data integration and looking for a challenging opportunity to make a significant impact, we encourage you to apply and become a key player in our data engineering team.