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
- Design and Development. Create robust data integration solutions using SQL Server Integration Services (SSIS), T-SQL, and Dynamic SQL.
- Requirements Gathering. Work with stakeholders to understand and gather data integration requirements.
- Data Structures. Design data structures including staging, intermediate staging, dimension, fact, aggregate tables, and views to meet business requirements.
- Process Improvement. Analyze and enhance existing data processes for improved performance.
- Troubleshooting. Identify and resolve issues related to data integration and ETL processes.
- Performance Optimization. Tune and optimize SSIS packages for better performance.
- Collaboration. Coordinate with database administrators to ensure data integrity and security.
- Cross-Functional Teamwork. Collaborate with software developers, business analysts, and other team members for effective data integration.
- Industry Trends. Stay updated on industry best practices and emerging trends in data integration and ETL processes.
- Documentation. Provide comprehensive documentation including data mapping, technical specifications, production support, data dictionaries, and test cases.
- Training. Document technical specifications and offer training to end-users as necessary.
- Code Reviews. Participate in code reviews and offer constructive feedback to team members.
Technical Skills, Experience, and Qualifications
- Education. Bachelor’s degree in Computer Science, Information Technology, or a related field.
- Experience. Minimum of 5 years of industry experience in developing and maintaining enterprise data warehouse solutions, preferably in a financial context.
- Data Warehousing. Proven expertise in data warehousing and data modeling techniques and methodologies.
- SQL Proficiency. Advanced skills in dynamic SQL, T-SQL, and SQL Server database development.
- ETL Optimization. Experience in performance tuning and optimization of ETL processes.
- Conceptual Knowledge. Strong understanding of data warehousing concepts and methodologies.
- Problem-Solving. Excellent problem-solving and troubleshooting capabilities.
- Communication. Strong communication and collaboration skills.
- Independence. Ability to work effectively both independently and within a team.
- Certifications. Relevant certifications such as Microsoft Certified, Data Engineer Associate are advantageous.
- Power BI. Experience with Power BI for data visualization.
- Azure Knowledge. Familiarity with Azure Synapse Analytics and Azure Data Factory for cloud-based data integration.
- 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.