Data Engineer

Position #1 : Automation Engineer – 6+ years of experience in automation engineering, data analytics, or a similar role • Plano (Primary) 8181 Communications Pkwy, Plano, TX 75024 575 • NYC (secondary) 400 W 31st St, New York City, NY 10001 • Chicago (secondary) 10 S Dearborn St, Chicago, IL 60603 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). • Financial service industry experience