Data Engineer (Contract)

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 implementing data monitoring and alerting systems • Ability to communicate technical findings clearly to non-technical stakeholders • Azure data stack experience (CosmosDB, Azure Data Factory, Azure SQL) • Ability to articulate a phased audit methodology (discovery, documentation, issue identification, root cause analysis, prioritized remediation) without prompting • Understanding that pipelines implement business logic, not just move data — ability to identify when a transformation is technically correct but produces wrong output due to incorrect or outdated business rules Required Behavioral Qualities: • Systematic over reactive — works from architecture down to specifics, not from tickets up. Traces full pipelines from source to report rather than picking off backlog items. • Fast discovery instinct — inspects schemas, runs exploratory queries, and checks field-level join logic before scheduling meetings. Forms firsthand understanding of the data independently. • Owns the full vertical — can trace a number from a Power BI dashboard back through the view, the fact table, the staging table, and the source event log. • Proactive communicator — surfaces findings, blockers, and next steps without being asked. Does not wait for standup to share status. Nice to Have: • Healthcare or pharmaceutical industry experience • Experience with marketing/campaign analytics data • Experience building scalable, centralized data layers or APIs