Lighthouse Technology Services is partnering with our client to fill their Senior Data Steward position! This is a 6+ month contract opportunity and will be hybrid on site in Buffalo, New York 4 days per week. This role will be a W2 employee of Lighthouse Technology Services. No C2C or subcontracting arrangements will be considered.
What You'll Be Doing:
Build and enhance customer data assets within a Customer 360 / Customer Data Platform (CDP) using the Amperity platform
Write advanced SQL (including complex CTEs) to transform raw source data into unified, customer-level attributes
Profile, explore, and validate unfamiliar datasetsasking the right questions to fully understand data structure and business context
Design and architect how data flows from source systems into the Customer 360 model with precision and efficiency
Aggregate and harmonize data to support identity resolution and customer profile creation
Build and maintain customer attributes used for marketing targeting and analytics
Debug data issues and perform deep data profiling to ensure accuracy and integrity
Monitor data pipelines, ingestion workflows, and processing jobs to ensure successful execution
Manage development lifecycle activities, including sandbox builds, QA/QC collaboration, and promotion to production
Document all work thoroughly in Confluence, including logic, transformations, and data flows
Track and manage work through Jira within Agile Scrum (2-week sprints, PI planning)
Collaborate with team members, QA partners, and leadership to ensure deliverables meet acceptance criteria and are production-ready
Independently manage multiple concurrent stories and priorities, driving work from intake through completion