Data Engineer

Role: Data Engineer

Expected Rate: $55/hr C2C max

Term: Start ASAP. 4 weeks to start and to do the analysis; I expect that we will extend to do the fixes; but that term will be determined during the initial effort.

Location Requirements: No US requirement; but must work during client core hours: 9am – 3pm CT

Client: Large US based pharma client

Additional Information: We are currently running into some database performance issues and want to bring in some expertise to do the following:

• Audit the full data pipeline (event logging → staging → fact tables → views → PowerBI reports)
• 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)

Going to pass on both. Abhinav was close; but communication really hurt him. We need tight communication skills

Akhila feedback:
Technical Skills: Did not meet bar. Candidate appeared to be reading responses and could not coherently explain fundamental concepts, including what a data pipeline is. Answers consisted of buzzwords strung together without demonstrating actual understanding.

Communication: Did not meet bar. Responses lacked coherence and did not reflect genuine technical knowledge.

Recommendation: No hire. Candidate did not demonstrate baseline competency required for the role.