Skip to content
IT Data Lead Analyst
| Company | Citigroup |
|---|
| Location | Tampa, FL, USA |
|---|
| Salary | $113840 – $170760 |
|---|
| Type | Full-Time |
|---|
| Degrees | Bachelor’s |
|---|
| Experience Level | Senior, Expert or higher |
|---|
Requirements
- 8-10 years of relevant work experience as technical data analyst and/or Data warehousing/ETL lead.
- A bachelor’s degree in business, Finance, Data Science or Analytics, Statistics, Engineering, or other similar degrees.
- Advanced expertise in Business intelligence, data analytical and reporting tools (SQL, Python, Tableau, Power BI etc).
- Strong understanding of relational databases
- Experience performing extensive data mapping exercises
- Experience performing in-depth data analysis and data profiling activities
- Experience mentoring/leading other data analysts
- Strong interpersonal skills and techniques to solve dynamic problems; excellent teamwork skills
- Must have excellent written and verbal communication skills, along with strong consulting skills
- Experience identifying and implementing process improvement
- Solid skills effectively managing multiple small to large projects simultaneously in a cross-functional environment.
Responsibilities
- Analyze complex financial data, identify trends, patterns, anomalies to provide actionable insights to business units such as finance, risk and operations.
- Write and optimize complex SQL queries for data extraction, reporting, analysis.
- Develop stored procedure, triggers and functions in Oracle to automate data-related processes.
- Design and implement reporting solutions, utilizing SQL, scripting language and other data analytical tools to deliver meaningful and accurate data visualizations.
- Leverage programming languages to automate manual tasks, develop data reconciliation and data quality checks.
- Develop data analytical reports/dashboards based on business requirement.
- Address and resolve complex data-related issues, ensuring data integrity and accuracy.
- Collaborate with team members, technology partners, and business partners to identify efficient and strategic solutions.
- Communicate technical solutions and findings to both technical and non-technical stakeholders, ensuring clear understanding of application functions and financial data.
- Provide inputs during development and implementation phases, including formulation and definition of systems scope, objectives and necessary system enhancements for complex, high-impact projects.
- Own the resolution of issues – manage multiple program sub-streams and aid in developing technology solutions based off analysis.
- Review existing processes critically to identify inefficiencies and automation solutions.
- Author artifacts such as architectural proposals and technical solutions, guide to navigate thru complex data issue, and communication materials for senior management and key business partners.
- Act as SME to senior stakeholders and/or other team members.
Preferred Qualifications
- Additional required experience would be in Data, technical in understanding data and complex project. Will need to have understanding in Database, data analysis, data profiling.
