Business Intelligence AnalystBookmark This
Business Applications System Analyst
Virginia Beach, VA
DescriptionJob Location: Virginia Beach, VA
Only US citizens
Contract Terms: 6 months
Business Intelligence Analyst
The Business Intelligence Analyst will be a key contributor to the performance marketing team, providing analysis and detailed insights on how our customers interact with our marketing programs and tracking the impact of our initiatives.
Primary Responsibilities include:
? Gather, consolidate, link and analyze data/ metrics from multiple sources such as site analytics, customer satisfaction studies, conversion rates, sales and revenue.
? Identify data issues and drive resolution with data owners.
? Respond to time-critical ad hoc requests and participate in on-going report creation, administration, maintenance, trouble shooting, tuning and end user support and data reconciliation for Microsoft SQL databases using Microsoft SQL Server Reporting Services (SSRS), Transactional SQL and ETL packages
? Analyze all aspects of Online Marketing programs and provide recommendations to improve performance; build and manage predictive models as needed.
? Develop customer/segment-level analysis to understand customer behavior
? Develop predictive response models and segmentation analysis to optimize email marketing efforts.
? Provide post campaign reports and analysis to assist the marketing team in measuring campaign effectiveness as well as performance of key customer segments.
? Forecast performance based on historical data and track results against forecast.
? Analyze impact of promotions and other marketing efforts.
? Work with vendors and internal technology partners to improve consistency and accuracy in reporting.
? Collaborate with partners and teams to improve data collection and web-based tracking.
? Strong skills in writing complex SQL queries and building Excel models
? 2-4 years of database analysis experience
? Expert in SQL, Google Analytics, APIs to online services, Business Objects, SQL Server, SSMS, SAS, SSRS, SSIS, SSAS, BIDS, Crystal Reports, Excel, Power Point,
? Extensive experience with relational database tables and structures including (but not limited to) creation of stored procedures, triggers, views, functions, indexes, SSIS scripts.
? Expertise in writing SQL for reports and data extraction
? Experience in developing and maintaining periodic reports and dashboards
? Ability to interpret data to drive optimization/improvements of marketing program.
? Excellent communication skills with ability to summarize facts, present ideas and turn data and information into insight that drives decisions
? Creative problem solver, passionate about winning and achieving results
? High degree of accuracy and very strong attention to detail
? Excellent written and oral communication skills
Preferred Experience, Skills &