*Sr Business Analyst (SQL) needed * *3-6+ months *
* NY* *Must have at least 7 years of data warehouse/BI experience. Must have strong experience with writing SQL code. * *Sr. Business Analyst* - Translate business requirements into functional requirements and solution end-to-end database development in a BI environment supporting 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 - 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 *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 *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. *Preferred * • Knowledge of Marketing Solutions – Aprimo/Unica/Neolane/SAS a plus • Working knowledge of ETL tools (ex. Informatica, Golden Gate, etc.) a plus *Thanks and Regards* *Shweta Ojha* Technical Recruiter | Sage Group Consulting 3400 Highway 35 S,Suite# 9,Hazlet, NJ,USA 07730 *Direct*: 732-784-6492 | *Email*: so...@sagetl.com *Gtalk*: sojha1290|*Yim*: ojha1290 -- You received this message because you are subscribed to the Google Groups "USITCV" group. To unsubscribe from this group and stop receiving emails from it, send an email to usitcv+unsubscr...@googlegroups.com. To post to this group, send email to usitcv@googlegroups.com. Visit this group at http://groups.google.com/group/usitcv. For more options, visit https://groups.google.com/d/optout.