Sr Marketing Advanced Analytics

Job Description • Design, build, and maintain scalable and auditable data pipelines using Databricks (Spark/Scala/Python/SQL) and Snowflake • Own the data validation lifecycle-including source-to-target reconciliation using Oracle, data profiling, and anomaly detection • Conduct deep-dive data mining to uncover patterns, inconsistencies, and opportunities for business action. • Develop and maintain data visualizations and dashboards in Tableau to support transparency and decision-making • Implement data quality checks and automated alerting for pipeline failures, anomalies, and audit flags • Collaborate with analysts, scientists, and business stakeholders to gather requirements, and deliver reliable data products. • Optimize existing pipelines for performance, scalability, and operational simplicity • Document data lineage, pipeline logic, and metadata clearly and consistently Qualifications • Hands-on experience designing and maintaining scalable data pipelines using Databricks (Spark/Scala/Python/Sql) and Snowflake • Strong SQL development skills for data extraction, transformation, and performance tuning • Ability to conduct source-to-target data reconciliation, auditing, and anomaly detection across large datasets • Proven experience troubleshooting Spark performance issues • Expertise in Snowflake data loading and update patterns • Tableau dashboard development, including parameters, performance optimization, and data-driven visualization • Solid understanding of data validation lifecycle • Ability to document pipelines, workflows, and requirements Preferred Qualifications • Familiarity with advanced data profiling, anomaly detection techniques, and predictive modeling for identifying inconsistencies • Experience collaborating with business stakeholders to translate analytical requirements into reliable data products • Knowledge documenting data lineage, pipeline logic, and metadata management practices • Strong communication skills with the ability to clearly explain technical findings to non-technical stakeholders • Demonstrated ability to work independently with minimal oversight while managing priorities effectively Benefits Healthcare Insurance: Synectics offers eligible employees and their dependents healthcare coverage through BlueCross BlueShield of Illinois. Eligibility begins on the 1st day of the calendar month following 60 days of continuous full time employment with Synectics. Premiums are subsidized by Synectics. Dental Insurance: Synectics offers eligible employees and their dependents a dental plan through MetLife. Eligibility begins on the 1st day of the calendar month following 60 days of continuous full time employment with Synectics. Vision Insurance: Synectics offers eligible employees vision insurance through VSP. Eligibility begins on the 1st day of the calendar month following 60 days of continuous full time employment with Synectics.401(k) Plan: The Synectics Inc. Investment Savings Retirement Plan. Synectics offers all employees who are 21 years of age or older the opportunity to invest in the 401(k) Plan on the first enrollment date that is at least 30 days after employment begins. Enrollment dates are each January 1st, April 1st, July 1st, and October 1st. Technical Certification Bonus: Synectics is pleased to award its employees a bonus of up to $500 for an approved professional certification. In determining the bonus amount, Synectics will consider the cost of the test(s) for any certification relating to your current position, achieved during your employment with us. Only one Certification Bonus per calendar year may be awarded per employee. Only current, active employees will be eligible to receive this bonus. It will be awarded 90 days after the Synectics office has received documentation confirming the successful completion of the certification. Synectics is an equal opportunity employer.