The Sr. Business & Data Analyst will be an individual contributor to the development, maintenance, and enhancement of the Enterprise Marketing Database, providing overall business knowledge to projects and support. This position will be assigned to many projects within the Enterprise Marketing Management Development group. Under the guidance of a Lead Analyst, he/she collaborates with company customers, staff members, IT colleagues, and other stakeholders to define detailed customer requirements and system interfaces, assess available technologies, and develop and present solutions. The Sr. Business & Data Analyst acts as an internal consultant, providing business process expertise and technical guidance on the most complex projects or researching strategic planning matters. This position requires broad knowledge of data sources, data integration and data flow as well as a high degree of creativity and latitude, working at an in-depth level within a business area. The Sr. Business & Data Analyst acts as the subject matter experts in the business areas assigned, in terms of both business applications and business processes. The individual in this position should be familiar with project management techniques and possesses good communication skills. The main challenge for the Sr. Business Systems Analyst is identifying causes and implementing solutions to business problems in a multifunctional project, assessing and communicating issues of technology impact on the business. The Sr. Business Systems Analyst must understand the procedures and expected system performance associated with the introduction of new information technologies, while seeking ways to collaborate with other IT members to facilitate transitions. He/she shares responsibility with other team members to ensure on-time, high quality product delivery.
Duties and Responsibilities: • Translate business requirements into functional requirements and solution end-to-end database development in a BI environment supporting client’s Enterprise Marketing Management (EMM) solution • Review multifunctional projects for potential EMM impact • Lead, collect and analyze business requirements for large, multifunctional projects • Participate with other IT members, customers, and other internal / external stakeholders in new product reviews, tests, and pilots • Perform feasibility studies / proof-of-concept; translate requirements into an appropriate design, incorporating technical detail • Identify conflicting business practices and integration issues, suggesting alternative solutions / collaborating with stakeholders for buy-in/approval • Present proposed approach / solution to key stakeholders • Foster and maintain good relationships with customers and IT colleagues (internal / external) to meet expected customer service levels • Document processes and mentor development staff through the software development lifecycle process • Work with BI Architecture and Innovations group to craft solution for data integration and business layer • Analyze new data sources for integration into client’s EMM solution – structured/semi-structured and unstructured data from various sources in support of the electronic marketing management tools and other related systems • Work with BI Operations Tier I and Tier II teams to ensure control objectives are implemented for all data movement processes, implement change control for production data ,establish and follow proper incident management procedures • Ensure compliance with all applicable data privacy regulations and policies as they relate to both firm and client/contact data
Qualifications: • At least ten (7) years of experience with writing functional requirements, data warehouse experience required • Bachelor’s degree in Computer Science, Information Systems or related course of study required or equivalent work experience
Requirements and General Skills: • Solid experience writing SQL • Ability to manage multiple assignments simultaneously and follow up on unfinished business • Excellent data analysis skills • Experience deploying self-service capabilities in campaign management and Reporting/BI • Experience integrating marketing technologies with both internal and external data sources • Demonstrated ability to manage multiple projects with competing deadlines and priorities • Goal oriented and creative personality with good interpersonal skills • Ability to work independently and in a team environment • Ability to pay attention to details and be organized • Commitment to “internal client” and customer service principles • Ability to handle multiple tasks in a fast paced environment • Willingness to take initiative and to follow through on projects • Excellent time management skills, with the ability to prioritize and multi-task, and work under shifting deadlines in a fast paced environment
Mandatory • Proficiency in writing SQL • 3+ years experience with Teradata, Oracle, SQL Server or similar database platform • Thorough knowledge of MS-Office Suite (Word, Excel, PowerPoint) • Experience implementing best practices for EDW development
Preferred • Knowledge of Marketing Solutions – Aprimo/Unica/Neolane/SAS a plus • Working knowledge of ETL tools (ex. Informatica, Golden Gate, etc.) a plus