Job Description
Job Description
- This position is on-site in Costa Mesa, California. No relocation is available at this time.
- This position requires work eligibility without any visa requirements.
- Strong SQL and Tableau skills required.
As a Business Intelligence Analyst within the Marketing department, you will use product and market knowledge to segment members and prospects; generate marketing lists and campaigns using various internal and external data sources. Track, measure, monitor, analyze, and interpret performance data related to marketing, member acquisition, product acquisition and usage, profitability, ROMI, and more. Collect and analyze data on all marketing efforts (traditional, digital, and alternative) and acquisition channels. Perform competitive analysis.
ESSENTIAL RESPONSIBILITIES :
Identify target segments and create marketing lists for email, direct mail, digital advertising, calling, and more, based on department or organizational goals and criteria. Utilize Segmint, Raddon, data warehouse, and other tools for segmentation.Work with Marketing staff to provide queries, data, or other assistance needed to deliver personalized promotions, trigger-based messages, and drip campaigns.Query the internal Data Warehouse to extract data for analysis and segmentation using MS-SQL; integrate other data sources and tools as needed.Collaborate with the Marketing team to deliver dashboards and analytics providing data-driven insights into marketing goals, campaign results, open rates, click-throughs, campaign funnels, and ROMI.Work with Business Intelligence and Marketing to integrate external data sources (such as Google Analytics) into comprehensive Tableau dashboards.Create monthly reporting of marketing efforts (traditional, digital, & alternative).Monitor results and effectiveness of marketing automation programs and work with the Marketing team on enhancements as appropriate.Collaborate with other members of the Business Intelligence team to coordinate data importing, reporting, and other tasks.Manage the monthly updating of the Raddon MCIF system.Contribute to marketing research and planning.Participate in other Business Intelligence projects and work on projects for other operational areas as needed.Perform other duties as assigned or requested.EDUCATION / EXPERIENCE :
BA or BS degree and 2 years of related experience in marketing data analysis, digital marketing, business intelligence, or an equivalent combination of education and experience. Proven experience with marketing segmentation and marketing automation in a financial services environment preferred.Proficiency in MS-SQL, Tableau, and Excel required. Experience with marketing automation platforms and marketing mix models is highly preferred. Familiarity with additional analytical tools such as SPSS and Google Analytics, and knowledge of Raddon MCIF and Symitar Episys is a plus.Must be a self-starter with the ability to work with little to no direct supervision. Requires strong marketing, analytical, and communication skills. Demonstrated experience working with marketing segmentation and analysis, working with data; problem-solving skills; and the ability to gather, analyze, and present data in a usable / meaningful manner.Company Description
At Crown Universal, we are dedicated to delivering exceptional service that meets the unique needs of our clients, ensuring meticulous attention to detail in every task we undertake. We are working closely with one of our partner organizations in Costa Mesa to find their next top hire.
Company Description
At Crown Universal, we are dedicated to delivering exceptional service that meets the unique needs of our clients, ensuring meticulous attention to detail in every task we undertake. We are working closely with one of our partner organizations in Costa Mesa to find their next top hire.
