Business Intelligence Analyst

Job title: Business Intelligence Analyst Work Location: One Pennsylvania Plaza, 26th Floor, New York, NY, USA Work Schedule: Fully Onsite Length of Assignment: 12 months (possible extension) Interview Process: Virtual - possibly on-site 3 rounds 1st round - Proof of technical chops - SQL 2nd round - Focus on exp, tell us about a time when, speak on work experience, i.e. dashboard creation 3rd round - Hypothetical questions- how would you work through the problem etc Top skills: Data visualization, Intermediate or advance SQL is a must have, Intermediate in Python a nice to have, Intermediate in Data ETL management a nice to have Industry experience preferred • Advertising/marketing experience #1 • Healthcare #2 • Finance #3 Key Requirements to see on resume: • Data modeling, cleaning data • Moderate skills in writing SQL, translating business and data needs • Data visualization and creating • Cross collaboration with sales nice to have • 50% of work will be doing back end ETL work • Day to Day: creating revenue and ad performance insight dashboards • Bachelor’s degree in Computer Science, Mathematics, Statistics, Economics, or a related quantitative and/or technical field. • 5-7 years of experience in data visualization, dashboard creation, SQL for data analysis. KEY RESPONSIBILITES/REQUIREMENTS: Position Overview: We are 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. Key Responsibilities: • 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. Qualifications: • 5-7 years of experience in data visualization, dashboard creation, SQL for data analysis. • Required: Intermediate to advanced SQL for data analysis skills. • Nice to Have: 1-2 years of experience using Python for data analysis. • Experience with BI tools such as Tableau and/or Quicksight. • Familiarity with data warehousing systems and ETL processes. • Strong organizational, interpersonal, and communication skills. • Bachelor’s degree in Computer Science, Mathematics, Statistics, Economics, or a related quantitative and/or technical field. Ideal Candidate: • Task-driven with the ability to meet deadlines in a fast-paced environment. • Ability to prioritize work effectively to align with business needs. • Collaborative team player with a proactive approach to problem-solving.