Senior Data Engineer-REF7024
About Creative Software
Founded in 1999, Creative Software is a global technology enabler and pioneer in Sri Lanka’s tech industry. We manage teams of high-performing, dedicated software engineers for our global clientele, providing them with end-to-end software development and maintenance services through team augmentation.
Embark on a Creative career that offers a dynamic work environment, competitive intern allowance, and room for personal and professional growth. Be part of a community of professionals, contributing to an inclusive culture that provides you with valuable local and global exposure. At Creative, we offer a variety of spaces that support work-life balance and integrates wellness into our workspace experience.
We are seeking an experienced Senior Data Engineer to design, build, and optimize scalable data pipelines across both Azure cloud and on-premises environments. The candidate should have strong experience in ETL/ELT development, data modelling, and data warehousing, along with familiarity in Power BI and other visualization tools used to support analytics teams.
Key Responsibilities:
1. Build and Manage Data Pipelines
- Create and maintain scalable ETL/ELT pipelines across Azure and on-prem systems.
2. Design Data Models & Warehouses
- Develop star/snowflake schemas and ensure data quality, governance, and security.
3. Optimize Existing Data Solutions
- Continuously review, tune, and enhance current data pipelines, models, and infrastructure to improve performance, reliability, and cost efficiency.
4. Work Across Cloud and On-Prem Platforms
- Use Azure services (ADF, Synapse, Databricks) while supporting existing on-prem SQL Server platforms.
5. Support BI & Visualization Teams
- Prepare clean, high-quality datasets and build well-structured data models directly within Power BI while ensuring the use of industry best practices for DAX, relationships, performance tuning, and semantic modeling.
6. Lead and Collaborate
- Mentor junior engineers and work closely with analysts, BI developers, and software teams.
7. Leverage Multi-Platform Experience
- Use knowledge of other platforms (AWS, GCP, Snowflake) to enhance system design and innovation.
Required Qualifications:
- 3-5 years of experience in Data Engineering or related fields.
- Strong expertise in SQL and at least one programming language (Python, Scala, or Java).
- Hands-on experience with Azure data services such as Data Factory, Synapse, Databricks, Azure SQL, and Storage.
- Experience with on-premise data platforms, especially SQL Server and SSIS.
- Strong Power BI skills, including:
- Designing efficient data models (star schema, proper relationships).
- Writing optimized DAX measures.
- Applying best practices for performance, data loading, and semantic modeling.
- Supporting BI teams with dataset design and dashboard optimization.
- Solid experience building and maintaining ETL/ELT pipelines.
- Good understanding of data warehousing concepts, data governance, and data quality frameworks.
- Experience with version control and structured development workflows (Git, CI/CD).
Nice to have:
- Experience with additional visualization tools (Tableau, Oracle Analytics Cloud (OAC), etc.).
- Exposure to Oracle, Snowflake.
- Knowledge of DataOps, DevOps, CI/CD, and version control practices.
Soft Skills:
- Strong communication and ability to work with both technical and business teams.
- Excellent analytical and problem-solving abilities.
- Leadership qualities with mentoring experience.
- Ability to manage multiple projects in dynamic environments.
For inquiries, please contact: