Senior Associate Consultant
Job details
Country
Poland
State / Region / Province
Krakow
Work Location
Kraków/Krakow
Domain
Delivery
Interest Group
Infosys Limited
Skills
Technology|Database administration|mySQL administration
Company
ITL Poland
Requisition ID
122435BR
Job description
Job Title: SQL Data Analyst
Location: Kraków, Poland
Type of work: Remote
Job Description:
Data Analyst/ SQL Developer, Alpha Data Services
Why this role is important to us
Alpha Data Services (ADS) teams are responsible for definition of data sourcing, data quality and data distribution rules on the Alpha Platform. This includes sourcing, mapping and maintenance of Security Master, Indices/Benchmarks, Analytics, Account Master, Prices, Issuer/Ultimate Issuer, Ratings, Classifications, Market data and other data. In addition, ADS service provides for ingestion of Client-directed data, custom validations and client specified classifications and hierarchies.
Datasets in the Alpha Platform must be accurate, complete and timely to inform our clients’ investment, financial, and regulatory decisions.
The Data Analyst/ SQL Developer will interact with clients and internal State Street parties to identify the best data validation solutions for the client. The role involves supporting multiple client relationships and client deliverables globally and staying on top of changes to the underlying data warehouse tables and marts.
What you will be responsible for
• Gather data validation requirements and acceptance criteria from business Subject Matter Experts via Jira or RTC tool
• Partner with Product Development teams to understand data model(s) and develop SQL based validation logic that will be performed on inbound and outbound data flows
• Develop, document and unit test logic for the data validations
• Partner with business testers to confirm validations are producing expected values
• Work independently and collaboratively with technology teams to identify issues, perform root-cause analysis for erroring validations
• Contribute to data validation and system enhancement testing efforts
• Escalate data and technical related issues to proper teams and track until complete resolution
• Ensure all activities are compliant with corporate standards
• Communicate clearly and effectively with internal and external parties
• Adhere to internal procedures and best practices at all times
Required Experience
• Degree in computer science, finance, accounting, business, or technology and relevant industry experience
• Excellent analytical and problem-solving skills
• Strong Technical skills in data management including SQL
• Database Management and ETL development experience
• Experience with cloud platforms (AWS/ Azure)
• Strong communication skills
• Self-motivated and adaptable and show initiative and a strong sense of task ownership
• Flexibility and willingness to learn and work on new areas of expertise
• Asset management experience, including investment operation "
These cookies are necessary for the website to function and cannot be switched off in our systems. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will not then work. These cookies do not store any personally identifiable information.
These cookies enable the website to provide enhanced functionality and personalisation. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly.
These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site. All information these cookies collect is aggregated and therefore anonymous. If you do not allow these cookies we will not know when you have visited our site, and will not be able to monitor its performance.
These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information, but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.