Data EngineerExpected Rate: $55/hr C2C maxTerm: 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 CTClient: Large US based pharma clientAdditional 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 discoveredAssess current data validation and monitoring gapsEvaluate database performance issues (e.g., query taking 9 minutes over 5M records - possible indexing problems)Deliver a prioritized remediation roadmap with level of effort estimatesRecommend proactive monitoring strategy (dashboards, alerts, health checks)