Top skills required for this role are: advanced SQL querying skills (joins, primary and foreign keys etc.), conversion to JSON, webservices, writing acceptance criteria in Gherkin and/or writing test cases, data migration and data cleansing.
Experience in Jira and Postman are preferred.
Experience in Tableau / Splunk reporting is not required for this role, but it is a nice to have skill.
Must Have Qualifications: Must be proficient with relational databases and have hands on experience using reporting tools including, MS Query, Rapid SQL, and/or MS Access. Must be proficient with MS Office Suite. Must have experience querying using SQL and write queries using JSON . Must have experience with Webservice consolidation and Web Conversions. An ideal candidate would have experience supporting data migrations and maintaining complex data mapping documentation. Azure Secure or Jira is preferred.
Responsibilities:
This role will support the Client's counterparty and access management space.
Known activities include supporting data migration, creating complex SQL queries and executing them for analysis, JSON construction, consumer testing.
Additional activities will likely include identifying proper metadata to enable system access for new applications and roles, troubleshooting production issues, supporting ad hoc and routine questions, requiring data pulls.
The successful candidate will possess strong analytical and follow-up skills.
Qualifications:
5 - 7 years of related data analytics experience.
Bachelor's degree: Business, Statistics, Information Systems, or related field or equal work experience.
Proficient with relational databases and using reporting tools such as Tableau, MS Query, Rapid SQL, and MS Access.
Job requires experience using MS Office applications including MS Excel and MS PowerPoint.
Basic understanding of UNIX, VBA & SharePoint.
Ability to thrive in a face-paced team environment.
Detail oriented with strong problem-solving abilities.
Excellent verbal and written communication skills.
Ability to understand and explain complex business concepts and reporting requirements.
Experience with webservices and JSON construction.