The Lead Business Systems Analyst is the key liaison between high profile clients and the Merkle Technology Teams. This is an extremely visible position, as the Lead Business Systems Analyst elicits and drives requirements at multiple levels of detail for Merkle clients. The Lead Business Systems Analyst should have a strong attention to detail and is entrusted with accurately documenting requirements and acceptance criteria for a project. Solutions are primarily centered on creating a CRM database / data warehouse, with daily data updates in a Merkle hosted environment.
Interface with the client, third-party vendors, and multi-disciplinary teams within Merkle (Data Warehouse Developers, Project Managers, Quality Assurance, Business Intelligence, and Information Technology) to support the solution delivery process.
Lead solution discovery sessions with the client stakeholders and subject matter experts as a means to elicit solution requirements, both business and functional
Synthesize complex and sometimes contradictory information into concise, readable, unambiguous written requirements at multiple levels of detail
Take primary ownership for written requirements specifications (Business and Functional), from initial creation, through change management and solution delivery
Profile and understand various client data (e.g. Customer records, Transaction records, Web Activity records) as it relates to stated requirements and solution design
Provide input to Project Management regarding schedule, scope, and cost tradeoffs
Serve as the functional point of contact for the solution during Design and Development, working through data and design questions/issues as they arise
Work closely with the QA discipline to define and execute a test plan, which will include internal and User Acceptance Testing
Lead the delivery of the system into production by designing and supporting the formal client acceptance process, according to Merkle’s defined standards
Maintain the solution in production, working with end users, and facilitating change requests with the broader team using a defined change management process
Qualified individuals possess the attributes of being smart, curious, committed to vision, passionate, fun/pleasant, an achiever and having a sense of urgency.
Bachelors Degree. Technology, science, and math backgrounds preferred but not required.
7+ years experience with writing detailed requirement specifications for data warehouse and/or database delivery
7+ years experience working with IT methodologies [e.g. Systems Development Life Cycle (SDLC) and/or Waterfall]
Ability to lead and coordinate people and activities (especially amongst other BSAs) throughout a full solution lifecycle
Fundamental understanding of relational database design concepts [e.g. table design, table relationships (e.g. one-to-one, one-to-many), primary and foreign key designations, etc.]
Knowledge of Customer Data Integration (CDI) processes and best practices
Postal address hygiene processes (U.S. and International)
Record level matching routines
Business-to-Consumer and Business-to-Business experience
Competency in writing and interpreting basic to intermediate SQL queries
Client management, expectation setting, and communication as it relates to the BSA function
Ability to arrive at creative solutions that are not readily apparent and to turn unclear facts into logical patterns and concepts
Ability to mentor and/or manage less senior BSA resources within the capability
Schedule flexibility in working with international offices and clients
Experience with Marketing, especially: Database Marketing, Direct Marketing, Email Marketing, Interactive Marketing
Industry/Vertical expertise (e.g. Retail, Insurance, Pharmaceutical, Business-to-Business, Financial Services, etc.)
Experience with test planning and use cases
Skilled with Word, Excel, PowerPoint, and Visio
Experience as an end-user with Business Intelligence tools such as Microstrategy, SAS, Business Objects, Cognos, etc.
Experience as an end-user with Campaign Management tools such as Unica, Alterian, etc.
Ability to thrive in a fast-paced environment and rapidly master complex data structures
Willingness to travel when necessary – Can be up to ~25%
Interest in furthering corporate and capability initiatives
Merkle Inc. - 4 months ago