Dow Jones and Company, Inc. seeks Lead Data Analyst in New York, NY.Write SQL queries and Python scripts to extract, clean, and process large datasets from cloud-based data pipelines (Big Query and AWS Athena) for analytics and reporting. Develop and automate audience analytics reports across multiple Dow Jones products using Adobe Analytics and Report Builder to support ongoing business needs. Communicate key analytical insights and findings to both internal stakeholders and external clients to support data-driven decision-making. Validate Key Performance Indicators (KPIs) and share estimated revenue reports, ensuring data accuracy and consistency across multiple business reporting systems. Regularly monitor ad impressions and campaign performance metrics to identify high-impact ad channels, articles and effective creative formats for maximizing ROI. Perform statistical analyses on user engagement data to predict behavior and optimize the allocation of limited ad impressions. Build and refine statistical models in Python to analyze ad performance and optimize media spending for sponsored content campaigns. Apply clustering techniques and sentiment analysis on editorial content to provide trending content themes based on audience segmentation. Collaborate closely with cross-functional teams marketing, product, and sales to ensure analytical insights inform strategic business initiatives.Requires a Bachelors degree in Business Analytics, Statistics, Data Science, or a related field, plus 5 years of experience. Requires 5 years of experience in the following: Developing automated business intelligence dashboards and reports using tools Adobe Analytics and Report Builder; Writing advanced SQL queries to extract, transform, and analyze large datasets from relational databases or cloud data warehouses; Programming in Python for data processing, automation, and building predictive or statistical models for business analytics; Data visualization techniques, communicating and presenting analytical insights to marketing, sales, and product stakeholders, including the ability to translate technical findings into actionable business strategies; Cloud-based data pipelines (Big Query or AWS Athena) for ingesting, cleaning and transforming structured and unstructured data; Applying statistical modeling to predict user behavior and optimize syndicated ad performance; Auditing and validating traffic and estimated revenue reports, ensuring data accuracy and consistency across multiple business reporting systems; Working cross-functionally with marketing, product and sales teams to translate analytical findings into strategic recommendations; andRequires 4 years of experience in the following: Applying sentiment analysis and natural language processing (NLP) techniques to analyze textual data for business insightsAlternatively, the employer will accept a Masters degree in Business Analytics, Statistics, Data Science, or a related field, plus 3 years of experience. Requires 3 years of experience in the following: Developing automated business intelligence dashboards and reports using tools Adobe Analytics and Report Builder; Writing advanced SQL queries to extract, transform, and analyze large datasets from relational databases or cloud data warehouses; Programming in Python for data processing, automation, and building predictive or statistical models for business analytics; Data visualization techniques, communicating and presenting analytical insights to marketing, sales, and product stakeholders, including the ability to translate technical findings into actionable business strategies; Cloud-based data pipelines (Big Query or AWS Athena) for ingesting, cleaning and transforming structured and unstructured data; Applying statistical modeling to predict user behavior and optimize syndicated ad performance; Auditing and validating traffic and estimated revenue reports, ensuring data a
