Senior Data Integration Consultant

1 day ago

Lahore, Punjab, Pakistan BITS Global Consulting Full time

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.

#J-18808-Ljbffr

  • EMR Data Integration Engineer

    1 week ago

    Lahore, Punjab, Pakistan The Services Tree Full time

    We are seeking a skilled Healthcare Technology Consultant to join our team at The Services Tree. As a Healthcare Technology Consultant, you will work closely with our clients to design, develop, and implement data integration solutions that meet their specific needs.Your key responsibilities will include:Evaluating client needs and identifying opportunities...

  • Big Data Integration Lead

    4 days ago

    Lahore, Punjab, Pakistan beBee Careers Full time

    Senior Data Engineer Job DescriptionThis is a senior role that requires experience in cloud data processing and big data integration. We need a highly skilled Data Engineer who can design, develop, and maintain scalable data pipelines using PySpark and Azure Data Factory.Main Responsibilities:Create efficient data processing and transformation workflows...

  • Cloud Data Integration Engineer

    3 days ago

    Lahore, Punjab, Pakistan beBee Careers Part time

    Salesforce Data Cloud Solutions SpecialistWe're looking for an experienced Salesforce Data Cloud Solutions Specialist to help us drive the integration, optimization, and maintenance of our real-time customer data solutions using Salesforce Data Cloud.Your main tasks will include designing and implementing data pipelines, ensuring smooth integration with...

  • Data Warehouse Engineer

    20 hours ago

    Lahore, Punjab, Pakistan beBee Careers Full time

    As a Senior Data Integration Consultant, you will work closely with data engineers, analysts, and business users to understand data requirements and provide guidance on best practices for data integration and ETL. You will also serve as a subject matter expert on data integration and ETL, collaborating with cross-functional teams and diverse stakeholders to...

  • Meditech EMR Integration Developer

    1 week ago

    Lahore, Punjab, Pakistan The Services Tree Full time

    We are seeking a highly skilled Integration Developer with proven experience in Meditech EMR environments. The ideal candidate will have hands-on expertise in integrating Meditech EMR using technologies such as DRDB, SSIS, HL7, and other healthcare data integration tools. You will be responsible for designing, developing, and maintaining data flows between...

  • Data Integration Expert

    1 day ago

    Lahore, Punjab, Pakistan beBee Careers Full time

    About the Position:This is an exciting opportunity for a skilled Application Software Specialist to join our team. As an Application Software Specialist, you will be responsible for designing and implementing custom solutions using Zoho Creator. This role involves collaborating with cross-functional teams to gather and analyze business requirements,...

  • Senior Educational Consultant

    2 days ago

    Lahore, Punjab, Pakistan NWC Education Pakistan Full time

    Senior Educational Consultant - Study Abroad AdvisorCompany Description:NWC Education is a student consultancy organization dedicated to stress-free admission experiences. We have been in the business for 19 years and operate in 8 countries providing world-class and unparalleled study abroad options for your careers. We have secured the futures of over...

  • Data Integration Specialist

    4 days ago

    Lahore, Punjab, Pakistan beBee Careers Full time

    About the Role:We are looking for a skilled professional to lead our data integration efforts. The successful candidate will have hands-on experience with ETL development, SSIS, and SSRS, as well as strong knowledge of database design and T-SQL.Responsibilities:Design, develop, and maintain ETL processes using SSIS and SSRS.Collaborate with cross-functional...

  • Senior ETL Specialist

    20 hours ago

    Lahore, Punjab, Pakistan beBee Careers Full time

    We are seeking an experienced Senior Data Integration Consultant to lead our data integration efforts. The ideal candidate will have extensive expertise in data integration, ETL processes, and data warehousing, with hands-on experience in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS). The role will play a critical part in...

  • Senior Systems Consultant for Microsoft and VMWare

    4 weeks ago

    Lahore, Punjab, Pakistan Premier Systems (Pvt.) Ltd. Full time

    Senior Systems Consultant for Microsoft and VMWareCompany DescriptionPremier Systems is a key player in IT infrastructure, digital payments, and automotive innovation in Pakistan, with partnerships with leading technology providers like HP, Dell, Microsoft, VMware, Oracle, and Cisco. Premier leads the fintech revolution in Pakistan with PayFast, the largest...