Senior Data Engineer

Ciklum; Pakistan; On-site; PKR 1,200,000 - 1,800,000; Full time

Benefits offered by this job

Comprehensive medical coverage

Life insurance

Gym membership

Fuel and internet allowances

Tailored education path

Flexible schedule

Opportunities for internal mobility

Job summary

Ciklum is seeking a Senior Data Engineer to join our team full-time in Pakistan. This position involves designing, developing, and deploying Power BI solutions that deliver key insights through advanced data analytics. The ideal candidate has over 3 years of BI solutions experience and strong SQL and DAX skills.

Join a global team dedicated to enhancing financial service processes through innovative technology. We provide a supportive environment for your professional growth and well-being.

Qualifications

• 3+ years of experience developing BI solutions with Power BI.
• Proficient in SQL, DAX, and Azure Data Services.
• Solid understanding of data modeling principles.

Responsibilities

• Designing and deploying Power BI solutions.
• Optimizing reports and dashboards for performance.
• Contributing to data ingestion and ETL processes.

Skills

Power BI solutions

Data modeling principles

SQL

DAX

Azure Data Services

Problem-solving skills

Agile development

Communication skills

Tools

Azure DevOps

PowerShell

SQL Profiler

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:

We know that sometimes, you can’t tick every box. We would still love to hear from you if you think you’re a good fit!

• 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
• 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!