Business Intelligence Analyst – Ads Insights

Business Intelligence Analyst – Ads Insights

• * W2 Contract, Minimum of 12 months (Expected to extend multi-year)** ONSITE out of NYC ** Target $58-64/hr **

Our client is seeking a skilled and experienced contractor to lead the creation of revenue and ads performance insights dashboards, while also supporting the maintenance of ETL processes. The ideal candidate will have 5-7 years of experience in data analysis, writing SQL for analytics, data visualization, dashboarding, and collaborating with commercial stakeholders. This role will involve working with Sales to bring insights and ideas to life.

What You’ll Be Doing

• Primary Role: Create revenue and ads insights dashboards, ensuring data accuracy, usability, and alignment with business needs in collaboration with Sales.
• Secondary Role: Understand business logic and help in maintaining complex ETL processes, ensuring code integrity and workflow efficiency.
• Understand business context and translate insights into actionable visualizations.
• Develop visualizations to support strategic initiatives and operational workflows.
• Work on data transformation to support reporting platforms and data warehouses.
• Monitor, test, and maintain ETL processes, ensuring data processing workflows are error-free.
• Provide ad hoc support and insights to drive results across the organization.
• Prioritize tasks to meet key deadlines in a fast-paced environment.

What You Bring

• Bachelors degree
• 5-7 years of experience in data visualization, dashboard creation, SQL for data analysis.
• Intermediate to advanced SQL for data analysis skills required.
• Nice to Have: 1-2 years of experience using Python for data analysis.
• Experience with BI tools such as Tableau, DOMO, and Quicksight.
• Familiarity with data warehousing systems and ETL processes.
• Nice to Have: Experience in advertising/marketing, healthcare or insurance industries
• Strong organizational, interpersonal, and communication skills.