All candidates must be directly contracted by ASK Consulting on their payroll and cannot be subcontracted. We are unable to provide sponsorship at this moment .Job Title: Data AnalystLocation: New York, NYPay Rate: $60Job Description:Top Skills: SQL, Data Analysis, Communication-strong Media or Advertising industry experience. Key notes and Attributes: Responsibilities:
- Translate business requirements into SQL queries and Python scripts for Ad Hoc analysis and custom reporting solutions
- Explore data to identify client ad performance opportunities, trends and anomalies, contribute to new Client Data Solutions through custom analytics and coordinate reporting automation with other internal Product and Engineering teams.
- Architect data pipelines to connect different data sources
- Develop and maintain Extract, Transform & Load (ETL) processes
- Transform and cleanse outputs into meaningful analysis for business/sales teams
- Tune and optimize current code base and reporting solutions.
- Oversee documentation
Qualifications:
- 5 years in a related engineering/analytics work.
- Degree in computer science/engineering or quantitative discipline (Economics, Statistics, Engineering, Physics, Mathematics.)
- Strong SQL skills 5 years using SQL
- Snowflake or similar platform experience
- Python experience
- Big Data and Data/Technology methodology experience
- Stakeholder engagement experience
- BI Experience (Domo preferred)
- Exposure to Automation
- Experience with AWS tools such as IAM, Lambda, EC2 and S3.
- Jira, Confluence, GitHub and other agile development tool experience.
- Data privacy
Bonus:
- Familiarity with media, TV measurement
- Athena Experience
- Qubole Experience
- Salesforce Experience
- Vendor management
About ASK: ASK Consulting is an award-winning technology and professional services recruiting firm servicing Fortune 500 organizations nationally. With 5 nationwide offices, two global delivery centers, and employees in 42 states-ASK Consulting connects people with amazing opportunities ASK Consulting is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all associates.