What are the responsibilities and job description for the Python Developer position at PeopleCaddie?
Job Title: Python Automation Analyst (Contract)
Company: Big Four Client
Location (onsite): (1) Plano, TX [Preferred], (2) New York, NY, or (3) Chicago, IL
Work Authorization: U.S. Citizen or Green Card Holder
Pay Rate: Max of $53 per hour (W2)
Duration: 7 Months
Overview:
We are seeking a Python Automation Analyst to deliver scalable data automation and analytics for marketing and campaign initiatives. The ideal candidate has at least 6 years of hands-on experience with Python, SQL, and Tableau, plus strong proficiency in Alteryx and SAS for data manipulation and campaign targeting. You will partner closely with stakeholders to translate business objectives into automated data pipelines and actionable dashboards.
Key Responsibilities:
- Collaborate with stakeholders to understand business objectives and deliver analytical solutions.
- Extract, integrate, and harmonize data from diverse sources using advanced SQL and SAS.
- Develop/debug SAS/SQL to define campaign target populations.
- Evaluate campaign performance with analysts to identify trends and insights.
- Build scalable data wrangling/transformation pipelines using Alteryx and Python.
- Automate workflows for data ingestion from databases, files, APIs.
- Continuously improve automation for efficiency and scalability.
- Develop and optimize Tableau dashboards/reports for campaign insights.
- Translate business requirements into technical specifications and delivery plans.
- Implement robust testing, logging, and monitoring for automated workflows.
- Document data flows, code, and dashboards to support maintainability and knowledge transfer.
Required Skills & Qualifications:
- Bachelor’s in a quantitative field (Computer Science, Statistics, Applied Math, Business with quantitative focus).
- Minimum 6 years of hands-on experience with Python, SQL, and Tableau building production-grade automation and analytics solutions.
- Proficient in Alteryx and Python for automation and transformation.
- Strong SAS programming skills for data manipulation and campaign selection.
- Advanced SQL expertise (complex joins, window functions, performance tuning) across large, complex datasets.
- Experience integrating data from APIs, files, and databases; solid understanding of ETL/ELT best practices and data quality controls.
- Ability to design clear data models and transform raw data into curated datasets for analytics and reporting.
- Strong communication skills and stakeholder management; experience working in Agile environments.
Preferred Skills & Qualifications:
- Familiar with cloud platforms (AWS, Snowflake, Athena) and data storage.
- Knowledge of campaign management and marketing analytics.
- Experience with Git/version control.
- Financial services industry experience.
- Experience with job schedulers/orchestration (e.g., Airflow, Control-M) and Tableau Server/Cloud administration is a plus.
Salary : $53
