Data Analyst

Top skills: 1. Designing data architecture in Snowflake 1. Analytics – SQL and Python-based data analytics/visualization tools 1. Presentation and communication skills Schedule: Hybrid, 3 days in office Summary: The main function of the Data Analyst is to provide business intelligence support and supporting areas by means of both repeatable and ad hoc reporting delivery reports (charts, graphs, tables, etc) that enable informed business decisions. Job Responsibilities: ? Analyzes performance of process activities, identifies problem areas, and presents findings in clear, concise charts, graphs, tables, or summaries. ? Establishes standardized methods of recording, tracking and reporting on activity. ? Design, implement, automate and maintain large scale enterprise data ETL processes. ? Modify existing databases and database management systems and/or direct programmers and analysts to make changes. ? Test programs or databases, correct errors and make necessary modifications. ? Conducts research on emerging products, services, approaches, and techniques in the area of data analysis. Skills: ? Strong interpersonal and consultative skills to translate and understand reporting requirements. ? Ability to work as part of a team, as well as work independently or with minimal direction. ? Excellent written, presentation, and verbal communication skills. ? Demonstrated knowledge of one or more key information service standards such as SDLC, ITIL, QA/testing, Project Management, Six Sigma, etc. ? Strong PC skills including knowledge of Microsoft SharePoint. Education/Experience: ? Bachelor's degree in a technical field such as computer science, computer engineering or related field required. ? 8-10 years of experience required. ? Process certification, such as, Six Sigma, CBPP, BPM, ISO 20000, ITIL, CMMI. KEY RESPONSIBILITES/REQUIREMENTS: We are looking for a strong data analyst/architect to support a specific ad tech project where we are setting up ingestion of data from various SSPs, combining it in our Snowflake environment, transforming it to be usable with our existing datasets and then supporting the business in generating insights and business decision support. • Understanding and architecting the incoming SSP data so that it can be combined with existing data and be leveraged to improve processes and decisions • Provide advice and guidance on data architecture best practices Analyze user behavior data and service usage data to provide insights per business, product and advertising ask • On an ongoing basis, analyze and report on service performance; develop dashboards to measure important metrics and monitor service growth • Support data collection/analytics implementation for new feature launches or new advertising campaigns, e.g. work with ad sales/product/engineering to identify and implement analytics and data requirements • Conduct complex statistical analysis to provide strategic insights for operational decisions, GTM, content/partnership strategies • Attend and participate in standups, brainstorm sessions, presentations as needed with the company's teams, executives or external partners Qualifications: • BS/MS in Computer Science, Statistics, Mathematics, Engineering or related field. • Proficient in data querying and manipulation in SQL. • Experience with cleaning, transforming, analyzing and visualizing medium to large sized data sets. • Experience with R/Python-based data analytics/visualization tools or similar languages. • Experience in ad tech field preferred. • Strong analytical skills and well versed in the use of data, content, and technology to draw conclusions and put results into practice. • Detail-oriented, with the ability to multi-task and prioritize multiple projects with competing deadlines • Team player with the ability to collaborate effectively across all levels of organization and with outside partners • Thrives in fast paced business environment with the ability to adapt to change