*HI BUSINESS PARTNERS,* * THIS IS SUBASH CHANDRA, - RECRUITMENT AND RESOURCES FROM NICO INFO SYSTEMS INC.*
*Description : * * * *Title : Data Architect/Marketing database Analyst* *Location : Tampa, FL* *Duration : Long term* *Rate : Open* * * * * *RESPONSIBILTIES* This position will be responsible for four key areas in support of MDS campaigns: *1. Campaign Management Infrastructure Support (60%)* Responsible for maintaining and enhancing key components of the MDS campaign management environment including: · Campaign management application support (Unica Affinium Campaign v7.5) including: table catalogs, strategic segments, custom macros and triggers, software upgrade; bug identification, reporting and resolution. · Maintenance and enhancement of campaign datamart in Teradata · Automated production campaign scheduling using AutoSys · Automated campaign auditing procedures utilizing Unix and BTEQ scripting · Produce contact lists/history in a timely prioritized manner · Manage Line of Business (LOB) source data files used for campaign targeting · Data provided back to MDS LOB partners for reporting and analysis · Coordination with production support teams such as: DBAs, ETL, Service Delivery, Data Security Office, and Risk & Compliance. · Ensure 100% compliant campaigns (i.e. CAN-SPAM Compliance) *2. Project Support (30%)* Be the primary person responsible for coordinating and conducting the efforts of the MDS team with other groups in ISG that may impact the MDS infrastructure or campaigns. This includes: · Assessing the impact at project inception · Planning and sizing based on project scope · Contributing to requirements, participate in appropriate stages of testing (including User Acceptance Testing) · Leading changes to MDS infrastructure in support of project rollout. *3. Campaign Execution Support (5%)* Backup resource in support of planned campaign development and execution. Provide issue remediation and subject matter expertise, share experiences/insights from projects/issues/reviews with other team members and training/mentoring campaign analysts. Work with the email vendors/LOB to audit and resolve issues related to transfer of data files. May require support during non-business hours. *4. Business and Data Analysis Support (5%)* Provide senior management with information, typically summarized, about the MDS datamart and overall C2T data warehouse. This information will be used to either help drive new marketing strategies or understand the impact of data modeling decisions. *REQUIREMENTS* Technical skills required for position: · 3+ years experience working with Unica Affinium Campaign as an analyst · 2+ years as either a Unica Administrator or Application Support Analyst · 4+ years experience working with working with large, complex data warehouses/data marts, specifically in Teradata · 4+ years of SQL and manipulating large datasets for business analysis purposes · 4+ years creating and deploying UNIX shell scripts in a production environment · 2+ years with Teradata utilities (e.g. BTEQ, Fastload, Multiload, Fast Export) · 2+ years experience with configuration of ODBC drivers and connections. · 1+ year deploying and maintaining production job schedules with AutoSys · 1+ year web development skills (e.g. CGI, Perl) for departmental website support · Working knowledge of key Wells Fargo databases including C2T, Hogan, BMG, EPSS, Hemisphere, and MDSS. Management/leadership experience required for position: · Experience leading less experienced database analysts in a collaborative team-based environment · Experience presenting results and recommendations to management. · Ability to work in a *fast-paced* changing environment. Ability to balance workload across multiple projects/issues *concurrently*. · Self-motivated and can work independently with limited guidance. · Be accountable for finding solutions to problems when they arise. · Proven experience with System Development Lifecycles (SDLC). · Experience building project plans of deliverables and resources based on dependences and limited resources. *PREFERRED SKILLS* Other skills that would be considered but not required: · Financial Services industry experience · Internet Sales Support & Marketing experience · Prior experience optimizing, refining, and growing a production datamart · Experience with Advanced Unix commands (e.g. sed: text search and replace engine and awk: data manipulation) · Teradata Order Analytical functions (e.g. rank over, partitioning) · Recursive processing (e.g. SQL optimization, looping) · Navigating complex data environments by using foreign/member keys and effective dating concepts · Campaign management data concepts such as contact history and response disposition data. · Advanced ETL (Extract Transform & Load) concepts for SQL optimization and data cleansing (e.g. Date/Time formatting, data coalescing, and text to numeric formatting, data transposition) · Reporting writing in XML/HTML via Unix scripting *Thanks& Regards* *Subash Chandra *Nico Info Systems Inc 12218 N, 56th St || Tampa || FL 33617 || Ph: 813-413-7738 || *Fax: (515) 327-6245 ||* *Email: sub...@nicoinfo.com || www.nicoinfo.com || * -- You received this message because you are subscribed to the Google Groups "Citrix and Sap problems" group. To post to this group, send email to citrix-and-sap-problems@googlegroups.com. To unsubscribe from this group, send email to citrix-and-sap-problems+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/citrix-and-sap-problems?hl=en.