Job Title

Title: Sales & Marketing AnalystReports to: Enterprise Data ArchitectSupervises: NoneStatus: ExemptObjectiveThe Sales and Marketing Analyst's role is to design data modeling/analysis services used to mine enterprise systems and applications for knowledge and information that support sales and marketing initiatives. This individual is also responsible for assisting in building, deploying, and maintaining data support tools, metadata inventories, and definitions for database file/table creation. This role will partner with key stakeholders in Sales and Marketing to support the overall business needs of these departments, including but not limited to sales and marketing performance reporting, goal maintenance, lead management, sales pipeline management, sales incentive support, sales and marketing campaigns analysis, sales contests, sales portfolios, market and branch analytics, member trends, and CRM management. The position requires strong knowledge of financial products, such as loans and shares.Duties and ResponsibilitiesDevises, develops, and deploys required data queries in response to strategic objectives, business initiatives and business needs to understand and improve conjunction with data owners and department managers, develops data models and protocols for mining production databasesAssists in the development of data management policies and procedures.Identifies research questions, problem solves using data analysis, and communicates the results to various stakeholdersCollaborates with cross-functional teams to understand data requirements and implement solutions that meet business needsQueries and extracts data from KEMBA's data warehouse (Snowflake), Jack Henry core, and related systems to support marketing and sales requestsDevelops and maintains recurring dashboards and reports in Power BI that visualize key marketing and sales metrics (member growth, product penetration, campaign ROI, pipeline conversion, etc.)Automates and optimizes recurring data processes, improving accuracy and efficiency across departmentsPartners with Marketing to build and analyze campaign performance reports (digital, direct, branch, and product campaigns)Supports Sales leadership with dashboards and data pulls that track pipeline activity, conversion rates, and member engagementIdentifies opportunities for cross-sell, upsell, and member segmentation using existing dataProvides ad-hoc analysis and recommendations to guide strategic initiatives such as deposit growth, loan acquisition, or branch performanceAccurately inputs, updates, and maintains data within manual tables as needed to support reporting requirementsBuilds and maintains sales performance reporting suite, such as scorecards, with supporting detail and trend viewsProcesses data corrections that impact sales performance results to ensure incentive can be calculated and paid on time; researches associate questions about sales results and solve any upstream data issuesOwns Sales Lead Development, Distribution and Reporting; creates ad hoc calling leads; loads leads into leads tool, maintains and analyzes lead campaign effectivenessIdentifies and communicates the time and resources needed to achieve required resultsWorks closely with data governance teams to enforce data policies and standardsAssists in the design of databases and data warehouses to ensure interoperability with BI solutionsCommunicates complex technical concepts to non-technical stakeholders in a clear and understandable mannerConducts job duties and responsibilities according to the organization's business systems development methodology and/or its Systems Development Life Cycle (SDLC) meth