Data Engineer (Contract)

About this role

# Job Description – Data Engineer

Lextech is a group of inventive thinkers who care deeply about our clients. We create experiences that achieve their most important business results. Lextech is looking to add a Data Engineer to the team. This is a 4 week contract, with a possible extension for implementation

The core deliverable for this role is a comprehensive end-to-end data pipeline audit across CosmosDB, Azure Data Factory, Azure SQL, and Power BI, with a prioritized remediation plan delivered within the first 4 weeks.

What will you be working on:

- Conduct a comprehensive end-to-end data pipeline audit across CosmosDB, Azure Data Factory, Azure SQL, and Power BI, and deliver a prioritized remediation plan within the first 30 days
- Perform systematic root cause analysis on the multi-campaign attribution issue (sessions incorrectly assigned to multiple campaigns)
- Identify any other data quality issues not yet discovered
- Assess current data validation and monitoring gaps
- Evaluate database performance issues (e.g., query taking 9 minutes over 5M records - possible indexing problems)
- Deliver a prioritized remediation roadmap with level of effort estimates
- Recommend proactive monitoring strategy (dashboards, alerts, health checks)
- Deliverables:
- Data flow diagram mapping every pipeline from source to report
- Complete issue registry with severity, affected pipeline, root cause analysis, and evidence
- Prioritized remediation plan with wave-based rollout, fix specifications, testing plans, and rollback plans
- Monitoring framework recommendation for ongoing data quality assurance

Required Technical Experience:

• 5+ years in data engineering or database architecture
• Strong SQL and relational database optimization (indexing, query performance)
• Experience with ETL pipelines and data quality frameworks
• Proven track record in systematic root cause analysis
• Familiarity with BI tools (PowerBI preferred)
• Experience im...