Data Analyst and Administrator

Alterra Mountain Company is hiring a Data Analyst, Marketing with 3 - 5 years of experience. Based in United States - Denver, CO and with Hybrid ways of working. Job description and responsibilities: The Data Analyst will support the marketing team by providing data driven insights regarding customers, markets, competitors, and campaign effectiveness. This position will provide analysis on a formal and ad hoc basis and will develop reporting that is as standardized and automated as possible with the objective of measuring performance and supporting business decisions. The Data Analyst will be an expert in management and querying of large data sets to drive business decisions. Modeling, joining data, querying large data sets, automation of data processes, and development of reporting/dashboards are core functions of this role. In addition, support of research functions and the management and analysis of survey data and management of guest sampling for survey research will be important aspects of this role.Essential Duties• Employ CRM databases to analyze email and direct marketing campaign performance. Analyze marketing metrics to identify cause-effect relationships between marketing actions and financial outcomes to increase profitability.• Query data tables and create new data tables using SQL to provide analysis of market segments and product types to help optimize marketing performance and support strategic decisions. Proactively suggest analysis and research based on business objectives.• Connect data across multiple touchpoints of the customer journey to drive insights for marketing campaigns that ultimately results in incremental revenue. Ability to connect CRM, social, web, and transaction data in a compelling and consistent manner to evaluate marketing campaign performance.• Development of consistent approaches and tools for customer segmentation reporting and support in building, maintenance and analysis of customer segmentation.• Design and implement ad-hoc research and data analysis that answer specific business questions.• Create compelling data visualizations, using tools such as Tableau, to report and present analysis on marketing efforts and segmentation results. Communicate findings with diverse stakeholder groups. Automate reporting processes.• Support the research function of the organization with data analysis and management from survey research. Manage sampling and data structures for surveys. Deliver insights from survey research programs and data as charts, graphs, and PPT presentations.• Analyze and organize available data across multiple resorts and business units. Inspect, clean, and transform data while maintaining perspective on the relevant business questions.• Support and help guide best practices for development of predictive analytics.• Identify strategic recommendations based upon data and research.• Complete competitive analysis on the industry.• Other duties as assigned.Requirements and qualifications:Competencies & Job RequirementsRequired:• Marketing: Knowledge of marketing, sales, and business processes. Experience extracting marketing data, combining and joining to provide insights. Experience combining data across marketing channels: CRM, web, social, research, media, app, etc. for the purposes of evaluating marketing effectiveness.• CRM Database: Experience using data tables from CRM databases to identify key insights, create reports, and analyze customer behavior. Ability to extract data using SQL and create new, consistent data tables using SQL.• Organization: Demonstrate ability to proactively prioritize needs, put first things first, and effectively manages resources and time. Excellent organizational and problem-solving skills with the ability to handle multiple tasks. Ability to project manage and prioritize.• Analytics: Proven experience providing analysis and insights that had meaningful influence on strategies. Demonstrated success working with large and complex data sets. Experience building queries manipulating data with SQL, Tableau, Python, R and similar platforms is essential. Experience with survey data, sampling, and reporting from survey programs.• Data Visualization: Ability to create reporting and data visualizations in Tableau. Ability to create straightforward visualizations for PPT presentations.• Communication: Able to communicate effectively in writing and verbally across all levels of the organization. Able to effectively present information to management, employees, and customers.• Reasoning Ability: Able to make independent judgments which have considerable impacts on the organization. Able to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists. Strong sense of curiosity needed.• Advanced user with Microsoft Office suite (specifically Excel and PowerPoint).• A team player who excels in a fast-paced environment and can operate with limited or general supervision. Able to navigate ambiguity and create new processes as warranted.Preferred:• Experience with customer segmentation.Education & ExperienceRequired:• Bachelor’s degree in related field required (marketing, business, business analytics, finance, economics, mathematics).Preferred:• MBA or master’s degree in related field preferred.Work ExperienceRequired:• 3-5+ years of experience in marketing analytics and market research.• Equivalent combination of education and experience