System Analyst, Data Analyst - Second Innings
ITG Group- Second Innings is an initiative aimed at encouraging women on a professional break to resume their corporate career. This program will act like a launch pad to women who have had career breaks due to varying personal circumstances. Intertrust Group will provide structured onboarding, focused mentoring, flexible work options and on the job learning to the candidates. Through women mentors & buddies the candidates can address their concerns and close specific skills gaps.
On career break since Jan 2020 or later
Should match the skill and experience criteria mentioned in the respective Job descriptions.
Shouldn’t have participated in any interview process with ITG in a period of 6 months before the date of application.
If ex- employee of Intertrust Group, cause of exit should not be termination.
Senior System Analyst / Module Leader, Data Analyst
Location: Bangalore / Mumbai / Chennai
Vacancy Type: Permanent
Job Shift: 12PM IST – 9PM IST
Job Description for Data Analyst
Writing T-SQL Code - Stored Procedures, Triggers, SQL Functions, Views, CTE, Service Brokers, Queues etc. Debugging existing applications written in SQL, do bug fix, enhancement. Perform SQL DBA basic activities e.g. DB backup, restore, Replication, sql jobs. Part of job may require working on SSIS packages, creating reports in Power BI/SSRS/Tableau. Work with product designers/owners on design, planning & execution of projects. Collaborate with app architects/leads for data modelling. - Additional Work with business teams to understand the requirement and implement it.
Hands on T-SQL and working experience on RDBMS - Stored Procedures, Triggers, SQL Functions, Views, CTE, Service Brokers, Queues etc.
Perform basic activities of DBA. (Backup, restore DB, create SQL Jobs).
Must possess debugging skills, problem solving ability and can visualize the data flow from one layer to another.
Have worked on SQL applications.
Ability to query/visualize transactional and historical data to be able identify patterns.
Query performance turning is a plus and reports development will be required.
Experience with ETL tools like SSIS and analytics/visualization tools like Power BI/Tableau is a plus.
Knowledge of capital markets or any financial services domain is a big plus.
Knowledge of data modelling through entity relationship/ORM tools and data normalization are a plus.
Bachelor’s Degree in Computer Science/Engineering or Master’s in Computer Applications (MCA)
3+ years as T-SQL developer
0-3 years of DBA.
Ability to collaborate effectively and work as part of team.
Ability to work with minimum guidance.
Excellent written, oral, and interpersonal skills.
Ability to multi-task and thrive in an ambiguous environment.
Strong attention to detail.
2+ years of data analyst role is a plus.
About Intertrust Group
Intertrust Group is a global leader in providing tech-enabled corporate and fund solutions to clients operating and investing in the international business environment. We have over 4,000 employees across 30 jurisdictions in Europe, the Americas, Asia Pacific and the Middle East. Together as a team, we deliver high-quality, tailored fund, corporate, capital market and private wealth services to our clients, with a view to building long-term relationships.
What we offer you
Working at Intertrust means entering a dynamic, international and growth-oriented company. We provide you with outstanding opportunities for your professional and personal development through our local and global Intertrust Academies. Our International Mobility program enables talented employees to gain working experience abroad. We offer a competitive salary and benefits, commensurate with your qualifications and experience.Apply for this role