Innova Solutions USA - Jersey City, NJ

posted 4 days ago

Full-time - Mid Level
Jersey City, NJ
10,001+ employees
Professional, Scientific, and Technical Services

About the position

The Application Programmer V_SQL with Graph Database role at Innova Solutions involves significant experience in Microsoft SQL programming and development, particularly with Graph databases. The position requires collaboration with cross-functional teams to align database solutions with business requirements while ensuring data integrity and performance in a modernized database environment. The role is hybrid, allowing for both onsite and remote work, and focuses on building ad-hoc reports and performing deep data analysis.

Responsibilities

  • Develop and program using Microsoft SQL, including SSMS, SSRS, SSAS, and CUBE (Star Schema).
  • Build ad-hoc reports using CUBE, Snowflake, Tableau, and generic SQL.
  • Construct Graph databases using tools like Neo4J and Tiger graph.
  • Conduct deep data analysis to identify gaps, patterns, and behaviors to support enhancements and user requests.
  • Debug complex SQL code to identify data gaps and logical enhancements.
  • Work with large datasets, approximately 100 million records.
  • Collaborate with cross-functional teams to understand business requirements and align database solutions accordingly.
  • Ensure data integrity, security, and performance in the modernized database environment.
  • Provide technical guidance and support to development teams during the implementation of database changes.
  • Stay current with industry trends and emerging technologies in traditional databases and big data.

Requirements

  • Significant experience in Microsoft SQL programming and development.
  • Hands-on experience in building Graph databases using tools like Neo4J and Tiger graph.
  • Proficiency in debugging complex SQL code.
  • Experience in working with large datasets (~100 million records).
  • Ability to conduct deep data analysis and identify data gaps.

Nice-to-haves

  • Preferred experience in financial data such as trade data and reference data.

Benefits

  • Medical & pharmacy coverage
  • Dental/vision insurance
  • 401(k)
  • Health saving account (HSA)
  • Flexible spending account (FSA)
  • Life Insurance
  • Pet Insurance
  • Short term and Long term Disability
  • Accident & Critical illness coverage
  • Pre-paid legal & ID theft protection
  • Sick time
  • Employee Assistance Program (EAP)
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service