Synergyassure Inc · 1 week ago
App Tech Specialist - Senior Data Modeler
Trenton, NJ
Contract
Hybrid
Senior Level, Lead/Staff
8+ years expSynergyassure Inc is seeking a Senior Data Modeler to design and implement modern data modeling solutions. The role involves creating data models that meet client needs and collaborating with business and application teams to ensure effective data strategies and structures.
Staffing & Recruiting
Hiring Manager
Naveen Vallabhani
Responsibilities
Responsible for the design, development, and implementation of Data Warehouse database structures and Analytical Database structures
Work with Business groups and Application Teams during pre- & post-assessment periods
Write complex SQL’s, write and execute Stored Procedures for the analysis of data
Understand the needs of the Business team and BI team for building a proper Data Warehouse and DataMart
Develop structured and unstructured data models for BI and Analytics
Understand and translate business needs into data models supporting long-term solutions for different client systems
Work with the Application Development teams (ex, Pega Applications) to implement data strategies, build data flows, and develop conceptual data models
Create logical and physical data models using best practices to ensure high data quality and reduced redundancy
Optimize and update logical and physical data models to support the Data Initiative project for different phases of implementation
Develop best practices for standard naming conventions and coding practices to ensure consistency of data models
Recommend opportunities for reuse of data models in a new environment
Perform reverse engineering of physical data models from databases like DB2 and SQL scripts
Evaluate data models and physical databases for variances and discrepancies across the different source systems
Analyze data-related system integration challenges and propose appropriate solutions, and develop the model according to the client's Standards
Work with all IT teams, like System Analysts, Engineers, Programmers, BI, and others, on project limitations and capabilities, performance requirements, and interfaces
Review modifications to existing software to improve efficiency and performance
Qualification
Required
4 years College Degree or equivalent technical study
Experience in Data Modeling for Databases like DB2, AWS' Redshift, Dynamo DB, Postgres, SQL Server (8 Years)
Data modeling software (6 Years)
AWS and Other Cloud Systems (3 Years)
Strong SQL and data profiling skills in various relational databases (8 Years)
Analyzing source databases, source data, source database referential integrity, and profiling source data (8 Years)
Experience in building Data Lakes for both structured and unstructured data (2 Years)
Preferred
Database tuning techniques (4 Years)
Exposure to Snowflake's Cloud Data Warehouse
Company
Synergyassure Inc
Synergyassure is dedicated to provide comprehensive technology solutions and guidance to businesses across various industries.
51-200 employees
H1B Sponsorship
Synergyassure Inc has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (17)
2024 (27)
Funding
Current Stage
Growth StageCompany data provided by crunchbase