Senior Data Integration Consultant

3 weeks 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

  • Senior Oracle Data Integrator

    3 days ago

    Lahore, Punjab, Pakistan Digital NextGen Solutions Full time

    Senior Oracle Data Integrator (ODI) DeveloperDGNextGen is seeking a highly experienced and motivated Senior ODI Developer to lead our enterprise data integration initiatives. The ideal candidate will have deep expertise in Oracle Data Integrator (ODI) and a strong understanding of data warehousing, ETL/ELT processes, and enterprise data architecture. You...

  • Senior Oracle Data Integration Expert

    3 days ago

    Lahore, Punjab, Pakistan beBee Careers Full time

    Senior Oracle Data Integrator is a high-level role that requires expertise in designing, developing, and optimizing complex data integration solutions. The ideal candidate will have deep understanding of Oracle Data Integrator (ODI) and strong knowledge of data warehousing, ETL/ELT processes, and enterprise data architecture.The key responsibilities of this...

  • Oracle Data Integrator Developer

    3 days ago

    Lahore, Punjab, Pakistan beBee Careers Full time

    Oracle Data Integrator Specialist is a senior-level position that requires significant experience with Oracle Data Integrator (ODI). The ideal candidate will have strong expertise in ETL/ELT processes, data mapping, and transformation logic, as well as solid understanding of Oracle databases, PL/SQL, and performance tuning.The responsibilities of this role...

  • SAP Data Migration Consultant

    20 hours ago

    Lahore, Punjab, Pakistan AXTeams Global Full time

    4 days ago Be among the first 25 applicantsGet AI-powered advice on this job and more exclusive features.Direct message the job poster from AXTeams GlobalAX Teams Global is on a hunt of a "SAP DATA MIGRATION CONSULTANT"As a member of our team, you'll have a chance to extend your experience. You'll support clients in choosing the most suitable business...

  • Senior Data Engineer

    3 weeks ago

    Lahore, Punjab, Pakistan Tkxel Full time

    Job Description: Senior Data Engineer at TkxelWe are seeking a skilled and experienced Data Engineer with expertise in PySpark and Azure Data Factory to join our team. The ideal candidate will have a minimum of 5 years of professional experience in data engineering and a strong understanding of data processing, transformation, and integration. Knowledge of...

  • Data Integration Specialist

    4 days ago

    Lahore, Punjab, Pakistan beBee Careers Full time

    Job DescriptionWe are seeking a highly skilled Data Engineer to join our team. As a Data Engineer, you will design and implement data integration solutions to ensure smooth and efficient data flow within our systems.Responsibilities:Develop and maintain ETL processes to integrate data from various sources into SQL Server.Assist in optimizing ETL performance...

  • Senior Accountant

    2 weeks ago

    Lahore, Punjab, Pakistan HBS Business Consultant Full time

    Job Description:HBS Business Consultant, a premier accounting firm located in Lahore, Pakistan, is seeking a Senior Accountant with at least 4 years of experience. We specialize in providing exceptional financial services, including accounting, financial consulting, and taxation solutions to small and medium-sized enterprises.Responsibilities:- Prepare and...

  • Senior Student Consultant

    1 week ago

    Lahore, Punjab, Pakistan NWC Education Pakistan Full time

    NWC Education is a leading overseas education consulting firm based in Lahore, established in 2005. The company focuses on recruiting international students and providing education consultancy services to UK-based educational clients. NWC Education has a team of British graduates from top UK universities and experienced management staff, dedicated to helping...

  • Data Integration Specialist

    1 week ago

    Lahore, Punjab, Pakistan beBee Careers Full time

    Key Responsibilities:">Migrate data from external platforms into our databases.Develop, debug, and optimize complex SQL scripts and stored procedures to extract, transform, and load data into our systems.Create and maintain stored procedures, triggers, views, and scripts for data transformation and integration.Manage, update, and maintain our databases to...

  • Integration Specialist

    3 weeks ago

    Lahore, Punjab, Pakistan Cyber System Full time

    1 day ago Be among the first 25 applicantsGet AI-powered advice on this job and more exclusive features.Direct message the job poster from Cyber SystemHuman Resources Executive | HR Operations | Compensation & BenefitsJob Title: Integration Analyst (HL7, Mirth Connect, Laboratory Systems)Job Summary:Key Responsibilities:Design, develop, and implement HL7...