Senior Data Engineer

Ciklum Pakistan; Islamabad; On-site; PKR 2,400,000 - 3,600,000; Full time

Benefits offered by this job

Medical coverage

Gym membership

Provident fund

Education programs

Job summary

Ciklum Pakistan is seeking a Senior Data Engineer to join our Islamabad office. You will design and deploy Power BI solutions, build data models, and optimize ETL across multiple data stores to deliver actionable insights for clients.

The role emphasizes collaboration with cross-functional teams and continuous learning to advance the TAX platform. Ideal candidates bring 3+ years of BI/PBI experience, strong SQL/DAX skills, and hands-on work with Azure Data Factory and Synapse.

Qualifications

• 3+ years building BI solutions with Power BI.
• Strong SQL and data modeling fundamentals.
• Experience with Azure Data Services (Data Factory, Synapse).
• Experience in Agile SCRUM and cross-functional collaboration.

Responsibilities

• Design, develop, and deploy Power BI solutions for dashboards and reports.
• Create and optimize data models and ETL pipelines across data stores.
• Tune SQL/DAX queries for performance and scalability.
• Contribute to data ingestion, batch/real-time processing, and CI/CD practices.
• Collaborate with stakeholders and cross-functional teams to deliver insights.

Skills

Power BI

Azure Data Services

SQL / MSSQL

DAX

ETL design

Data Modeling

Azure Synapse

Data warehousing

Cross-functional collaboration

English communication

Tools

Azure Data Factory

Power BI Designer

SQL Profiler

Job description

Job Description

Ciklum is looking for a Senior Data Engineer to join our team full-time in Pakistan. We are a custom product engineering company that supports both multinational organizations and scaling startups to solve their most complex business challenges. With a global team of over 4,000 highly skilled developers, consultants, analysts and product owners, we engineer technology that redefines industries and shapes the way people live.

About The Role

As a Senior Data Engineer, become a part of a cross-functional development team engineering experiences of tomorrow. Ciklum is developing the web solution - TAX platform built to enhance and unify the process of providing Tax and Financial Services. Ciklum team (47 FTE) is a part of the big program (300+ FTE). We are developing an innovative automation platform for our client. It is a globally-operating, complex system that is built to enhance and unify the process of collecting, processing and providing Tax and Financial services. The client's employees and external users are actively using the platform on a daily basis and the team continues to add new features that automate the business flows.

Responsibilities

• Designing, developing, and deploying Power BI solutions, providing advanced data analytics, and creating dashboards and reports that deliver key insights to the business
• Data models design and implementation
• Optimize reports and dashboards for better performance by improving query speed and ensuring efficient data model design
• Contributes design, code, configurations, manage data ingestion, closed to real-time processing, batch processing, ETL across multiple data storages
• Responsible for performance tuning of complicated SQL and DAX queries
• Identify gaps and improve the platform’s quality, robustness, maintainability, and speed
• Cross-train other team members on technologies being developed, while also continuously learning new technologies from other team members
• Contribute in the Unit’s activities and community building, participate in conferences, and provide excellence in exercise and best practices

Requirements

• 3+ years of experience in developing BI solutions with Power BI
• Proficient in Power BI Desktop and Power BI Service, including report and dashboard creation, data transformations, and DAX formulas
• Strong expertise in DAX (Data Analysis Expressions) for complex calculations
• Experience with Power Query for data transformations and ETL processes
• Solid understanding of data modeling principles and best practices
• 3+ years of experience coding in SQL(Azure SQL DB or MSSQL preferable), solid CS fundamentals including data structure and algorithm design
• 2+ years contributing to production deployments of large backend data processing and analysis systems
• Experience in data integration and ETL processes
• Proficient with Azure Data Services (Azure Data Factory, Azure Synapse Analytics, etc.)
• Strong problem-solving and analytical skills, with a keen attention to detail
• Excellent communication skills, both written and verbal, with the ability to present complex data in a clear and concise manner
• Experience in working with cross-functional teams and collaborating with stakeholders at various levels of the organization
• Knowledge of professional software engineering best practices for the full software
• Knowledge of Data Warehousing, design, implementation and optimization
• Knowledge of Data Quality testing, automation and results visualization
• Knowledge of the development life cycle, including coding standards, code reviews, source control management, build processes, testing, and operations
• Experience participating in an Agile software development team, e.g. SCRUM
• Experience designing, documenting, and defending designs for key components in large distributed computing systems
• A consistent track record of delivering exceptionally high-quality software on large, complex, cross-functional projects
• Demonstrated ability to learn new technologies quickly and independently
• Ability to handle multiple competing priorities in a fast-paced environment

Desirable

• Experience with Power BI Embedded
• Experience with Power BI REST or JS APIs
• Power BI Premium Capacity Management
• Experience in backend development and deployment
• Experience in CI/CD configuration
• Experience with Azure DevOps for CI\CD
• Experience with Tabular Editor, DAX Studio, SQL Profiler
• Experience with Powershell
• Experience with Swagger, Postman

What’s in it for you?

• Care: your mental and physical health is our priority. We offer competitive benefits package that includes but is not limited to comprehensive medical coverage, life-insurance, gym membership, fuel, internet and mobile allowances and provident fund
• Tailored education path: boost your skills and knowledge with our regular internal events (meetups, conferences, workshops), Udemy license, language courses and company-paid certifications
• Growth environment: share your experience and level up your expertise with a community of skilled professionals, locally and globally
• Flexibility: Own your schedule – you are the one to decide when to start your working day. Just don’t miss your regular team stand-up
• Opportunities: we value our specialists and always find the best options for them. Our Internal Mobility
• Program helps change a project if needed to help you grow, excel professionally and fulfill your potential
• Global impact: work on large-scale projects that redefine industries with international and fast-growing clients
• Welcoming environment: feel empowered with a friendly team, open-door policy, informal atmosphere within the company and regular team-building events

About Us

At Ciklum, we are always exploring innovations, empowering each other to achieve more, and engineering solutions that matter. With us, you’ll work with cutting-edge technologies, contribute to impactful projects, and be part of a One Team culture that values collaboration and progress. With over 14 years of presence in Islamabad, our Pakistan team is a trusted force in redefining industries. We value every voice and invite experienced professionals to help shape tomorrow’s digital experiences.

Explore, empower, engineer with Ciklum!