Plotly Dash Skills: Build advanced data visualization with Plotly Dash
Company: a4Advertising
Title: Senior Data Analyst
Category: Full Time
Location: Queens, NY, USA
Experience: Mid level
Application: Link to apply
The Data Solutions Team
The Data Solutions Team is a core part of a4 Media. Our team incorporates data engineering, data management, data onboarding and data analysis into a singular group. We are the data specialists that ensure the highest operational efficiency of reporting and analytics within the organization.
Senior Data Analyst
The Senior Data Analyst will be responsible for working with various data sets utilizing advanced scripting and SQL queries to support Data Solutions team initiatives including, but not limited to custom onboarding, custom segmentation, data quality and ad hoc requests. The Senior Data Analyst will ensure compliance with Data Solutions team requirements by extracting data and performing data quality audits and analyses. The Senior Data Analyst will also utilize other research tools to support various functions within the organization. This position will require interacting across teams, including Client Services, Data Management, Engineering and Product and will require the ability to effectively communicate often complex data analytics to a variety of audiences.
Required Tasks And Duties
- Work with large data sets in an advanced database structure (Google BigQuery, Athena, etc)
- Write advanced SQL queries for data analysis and reporting, and build Python scripts for process automation
- Identify automation opportunities within current analytics processes and work closely with EIT to implement the solution
- Perform comprehensive deep dive analysis to identify data quality issues and code reviews for junior members on the team
- Build advanced data visualization (Tableau, DOMO, or other applications. Plotly dash, matplotlib, bokeh, seaborn, etc.)
- Document development of information, data architecture and process flows
- Interpret scope-of-work and execute custom analytics projects
Qualifications
- Bachelor’s /Master’s Degree in Computer Science/Computer Engineering/Information Science/Mathematics or related field or equivalent job experience. (Graduate degree in related field preferred)
- Minimum of 2 years professional experience in a technical/data analyst role in a data driven environment
- Strong SQL programming skills, data structure in relational databases, data manipulation and transformation knowledge required
- Strong Python programming skills to read/write scripts and troubleshoot data issue required
- Advanced Excel, data visualization or dashboarding skills preferred
- Basic statistical analysis experience (e.g., R, Weka, etc) and statistical concepts (e.g., regression, hypothesis testing, etc.) is a plus
- Experience with tools designed for efficiently transferring bulk data and parallel processing of data stored across data environments is a plus
- Excellent communication and presentation skills with the ability to translate business objectives into technical requirements and communicate with various teams and stakeholders
- Ideal candidates have experience working in Media, Television or Digital Marketing
Fundamentally, we consider our Senior Data Analysts to be problem solvers and information producers. Provided you are motivated by using data and a technical toolkit to solve complex problems to aid in strategic decision making, you will fit right in!