Data Specialist (Closed)

SkillStorm is seeking a Data Specialist for our client in Jersey City, New Jersey. Candidates must be able to work on SkillStorm's W2; not a C2C position. EOE, including disability/vets.

Job Description:

• The Software Engineer will work as a data specialist and will work with the development team to design, optimize, and oversee the conceptual and logical data models for critical operational data related to Global Markets products and services. Your duties will also include working with business domain experts in finalizing domain models and attributes, monitoring compliance with changes made in systems of record, and overseeing data conversions and migrations. The data specialist will also work on designing reporting schemas and building reports and dashboards for end users. The data specialist will also work with application support teams to ensure data issues raised by consumers are fully investigated to determine root case and are resolved in production.
• To succeed in this role, you should know how to examine new data system requirements and implement migration models. The ideal candidate will also have proven experience in data analysis and management, with excellent analytical and problem-solving abilities.

Key Responsibilities:

• Design and implement effective database solutions and models to store and retrieve sensitive client profile and related operational data related to trades, positions and settlements.
• Examine and identify database design requirements necessities by working with business domain experts
• Assess database implementation procedures to ensure they comply with internal and external regulations.
• Prepare accurate database design and architecture reports for management and executive teams.
• Oversee the migration of data from legacy systems to new solutions.
• Develop reporting solutions using standard BI tools
• Monitor the system performance by performing regular tests, troubleshooting, and integrating new features.
• Recommend solutions to improve new and existing database systems.
• Educate staff members through training and individual support.
• Offer support by responding to system problems in a timely manner.

Qualifications:

• Minimum 10 years of experience with the following:
• A minimum of 5 years’ experience in a similar role.
• Strong knowledge of database structure systems and data mining.
• Strong SQL skills with experience working on relational databases (MS SQL Server or equivalent)
• Experience using DB tools like Toad Data Point, Toad Data Modeler etc.
• Knowledge of BI tools like Microsoft SSRS, Power BI and Cognos
• Experience using ETL tools like Microsoft SSIS, Informatica
• Knowledge of Global Banking and Markets operational data management requirements
• Experience working in Agile teams and good understanding of software development lifecycle
• Excellent organizational and analytical abilities.
• Outstanding problem solver.
• Good written and verbal communication skills.
• Knowledge, or 1-2 years of experience with the following will be a plus:
• Development tools – Visual Studio, Eclipse
• Data Visualization Tools – Tableau or similar tools
• Programming experience – Python, Java or similar languages
• Workflow concepts – BPM, Pega, or equivalent

?#LI-DNI