Citi Technology Infrastructure (CTI) provides global operations support to Citi businesses in the key areas of Data Center Mainframe Distributed Systems Cloud Solutions Network Client Computing Site Support and Telecommunication systems.
CTI Business Operations Reporting and Metrics team is responsible for the collection and dissemination of operational metrics and key performance indicators (KPI’s) to all of Citi Technical Infrastructure management teams for use in the Monthly Operational Reporting (MOR) submissions. The team is currently expanding their Central Reporting Utility to provide robust self-service capabilities that will allow users to extract data from standardized data sets that can be used for more detailed analytics and is in need for a SQL developer with an understanding of Business Intelligence concepts including interacting with or creation of Data Warehouses and Data Marts to help build and implement new features.
SQL Developer candidate will be responsible for the creation and enhancement of web applications to support the reporting needs of the CTI Business Management Operations Performance Metrics and Analytics team and their customers.
The objective of the role is to aid in the expansion of the Central Reporting Utility with particular emphasis on providing intuitive insight into key metrics for ITIL processes (Incident Change Problem and Service Request Management) Supplier Management and CTI Capital Investment Reporting for the Citi Technical Infrastructure (CTI) organization. Additionally the role will expand upon the self-service capabilities of the Central Reporting Utility with focus on internal web applications that consolidate our current report catalog and database utilities.
This role will be responsible for the complete software development life cycle (SDLC) of converting business requirements into production web-based applications following Citi branding guidelines.
All of the team’s projects follow the Agile methodology and utilizes Team Foundation Server to manage their deliverables.
Key Responsibilities:
- Design maintain and build web based applications in the Central Reporting Utility
- Maintain current knowledge with web technologies and best practices
- Work with the SQL Development team with the maintenance of the Central Reporting Utility
- Ability to be involved on several projects concurrently and providing different roles to each
- Work directly with the business customers to develop solutions based on their requirements
- Coach other team members on proper coding techniques
- Provide project status to senior management on a timely basis
- Escalate issues as they are encountered
- Ability to follow Citi’s Change Management procedures
- Other duties as assigned
Skills required:
- Ability to work in a regulated environment
- Strong ability to prioritize and work under faced paced timelines
- Excellent analytical logical and problem-solving skills
- Excellent spoken and written communication skills
- Ability to work autonomously or within project teams of varying sizes with varying roles
- Ability to work on multiple assignments concurrently
- Passionate about technology and its use to create lasting value to the organization
Other Qualifications:
- Strong desire to learn new technologies and adapt into the current framework
- Microsoft Team Foundation Server source control
- Team Foundation Server Agile Methodology is a plus
- Experience with one or more BI Reporting Tools (Power BI Cognos QlikView etc.) is a plus
- ITIL Certification is a plus
Technologies and tools:
- 2+ years SQL Server Development
- Database Modeling
- Stored procedures
- User Defined Functions
- SQL Queries
- Ability to convert VBA code into automated reports using visualization tools.
- Understanding of ServiceNow data model is plus
- Microsoft BI Stack (SSIS SSRS SSAS) is a plus
- Knowledge of Data Warehousing concepts is a plus
- Knowledge and experience in web development (e.g. HTML5, Bootstrap, CSS3, Javascript / jQuer, C#, MVC and WebForms frameworks, ADO.NET/Entity Framework, SQL Scripting) is a big plus
Education
- Bachelor's degree/University degree or equivalent work experience
In return we offer:
- Attractive salary package based on employment agreement.
- Opportunity to work within a team of experienced professionals to support and develop your skills.
- Vast range of challenges and scenarios opening up an amazing opportunity and exposure for any candidate to progress and develop.
- A company keen to ensure that you continuously are learning and developing and enhancing your skills.
- Excellent opportunity to develop your skills within a global enterprise.
- Excellent opportunity to work with a wide range of technology experts and disciplines across the world.
- Excellent opportunity to work with many different people, from many different backgrounds and cultures throughout EMEA.
- Career progression, the ability to drive and fast track your career is in your hands
- Entrepreneurial culture, you will have the ability to make a difference globally