Key skills
HadoopLinuxOraclePythonSQLTableauUnixData WarehousingBIPower BISQL ServerLeadershipStakeholder Management
About this role
Role Overview
- Engage as technology and data SME during interactions with key internal Citi partners and external vendors to develop solutions.
- Develop code to extract data from various technology platforms to support Retail Bank portfolios.
- Develop reporting dashboards to highlight impact of fraud trends on business performance and to identify opportunities for improvement.
- Utilize in-depth Retail Bank business knowledge to provide proactive support to our partners (unsolicited reporting and tools).
- Support key partners through data warehousing of business analytic views, data transmissions, data integrations, and process automation.
- Provide support for proofs of concept with new vendor tools that combat fraud applications and account takeover.
- Develop standards that ensure quality of execution and accuracy of business reporting.
- Manage ad-hoc requests for data analysis on data sources where documentation is minimal to non-existent.
- Utilize leadership skills.
- Utilize stakeholder and people management experience.
- Manage multiple ad-hoc requests and small projects.
Requirements
- 10+ years of hands-on experience developing in SAS, required.
- Knowledge of advanced SQL and/or SAS coding techniques, required.
- 10+ years working with extremely large data sources from multiple platforms such as SQL Server, Oracle, Teradata, and Hadoop required.
- 5+ years of hands-on experience with Hive/Hue, Python, or other Big Data tools, preferred.
- 5+ years of hands-on knowledge of distributed platforms like Linux or Unix, preferred.
- Knowledge of Hadoop and mainframe platforms, preferred.
- 5+ years of hands-on experience with SQL Server Management Studio (SSMS), preferred.
- Hands-on data visualization experience in Tableau or Power BI, preferred.
- Experience in reporting and ad hoc data support, preferred.
- Intermediate to advanced knowledge of Microsoft Office Products (Word, Excel, PowerPoint, Access) required.
- Hands-on experience in data manipulation, data transformation, and code optimization, required.
- Ability to work collaboratively as well as independently to achieve superior results, required.
- Hands-on business analysis experience in requirements gathering, stakeholder management, and process mapping, preferred.
- Have a strong analytical mindset to tackle incomplete, ambiguous, or erroneous data and ability to close data gaps.
- Ability to understand story behind data and summarize results adjusted by audience, required.
- Ability to independently challenge status-quo, identify opportunities, investigate issues, and propose recommendations, required.
- Ability to work under tight deadlines and quickly adapt to changing priorities, required.
- Ability to work successfully in a cross-functional organization, required.
- Ability to effectively present technical concepts to a non-technical audience, required.
- Hands-on experience creating process documentation, required.
Tech Stack
- Hadoop
- Linux
- Oracle
- Python
- SQL
- Tableau
- Unix
Benefits
- medical, dental & vision coverage
- 401(k)
- life, accident, and disability insurance
- wellness programs
- paid time off packages, including planned time off (vacation), unplanned time off (sick leave), and paid holidays