Citi Finance, Market and Credit Risk Technology develops innovative technology solutions and is focused on providing exceptional service to our clients in full partnership with our product teams. A career in this innovative technology team offers the chance to experience being part of a global organization that features the best talent in the industry and creates a positive impact for each other, our clients, and our communities where we live and work. Wholesale Credit Risk team within ICG-IT supports a diverse range of business partners such as Credit Risk, Retail Risk, Market Risk, Internal Controls, Internal Audit and Operational Risk by solving business challenges through data analytics using various Business Intelligence tools such as Tableau, Cognos and MicroStrategy.
Requirements
- Solid Hands-on experience with Tableau Desktop, Tableau Server and Tableau Prep.
- Thorough knowledge of Tableau administration and architecture.
- Knowledge and hands-on experience with TabPy and Tableau Data Management, Lineage, Tableau API tools.
- Analytics using Big Data, Python or R.
- Strong, proven programming skills in R, Python, Java, MATLAB, C++ or Scala.
- Ideally have some real-world experience with API platforms.
- Experience in writing complex SQL, Stored Procedures and SQL Query tuning.
Responsibilities
- Develop, maintain, and manage advanced reporting, analytics dashboards and other BI solutions. Design and develop solutions using Tableau dashboards (Web & Mobile) using Oracle/ Sybase / Big Data as backend technologies.
- Integrate data from various sources into Tableau, ensuring optimally performing data models. Conduct data cleansing, blending, and aggregation to prepare datasets for visualization.
- Monitor and enhance the performance of Tableau dashboards and data sources, ensuring rapid load times and intuitive user experiences.
- Optimize data extracts and ensure efficient data retrieval and performance on Tableau dashboards. Maintain, test and schedule refresh of Tableau extracts. Devise process for trigger-based automation of Tableau extract refresh for large volumes (TB) of data. Create scripts for automating Tableau extract refresh.
- Assist with prioritization of bugs, feature work, and architectural enhancements. Design Tableau APIs as required. Provide technical expertise in areas of architecture, design, and implementation.
- Troubleshoot and remediate issues related to data integrity, visualization accuracy, and dashboard performance.
- Fine tune SQL Queries for maximum efficiency and performance. Conduct unit tests and develop database queries to analyze the defects and troubleshoot any issues.
Other
- 5-8+ years of experience in enterprise BI development, preferably from a consulting background.
- Strong background in designing and implementing enterprise scale solutions.
- Clear understanding of query plan management.
- Experience with Starburst is highly preferred.
- Hands-on experience in relational database management application development.
