Senior Analyst, Data Operations - SQL Development

Job Title: Senior Analyst Data Operations

Job Level: P2

FCI(First Citizens India) India is a global delivery center for FCI, the financial partner of the innovation economy and parent of First Citizen India. FCI develops products and provides services in finance, banking operations, and technology, and employs more than 800 employees and will be rapidly expanding.

Job location –

Be Part Of a Bank Like No Other.

When you work with the world's most innovative companies, you know you're making a difference.

Our clients are the game changers, leaders and investors who fuel the global innovation economy. They're the businesses behind the next medical breakthroughs. And the visionaries whose new technologies could transform the way people live and work.

For 35 years, FCI Financial Group and its subsidiaries have helped innovative companies and their investors move ambitious ideas forward, fast. FCI Financial Group’s businesses, including Silicon Valley Bank/ First Citizen India, operate at the intersection of innovation and capital, and provide a comprehensive range of financial services including commercial banking, investment solutions, research and insights, funds management and private banking and wealth advisory. FCI helps high growth companies in the technology, life science and healthcare, private equity and venture capital, and premium wine industries navigate at every stage. In addition, the company focuses on encouraging positive relationships with firms within the private equity and venture capital community worldwide, many of which are also the firm's clients and may invest in the firm's corporate clients.

Sr. Data Operations Analyst is responsible to perform SQL developer, Metadata management, Python developer in Data quality or data governance related functions. Should have 3-7 years of overall industry experience which primarily involves and providing analytical and technical skills necessary to innovate, build, and maintain well-managed data solutions and 4-6 years of experience in Banking and financial data domain especially in in data analysis capabilities to solve Data Quality and business problems under the Data Governance Framework.

Key Roles & Responsibilities:

Key data deliverables at Silicon Valley Bank/ First Citizen India: Duties include

Skills and Qualifications:

Data Governance background:

Demonstrating knowledge of data governance, data quality management concepts and data quality tools (i.e. IMB IA, Informatica DQ, Collibra); Understanding of Agile development methodologies, software, data lineage, Data Profiling and data mapping, Experience in Data quality dimension analysis.

Up-skilling:

Python Developer:

• 3-7 years of strong experience in Python, Python developer with a strong foundation in core Python concepts, object-oriented programming, debugging, and version control, along with knowledge of data structures, algorithms, and potentially web frameworks or data science libraries
• Participate in the entire software development lifecycle, building, testing and delivering high-quality solutions.
• Collaborate with cross-functional teams to identify and solve complex problems.

SQL Developer:

• Strong proficiency with SQL and its variation among popular databases, exposure to Netezza would be added advantage.
• Analyze existing SQL queries for performance improvements.
• Create complex functions and stored procedures
• Analyze queries, develop security protocols, and resolve problem.
• Design database architecture and create dashboards
• Write complex queries for applications and business intelligence reporting
• Exposure to Database design, structure and development
• Suggest new queries and increase efficiency of existing queries.
• Capable of troubleshooting common database issues
• Skilled at optimizing large, complicated SQL statements.
• Develop procedures and scripts for data migration.
• Knowledge of best practices when dealing with relational databases
• Capable of configuring popular database engines and orchestrating clusters as necessary

Data Visualization & Dashboard Development:

• Preferred to have exposure to data visualization tools.

Responsibilities:

• Python

  : Understand requirements, write strong, clean and reusable code that can be easily maintained and scaled.

• SQL:

  Help write and optimize in-application SQL statements
• Collaborate with cross-functional teams (e.g., developers, Business owners, project managers, business analysts) to gather requirements and implement solutions.
• Excellent communication skills with exceptional writing and verbal communication skills to interact with stakeholders
• Communicate technical information clearly and effectively.
• Prepare documentations and specifications
• Handle common database procedures such as upgrade, backup, recovery, migration, etc.
• Knowledge of SQL Query writing and database security best practices.
• Profile server resource usage, and optimize and tweak as necessary
• Collaborate with other team members and stakeholders
• Ensure performance, security, and availability of databases
• Analyze performance issues and implement solutions

Required Education and Experience

• 5+ years of experience as a Python and SQL Developer with a strong portfolio of projects.
• In-depth understanding of the Python software development stacks, ecosystems, frameworks.