Senior Data Engineer

Description Ciklum; Pakistan; On-site; PKR 8,342,602 - 12,513,904; Full time

Benefits offered by this job

Comprehensive medical coverage

Gym membership

Tailored education path

Job summary

Ciklum is seeking a Senior Data Engineer to join our full-time team in Pakistan. The ideal candidate will design and develop Power BI solutions, ensuring efficient data models and solutions for our Tax and Financial Services platform.

This role requires strong SQL and DAX expertise, with a focus on enhancing the quality and performance of our systems. Join us to work on international projects that redefine industries in a flexible and growth-oriented environment.

Qualifications

• 3+ years of experience in developing BI solutions with Power BI.
• Proficient in Power BI Desktop and Power BI Service.
• Strong expertise in complex DAX calculations.
• Experience with data transformations and ETL processes.
• Knowledge of Data Warehousing and quality testing.

Responsibilities

• Design, develop, and deploy Power BI solutions.
• Optimize reports and dashboards for better performance.
• Contribute to design, code, and manage data ingestion.
• Identify gaps and improve platform quality and speed.
• Cross-train team members on technologies being developed.

Skills

Power BI solutions

DAX

SQL

Data modeling

ETL processes

Azure Data Services

Agile methodology

Communication

Education

3+ years of experience in BI solutions

Experience with data integration

Tools

Power BI Desktop

Azure Data Factory

DAX Studio

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

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!

Interested already? We would love to get to know you! Submit your application. We can’t wait to see you at Ciklum.