Senior Data Integration Consultant

Description:

BITS Global Consulting is seeking a Senior Data Integration Consultant with extensive expertise in data integration, ETL processes, and data warehousing. The ideal candidate must have hands-on experience in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) and a deep understanding of data warehouse design, implementation, and best practices. This role will play a critical role in designing, implementing, and optimizing data integration solutions that support business intelligence and analytics objectives.

Key Responsibilities:

1. Data Integration & ETL Development:

• Design, develop, and implement data integration workflows using SSIS.

• Manage ETL processes to ensure accurate data extraction, transformation, and loading into data warehouses.

• Monitor and troubleshoot data integration workflows to optimize performance and maintain data integrity.

2. Data Warehouse Design and Implementation:

• Collaborate with data architects and stakeholders to design comprehensive data warehouse solutions.

• Lead the implementation of data warehouse structures, including fact and dimension tables, star and snowflake schemas, and optimized data storage solutions.

• Ensure data warehouse performance meets operational and analytical needs through effective design and optimization strategies.

3. Reporting and Data Visualization:

• Utilize SSRS to develop and maintain a suite of reports that support business decision-making.

• Collaborate with business users to understand reporting requirements and deliver high-quality reports.

4. Data Quality and Governance:

• Implement data quality checks within ETL processes and data warehouses to ensure data consistency and accuracy.

• Work on data governance initiatives to establish and maintain best practices in data management.

5. Collaboration and Stakeholder Communication:

• Work closely with data engineers, analysts, and business users to understand data requirements.

• Serve as a subject matter expert on data integration and ETL, providing guidance on best practices.

Qualifications:

Education:

• Bachelor’s or Master’s degree in Computer Science, IT, Data Science, or a related field.

Experience:

• 6-8 years of experience in data integration, ETL processes, and data warehousing.

• Strong expertise in SSIS and SSRS.

Technical Skills:

✔ Advanced proficiency in SSIS for ETL and SSRS for reporting solutions.
✔ Hands-on experience with data warehouse design and implementation, including dimensional modeling, schema design, and performance optimization.
✔ Familiarity with other ETL tools (e.g., Informatica, Talend) and cloud data integration platforms is a plus.
✔ Proficiency in SQL, data modeling, and relational database management.
✔ Strong knowledge of data governance and quality assurance practices.

Soft Skills:

✔ Excellent communication, problem-solving, and analytical skills.
✔ Ability to work collaboratively with cross-functional teams and diverse stakeholders.