Reference Code: 13051302
Location: Jacksonville, FL, USA
Education Level: Bachelor's Degree
of the Organization Citi, the leading global financial services company, has some 200 million customer accounts and does business in more than 100 countries, providing consumers, corporations, governments and institutions with a broad range of financial products and services, including consumer banking and credit, corporate and investment banking, securities brokerage, and wealth management. Additional information may be found at www.citigroup.com or www.citi.com.
WFM MIS - Intermediate Analyst - Application Development Programmer-13051302
• Develop, optimize and maintain moderate-to-complex data and reporting solutions (creating tables, views, stored procedures, triggers, error handling, etc.) • Work directly with internal business customers, project managers & IT to understand reporting requirements and execute the solution by leveraging the tools adopted within the organization • Responsible for working with extremely large data sources from multiple platforms such as mainframe, SQL Server, Oracle, Showcase, SYBASE, Teradata • Develop ASP.NET web based reporting utilizing C# • Use data to assist in establishing dashboards, reports, work lists, web site pages, e-mail/text alerts and other necessary and related materials; organizes material for efficient reporting and retrieval • Develops, organizes and maintains training materials for users; provides technical support and guidance for users; researches user inquiries • Responsible for the effective documentation of data and reporting solutions based on audit/control requirements within the organization • Support On-Call Rotation for off-hours trouble tickets/issues
• BA/BS degree or 2+ years equivalent relevant experience in a reporting, development, or analytical capacity • Any combination of intermediate to advanced skills in the at least 3 of the below areas: • SQL Server Reporting Services (SSRS) to author, manage, and deliver dynamic, interactive, drill-down web-based reports • SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS) • T-SQL and SQL Server 2005/2008 • ASP.NET (C#) • Advanced MS Excel and MS Access including extensive experience with VB macros • Comparable development experience with other data warehouse environments (Ex: Oracle) will be considered • Successfully engage in multiple initiatives simultaneously and work independently with users to define concepts or under direction of project managers • Excellent verbal and written communication skills and the ability to interact professionally with a diverse group of executives, managers, and subject matter experts • Must have intellectual curiosity and a willingness to delve into a problem and understand the root cause
Citi is today's pre-eminent financial services company and was built to create a highly diversified financial services company that could...