Skills

Communication Time Management Python Tableau SQL Problem-solving Presentation Skills Attention to detail Databases Organizational Skills Analytics ETL Processes Mathematics

Job Specifications

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.

About the Company

Established in 2012, Optomi is committed to providing superior IT Talent Services via contract, contract-to-hire, and team augmentation models. Our delivery teams are aligned by competencies focused on 7 key areas in technology: Business Optimization, Software Engineering, Cloud & Infrastructure, Cyber Security, Data Modernization, ServiceNow, and Emerging Technologies. Our skillset-focused approach allows our recruiting teams to become experts within their space and streamline the hiring process. We save you time and money ... Know more