Specialist III-IC Marketing Research

Responsibilities

• BMO Bank N.A. seeks a Specialist III-IC Marketing Research to develop and execute market research plans and strategies to align with the overall objectives of business/groups. Research procurement processes and monitor and execute market research plans. Partner closely with internal stakeholders to provide fact-based strategic insights and interpretation of research results. Synthesize and present information from various sources and provide a holistic perspective of research data including implications. Recommend and implement solutions based on analysis of issues and implications for the business. Conduct independent analysis and assessment to resolve strategic issues. Coordinate management of databases and ensure alignment and integration of data in adherence with data governance standards. Design and produce regular and ad-hoc reports and dashboards. Provide input into the planning and implementation of operational programs. Gather and analyze data about a market for a particular product or service to include product research, consumer research, modes of distribution, promotion research, pricing, surveys, advertising and public relations. Conduct analytical, quantitative, reporting and investigative functions to interpret data, formulate reports and make recommendations.

Requirements

• Master’s degree in Information Technology & Management, Computer Science or related field (willing to accept foreign education equivalent) plus two (2) years of experience as Business Analytics and Reporting Specialist, Business Intelligence Analyst or related occupation, developing market research plans, analyzing data, and providing strategic insights to support business objectives OR Bachelor 's degree in Information Technology & Management, Computer Science or related field (willing to accept foreign education equivalent) plus five (5) years of experience as Business Analytics and Reporting Specialist, Business Intelligence Analyst or related occupation, developing market research plans, analyzing data, and providing strategic insights to support business objectives. Experience must include (quantitative requirements not applicable to this section): • Reviewing, developing, and troubleshooting SAS code including writing macros, formats, and reports; • Utilizing UNIX server file commands, file permissions, and cron scheduling; • Developing advanced SQL code including CTEs, windowing, partitioning, DDL, and DML; • Combining, validating, and synthesizing data sourced from multiple database types including Netezza, Sybase, DB2, or Hadoop, and multiple structured/unstructured data sources; including flat files, screen scrapes, Excel, or CSV;   • Utilizing data visualization, influencing, and story-telling in MS PowerPoint; • Building and maintaining critical data processes; • Leveraging data analytics to translate strategic business objectives into actionable initiatives that drive measurable outcomes; and • Designing, building, and maintaining data pipelines, ETL/ELT processes, and analytics infrastructure across diverse environments and technologies. Commutable distance to Chicago, IL; 4 days in office per week.