Senior Data Engineer

EC Markets LTD; Warsaw (IN); On-site; USD 120,000 - 170,000; Full time

Job summary

EC Markets LTD is seeking a Senior Data Engineer to drive the evolution of a Snowflake-based Data Lakehouse supporting trading, operations, and marketing analytics.

The role requires designing scalable data platforms, building robust ETL/ELT pipelines, and delivering semantic models and operational dashboards with Power BI. Strong collaboration with trading, finance, and compliance is essential.

Qualifications

• Experience in financial services, trading, or fintech environments.
• Proven experience designing and delivering DWH/Delta Lakehouse using Snowflake.
• Expert-level SQL and data modelling expertise (star/snowflake schemas, dimension modelling).
• 2+ years writing dbt models in production.
• 3+ years building production Power BI on enterprise warehouses; strong DAX, PowerQuery/M, TabularEditor, DAXStudio.
• Strong SQL on Snowflake; understanding warehousing sizing, clustering, and cost drivers.
• Familiarity with orchestration and transformation frameworks.
• Hands-on experience with data analysis, visualization, and operational reporting tools.
• Excellent communication skills and ability to translate business requirements into scalable data architecture.

Responsibilities

• Own Snowflake-centric Data Lakehouse architecture integrating multi-source data.
• Develop and support robust ETL/ELT pipelines from trading, CRM, finance, risk, and APIs.
• Implement data models, schemas and transformation frameworks for analytics and compliance.
• Apply best practices in data versioning, orchestration, and automation.
• Ensure scalability, data lineage, and governance across the data lifecycle.
• Build and own semantic models on Snowflake using DirectQuery/Import.
• Develop operational reports, dashboards, and data extracts.
• Maintain data integrity, privacy, and security aligned with regulatory requirements.

Skills

Financial services experience

Snowflake data platform

SQL & data modelling

dbt in production

Power BI & DAX

PowerQuery/M

TabularEditor

DAXStudio

AWS & Terraform

GitHub Actions

Python scripting

Orchestration frameworks

Data analysis & visualization

Strong communication

Education

Degree in Computer Science or Data Engineering

Tools

Snowflake

dbt

PowerBI

Tabular Editor

DAX Studio

PowerQuery/M

Terraform

Git/GitHub Actions

Job description

Overview

ECMarketsisbuildinganext-generationdataplatformtopowertrading,operational,andmarketingintelligence.WeareseekingaSeniorDataEngineertodriveevolutionofourSnowflake-basedDataLakehouse,establishingamoderndataecosystemthatsupportsadvancedanalytics,compliance,anddecision-makingacrossthebusiness.

Thisisahigh-impactroleforanexperiencedengineerwithatrackrecordofarchitectingandimplementingscalabledataplatforms—ideallyinfinancialortradingenvironments—whocantalkandthinkdatafromingestiontoMIdashboards.

KeyResponsibilities

Architecture&Development

• AssumeownershipofaSnowflake-centricDataLakehouseintegratingstructured,semi-structured,andunstructureddata.
• DevelopandsupportrobustETL/ELTpipelinesthatingestandtransformdatafrommultipleinternalsystems(trading,CRM,finance,risk,etc.)andexternalAPIs.
• Implementdatamodels,schemas,andtransformationframeworksoptimisedforanalyticalandregulatoryusecases.
• Applybestpracticesindataversioning,orchestration,andautomationusingmoderndataengineeringtools.
• Ensurescalability,datalineage,andgovernanceacrossthedatalifecycle.

Reportsanddatavisualisation

• BuildandownsemanticmodelsontopofSnowflake(DirectQueryandImport),usingDAX,calculationgroups,RLS/OLS,andincrementalrefresh.
• Developoperationalreports,dashboardsanddataextracts

DataGovernance&Quality

• Maintainhighdataintegrity,privacy,andsecurityalignedwithFCAandGDPRrequirements.
• Monitorandoptimisequeryperformanceandstorageefficiency.

Cross-FunctionalCollaboration

• Partnerwithbusinessunits(Trading,Finance,Marketing,Compliance,Operations)tocapturedatarequirementsandtranslatethemintorobusttechnicalsolutions.
• Supportregulatory,management,andoperationalreportingrequirementsthroughstructureddatamodels.

Skills&Experience(Non-negotiable)

• Experienceinfinancialservices,trading,orfintechenvironments.
• ProvenexperiencedesigninganddeliveringDWH/DeltaLakehouseusingSnowflake.
• ExpertlevelSQLanddatamodellingexpertise(star/snowflakeschemas,dimension/almodelling).
• 2+yearswritingdbtmodelsinproduction.Comfortablewithsources,snapshots,tests,macros,exposures,andthemedallion(bronze/silver/gold)pattern.
• 3+yearsbuildingproductionPowerBIonenterprisewarehouses.ExpertDAX(timeintelligence,variables,virtualrelationships,calculationgroups),PowerQuery/M,TabularEditor,DAXStudio.
• StrongSQLonSnowflake.Understandwarehousesizing,clustering,queryprofiles,andthecostLeversthatmatter.
• Familiaritywithorchestrationandtransformationframeworks.
• Hands-onexperiencewithdataanalysis,visualisation,andoperationalreportingtools.
• Excellentcommunicationskillsandabilitytotranslatebusinessrequirementsintoscalabledataarchitecture.

Skills&Experience(nicetohave)

• AbilitytocreatescriptsinPythonoranotherscriptinglanguage.
• ExperiencewithAWS(ECS,S3,IAM),Terraform,Git/GitHubActions.
• PowerBIembedded,Fabric,oracredibleopiniononwhennottousethem.
• ExposuretoMicrosoftFabricDirectLake,SnowflakeCortex/Claude.aiconnector,orotherAI-on-warehousepatterns.

Qualifications

• DegreeinComputerScience,DataEngineering,orrelatedfield.
• 5–8 years of hands-on experience in data engineering and / or analysis.