Applications Development Tech Lead Analyst, VP
Citigroup, Inc.
New Castle, United States of America
3 days ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
Senior Compensation
$ 189KJob location
New Castle, United States of America
Tech stack
Microsoft Access
Microsoft Word
Microsoft Excel
Data analysis
Unix
Program Optimization
Data Transmissions
Data Integration
Data Transformation
Data Visualization
Data Warehousing
Linux
Fraud Prevention and Detection
Hadoop
Hive
Python
Mainframes
Microsoft SQL Server
Oracle Applications
Microsoft PowerPoint
Power BI
SAS (Software)
Software Engineering
Tableau
Teradata
Data Processing
Sql Optimization
Information Technology
Data Management
SQL Server Management Studio (SSMS)
Software Coding
Job description
- 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
Because this is a "rapid response team", the successful candidate must thrive in a fast-paced, high-performance team environment in which creativity and commonsense result in great solutions. This person must be a self-motivated, highly driven, quick, and proactive thinker who has the passion needed to respectfully challenge the status quo., * 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.
Education:
- Bachelors/University degree in business, computer science, or mathematics required. Master's degree, preferred.