Automation & Analytics Consultant

Overview: Optomi, in partnership with a leading consulting company, is seeking an Automation & Analytics Consultant to join their team. Qualifications: • Bachelor’s degree in a quantitative or related field (e.g., Computer Science, Statistics, Applied Mathematics, Business with quantitative focus). • 3+ years of experience in automation engineering, data analytics, or a similar role. • Proficiency in Alteryx for workflow automation and data transformation. • Advanced skills in Python or 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. • Excellent time management and ability to prioritize with strong organizational skills and attention to detail. 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.