Job Information
The John Gore Organization Data Warehouse Specialist in New York, New York
Write complex SQL queries to extract and manipulate Audience data from the data warehouse and design/maintain Tableau dashboards and reports, emphasizing the visualization of audience demographics. Extract targeted lists with a focus on customer data using SQL queries while ensuring data accuracy for executive reports and marketing campaigns. Collaborate with data vendors to enhance the accuracy and stability of Audience data in the data warehouse, while documenting and implementing best practices for data hygiene and consistency. Collaborate with cross-functional teams to understand and incorporate specific reporting requirements, and automate the generation of Customer reports to streamline processes. Apply data mining and statistical techniques to identify trends and insights, providing strategic recommendations based on data findings. Implement robust monitoring processes to identify and rectify data anomalies, while diagnosing and troubleshooting errors in data processing to maintain accuracy. Offer insights to marketing teams on SQL-based segmentation strategies, emphasizing demographic attributes, and actively contribute to the implementation of effective demographic segmentation practices to enhance marketing impact.
Education: Masters degree in Computer Science, Information Technology & Management or a related field.
Must have the following skills:
SQL Programming and Relational Data Management Data Visualization (Tableau) and Exploration Analytical and Strategic thinking Conceptual and analytical reasoning