Sunrise Systems, Inc. · 2 months ago
Senior Data Modeler
Trenton, NJ
Full-time
Hybrid
Senior Level, Lead/Staff
$77/hr - $85/hr
8+ years expSunrise Systems, Inc. is looking for a Senior Data Modeler to design and implement modern data modeling solutions that meet client needs. The role involves creating logical and physical data models, optimizing data strategies, and collaborating with various teams to ensure high data quality and reduced redundancy.
Information Technology & Services
Responsibilities
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 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 new environments
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 in Client
Analyze data-related system integration challenges and propose appropriate solutions and develop the model according to Client 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
Candidate should have over all 8+ years of Data Modelling experience
Minimum 4 years of overall experience and 3 years into Bigdata Technologies
Strong work experience in Data modeling and usage of data modeling tools
He/she should be well versed in understanding relational data, dimensional data, unstructured data, and master data
Should have recent data management trend skills such as developing data lake model along with traditional modelling practices like snowflake and star
They should know modeling techniques latest that are adapted for data warehousing and analytical structures
Able to build logical data model and translate logical model into physical database
They must be able to compare actual project procedures to the specified standards and procedures
They should be able to demonstrate expertise with the most recent and relevant technologies in the data modelling implementation
They must have excellent communication skills and possess the ability to collaborate with internal and external groups including vendors
They must have the ability of working independently and with minimal supervision
8+ years of experience in Data Modeling for Databases like DB2, AWS' Redshift, Dynamo DB, Postgres, SQL Server, Pega Application
Data modeling software (6 years)
AWS and Other Cloud systems experience is must
Strong SQL and data profiling skills in various relational databases
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)
4 years College Degree or equivalent technical study
Preferred
Database tuning techniques (minimum 4 years)
Benefits
Sunrise offers ACA compliant medical coverage/dental insurance/vision insurance to all employees.
We also offer Sick time benefits as required per State regulations.
Company
Sunrise Systems, Inc.
Sunrise Systems was founded in 1990 with a clear vision to deliver world-class staffing service solutions in all labor categories, including IT consulting and solutions; all with the commitment to provide service that exceeds expectations and become the most trusted name in the industry.
501-1000 employees
H1B Sponsorship
Sunrise Systems, 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
2024 (2)
2020 (2)
Funding
Current Stage
Late StageLeadership Team
Ruchi Hajra
Senior Account Manager/Client Servicing/Talent Acquisition Partner
Company data provided by crunchbase