Apps Dev Sr. Programmer Analyst - C12
This position could potentially work remotely from another location.
Under general direction, performs a variety of specialized duties that involve the collection and reporting of data and the maintenance of a comprehensive department management information system.
Supports Citigroup Global Collections Operations across multiple lines of business (Recovery, Workforce Management, Cards, Mortgage, Personal Loans, etc.).
Description The information listed within this description is intended to indicate the general nature and level of work. It is not designed to contain or be interpreted as a comprehensive account of all the responsibilities, and/or qualifications required of an employee assigned to this position.
Responsible for development and enhancement of all aspects of data warehouse solutions. Must be experienced in OLTP and OLAP data warehouse environments using SQL Server 2012 or above and Microsoft BI tools.
Understands business challenges and effectively translates the business information into requirements/solutions.
Responsible for effective collection, manipulation and calculation of data and metadata and implementation of the data warehouse technical infrastructure. Must be able to bridge the gap between technical processes of Operations in all areas; Risk, Operations, BP&A.
Responsible for working with extremely large data sources from multiple platforms such as mainframe, SQL Server, Oracle, Showcase, SYBASE, Teradata, Big Data, Cloud platforms
Responsible for leading, developing and optimizing complex data and Business Intelligence solutions using Transact-SQL, including: Creating tables, views, stored procedures, functions, triggers, error handling, SQL Server Integration Services (SSIS), SSAS, SSRS
Sound knowledge of designing and development analytical data marts, dimensional modeling, OLAP Cubes, SSAS
Knowledge of Data analysis using R language, knowledge of statistical modeling patterns and algorithms
Knowledge of SSRS reporting, data visualization using Microsoft tools, Power BI etc. is desired
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
SQL Server 2016 advanced skillset with query tuning, performance monitoring is required
Qualifications - BA/BS degree or 8+ years equivalent relevant experience in SQL database developer and BI developer role
3-5 years of experience building and maintaining a Data warehouse for a medium to large business.
Strong skillset in the below areas:
SQL Server 2012 or above and T-SQL
Experience with SQL Server Integration Services (SSIS)
SSAS, OLAP and dimensional modeling
Data analysis using large sets of data (structured and unstructured) in RDBMS and Big Data platforms
SSRS, Power BI and data visualization tools
Knowledge of .NET application programming using C#, VB.NET, ASP.NET etc.
Must have highly developed analytical abilities, able to analyze situations, challenge assumptions, develop analytical methodologies, present/defend conclusions and recommend action plans.
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