14 Jun
Business data analyst - SQL Datawarehouse and AWS/Redshift
New York, New york city , 10001 New york city USA

Vacancy expired!

· At least 2 years in writing SQL.

· At least 2 years of experience with Cloud (S3, Redshift, e.g.) or on-prem Database (Teradata, Oracle, SQL Server or similar database platform.

Position Summary:The Sr. Business & Data Analyst will contribute to the ongoing 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 group. This position 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.

Duties and Responsibilities:
  • Produce functional requirements and solution end-to-end database development in an Enterprise Data Office (EDO) environment supporting Enterprise Marketing Management solution.
  • Document processes and mentor staff through the software development lifecycle process.
  • Lead, collect and analyze business requirements for large, multifunctional projects.
  • Participate with other IT members, customers, and other stakeholders in new product reviews, tests, and pilots.
  • Perform feasibility studies, translate requirements into an appropriate design.
  • Identify conflicting business practices and integration issues, suggesting alternative solutions.
  • Foster and maintain 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 EDO Architecture and Innovations group to craft solution for data integration and business layer.
  • Analyze new data sources for integration into Marketing Database structured/semi-structured and unstructured data from various sources in support of the electronic marketing management tools and other related systems.
  • Work with 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:There are no supervisory responsibilities associated with this job.

Minimum Qualifications:
  • At least 3 years of experience with writing functional requirements, data warehouse experience required.
  • Bachelor/Associate degree in computer science, information systems or related course of study or equivalent, relevant experience.

Technical Skills:

· At least 2 years in writing SQL.

· At least 2 years of experience with Cloud (S3, Redshift, e.g.) or on-prem Database (Teradata, Oracle, SQL Server or similar database platform.· Thorough knowledge of MS-Office Suite (Word, Excel, PowerPoint).· Experience implementing best practices for EDW development.· Thorough knowledge of MS-Office Suite (Word, Excel, PowerPoint, Access).

Vacancy expired!


Related jobs

Report job