RESPONSIBILITIES
Kforce's retail client is looking for a Senior Analytics Engineer - Marketing Data for a fully remote contract role.
Responsibilities
- Partner with business and technical stakeholders to understand use cases and determine whether available data is sufficiently detailed, complete, timely, and appropriately structured to support them
- Identify, design, and build the Snowflake models, aggregations, materializations, and other data structures and usability, using views, dynamic tables, semantic views, stored procedures, and other appropriate technologies
- Develop a strong working understanding of the data produced by marketing and ecommerce platforms
- Elicit the underlying business need from requests that may initially be incomplete, unstructured, or solution-oriented; identify gaps and contradictions and distinguish among ingestion, modeling, CDP, activation, and reporting requirements
- Challenge assumptions or proposed solutions when they do not align with the available data, system capabilities, or intended business outcome
- Analyze source-system data and API documentation to determine whether the necessary objects, fields, identifiers, events, and levels of detail are available
- Communicate technical constraints, tradeoffs, data limitations, and scope boundaries clearly as stakeholder requests and project priorities evolve
- Write advanced, performant SQL to transform, combine, and prepare data in Snowflake
- Develop Snowflake stored procedures and supporting utilities using Python, JavaScript, or Snowflake Scripting, with Python as the preferred language
- Evaluate generated or externally supplied code for correctness, maintainability, performance, security, and alignment with engineering standards
- Work within established development practices, including Git, version control, peer review, automated testing, and CI/CD
- Troubleshoot source-data and integration issues in collaboration with internal engineers and external vendors
REQUIREMENTS
- Approximately five or more years of relevant professional experience in analytics engineering, data engineering, marketing data, or a closely related role
- Professional, hands-on experience working with Google Analytics data in a business or production environment; Coursework, certifications, or self-directed learning without applied work experience are not sufficient
- Professional experience supporting data in a retail or ecommerce environment
- Advanced SQL skills and hands-on experience designing fit-for-purpose data models, transformations, and materializations in Snowflake
- Working proficiency in Python, including the ability to read, evaluate, troubleshoot, and improve code written by others
- Experience reviewing API documentation and mapping API objects, endpoints, fields, and identifiers to business requirements
- Experience with Git and version-controlled development practices, including code review, testing, and CI/CD
- CDP implementation or ongoing CDP data enablement, customer 360 data models, identity resolution, or audience activation
- Event-level web behavioral data, cross-channel or cross-device identifiers, and marketing attribution data and concepts
- Anonymous-to-known identification, consent and privacy requirements, and audience eligibility or suppression logic
- Google Ads, Meta Ads, email, SMS, loyalty, or other paid-media and marketing technology platforms
- Building or maintaining API-based ingestion processes
- Demonstrated ability to elicit requirements from stakeholders, bring structure to ambiguous or nonlinear discussions, and translate business needs into precise, actionable technical work
- Strong understanding of data validation across multiple stages of a data pipeline
- Ability to work independently, exercise sound technical judgment, and recognize when requirements or proposed solutions do not make sense
- Exceptional written and verbal communication skills