Automation Engineer
Position: Automation Engineer – 6+ years of experience in automation engineering, data analytics, or a similar role
Locations: Plano (Primary) Plano, TX 75024 575, NYC (secondary) New York City, NY 10001, Chicago (secondary) Chicago, IL 60603
Start Date: 11/3/25
Project Duration: 9 months
Work from Office: 5 days in a week
Job Responsibilities:
- Collaborate with stakeholders to understand business objectives and translate them into analytical solutions.
- Extract, integrate, and harmonize data from diverse internal and external sources—including databases, files, and APIs—using advanced SQL and SAS techniques. Develop, debug, and optimize SAS/SQL code to accurately define target populations for campaign initiatives.
- Work with analysts to evaluate campaign performance, identify trends, and uncover actionable insights.
- Develop and implement scalable data wrangling and transformation pipelines using Alteryx and Python, with a strong focus on maintaining data quality, consistency, and integrity at every stage of the workflow.
- Design and implement automated workflows for data ingestion from diverse sources (internal databases, external files, APIs, etc.).
- Continuously improve automation processes to enhance efficiency and scalability.
- Build, maintain, and optimize interactive Tableau dashboards and reports to visualize post-campaign performance and insights.
- Document processes, workflows, and best practices for knowledge sharing and future reference.
- Communicate findings and recommendations effectively to both technical and non-technical audiences.
Required Qualifications, Capabilities, and Skills:
- Bachelor’s degree in a quantitative or related field (e.g., Computer Science, Statistics, Applied Mathematics, Business with quantitative focus).
- 6+ years of experience in automation engineering, data analytics, or a similar role.
- Proficiency in Alteryx and Python (or similar tools) for workflow automation and data transformation.
- Advanced skills in Python & SQL for data manipulation and analysis.
- Proven experience with Tableau (or similar visualization tools) for dashboard/report development.
- Solid understanding of data ingestion techniques and ETL processes.
- Ability to interpret complex data sets and deliver actionable insights.
- Excellent problem-solving, communication, and presentation skills.
- Ability to articulate root causes, comfortable escalating concerns, proactively raises concerns when timelines are in jeopardy of not being met
- Excellent time management and ability to prioritize with strong organizational skills and attention to detail
- Ability to learn the business, innovate by designing new processes, and effectively consult on the design and execution of marketing programs
- Effective communication with all parties at varying levels of analytical/technical understanding is also critical to success in the role.
Preferred Qualifications, Capabilities, and Skills:
- Familiarity with cloud platforms (AWS, Snowflake, Athena) and data storage solutions.
- Knowledge of campaign management and marketing analytics.
- Experience with version control systems (e.g., Git).