Junior Business Intelligence Data Engineer

BGBx is an independent commercial solutions partner serving pharmaceutical and life science companies by combining expertise from strategists, scientists, communicators, creatives, technologists, and data specialists. Our teams work across consulting and communications to help clients shape strategy, launch innovations, engage stakeholders, and drive meaningful results throughout the product lifecycle. The environment is fast-paced and complex, offering opportunities for curious minds to contribute to impactful healthcare solutions. If you thrive in collaborative, innovative settings and want to make a real difference, BGBx provides a place to grow and contribute.

We are currently looking for a Junior Business Intelligence (BI) Data Engineer to join our expanding data team. This role involves designing and implementing scalable data infrastructure to support analytics and reporting across the organization. The successful candidate will collaborate closely with business stakeholders and analysts to ensure data accuracy, accessibility, and usability, enabling smarter, data-driven decisions. This is a remote position based in Pakistan, with working hours aligned to Monday through Friday, 4:00 AM to 1:00 PM Eastern Time or a similar schedule.

Key Responsibilities

- Design, build, and maintain scalable data pipelines within the Microsoft Fabric ecosystem, including Data Factory, Lakehouse, and Dataflows Gen2, to support BI reporting and analytics.
- Develop and optimize medallion architecture layers (Bronze, Silver, Gold) for both structured and unstructured data sources.
- Collaborate with business stakeholders to translate business requirements into scalable, high-performance data solutions.
- Ensure data quality, consistency, and governance across multiple data sources and systems.
- Utilize SQL and scripting languages such as PySpark to transform, clean, and prepare data for dashboards and reports.
- Support the implementation and integration of BI tools like Power BI, Tableau, or Looker.
- Monitor data pipeline and reporting environment performance, proactively troubleshooting any issues.

Required Qualifications

- Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or a related field, or equivalent practical experience.
- 2 to 3 years of experience in data engineering, BI development, or analytics infrastructure.
- Strong proficiency with the Microsoft Fabric ecosystem, including Data Factory, Lakehouse, and Dataflows Gen2.
- Solid experience with SQL and scripting for data transformation and preparation.
- Familiarity with medallion architecture, data modeling, and ETL/ELT pipeline development.
- Experience working with BI visualization tools such as Power BI, Tableau, or Looker.
- Knowledge of data governance best practices.
- Excellent analytical skills combined with strong problem-solving and communication abilities.

Preferred Qualifications and Benefits

At BGBx, we value exceptional talent and invest in our people to foster exceptional work. Our competitive compensation package for this role ranges from 5,000,000 PKR to 7,000,000 PKR per year. We offer a comprehensive benefits package that typically includes healthcare insurance, retirement plans, generous paid time off and holidays, wellness programs, life insurance, and learning and development opportunities. Additional benefits may vary based on location.

Beyond tangible benefits, BGBx promotes a culture of collaboration, innovation, and inclusion, providing employees with the opportunity to make a meaningful impact on healthcare and the people it serves. We are proud to be an equal opportunity employer, welcoming applicants regardless of race, color, religion, sex, age, national origin, citizenship status, sexual orientation, disability, veteran status, or any other legally protected category.