About Creative Web Technologies

Creative Web Technologies Pvt Ltd is a Sri Lankan software organization focused on developing innovative Data and AI solutions, empowering businesses and clients across local and international markets.

About the role: 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.

What you will be doing:

• Build and Manage Data Pipelines

Create and maintain scalable ETL/ELT pipelines across Azure and on-prem systems.

• Design Data Models & Warehouses

Develop star/snowflake schemas and ensure data quality, governance, and security.

• Optimize Existing Data Solutions

Continuously review, tune, and enhance current data pipelines, models, and infrastructure to improve performance, reliability, and cost efficiency.

• Work Across Cloud and On-Prem Platforms

Use Azure services (ADF, Synapse, Databricks) while supporting existing on-prem SQL Server platforms.

• 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 modelling.

• Lead and Collaborate

Mentor junior engineers and work closely with analysts, BI developers, and software teams.

• Leverage Multi-Platform Experience

Use knowledge of other platforms (AWS, GCP, Snowflake) to enhance system design and innovation.

What we expect:

1. 3-5 years of experience in Data Engineering or related fields.
2. Strong expertise in SQL and at least one programming language (Python, Scala, or Java).
3. Hands-on experience with Azure data services such as Data Factory, Synapse, Databricks, Azure SQL, and Storage.
4. Experience with on-premise data platforms, especially SQL Server and SSIS.
5. 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.
6. Solid experience building and maintaining ETL/ELT pipelines.
7. Good understanding of data warehousing concepts, data governance, and data quality frameworks.
8. 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.