F2F mandatory in NYC , local candidates only Minimum Qualifications At least seven (7) years of experience with writing functional requirements, data warehouse experience required Bachelorrsquos degree in Computer Science, Information Systems or related course of study required or equivalent work experience Produce functional requirements and solution end-to-end database development in a BI environment supporting Companyrsquos 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 Companyrsquos EMM solution ndash structuredsemi-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 clientcontact data 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 ReportingBI Experience integrating marketing technologies with both internal and external data sources Demonstrated ability to manage multiple projects with competing deadlines and priorities Technical Skills Mandatory 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 Preferred Knowledge of Marketing Solutions ndash AprimoUnicaNeolaneSAS a plus Working knowledge of ETL tools (ex. Informatica, Golden Gate, etc.) a plus Associated topics: business advisory, business intelligence, business systems, client, consultant, crm, customer, market, marketing, senior consultant
* The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.