Lead Business Data Analyst

US-NY-New York
1 month ago
Job ID
Business Analyst
Position Type
Contract (Full-Time)
# of Openings


The Lead Business 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 Sr. Manager, 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 Lead Business 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 Lead Business 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 Lead Business 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 Lead Business 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.


  • Produce functional requirements and solution end-to-end database development in a BI environment supporting Company’s Enterprise Marketing Management (EMM) solution
  • Leading, collecting and analyzing business requirements for large, multifunctional projects
  • Participating with other IT members, customers, and other stakeholders in new product reviews, tests, and pilots
  • Performing feasibility studies, translating requirements into an appropriate design
  • Identifying conflicting business practices and integration issues, suggesting alternative solutions
  • Fostering and maintaining good relationships with customers and IT colleagues 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 Company’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


Supervisory Responsibilities:

  • The person will not have supervisory responsibilities


Minimum Qualifications:

  • At least seven (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
  • Must have legal right to work in the U.S.


Technical Skills:

  • At least 4 years in writing SQL
  • 4+ 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



  • Knowledge of Marketing Solutions – Aprimo/Unica/Neolane/SAS a plus
  • Working knowledge of ETL tools (ex. Informatica, Golden Gate, etc.) a plus


Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Need help finding the right job?

We can recommend jobs specifically for you! Click here to get started.