Senior Data Modeler Job at Apollo ITS, Trenton, NJ

SGE2M1hvZUFIY1FId1p4aldBb1FWK1VNcXc9PQ==
  • Apollo ITS
  • Trenton, NJ

Job Description

Job Title: Senior Data Modeler
Duration: Long Term
Location: Trenton, NJ
Work Arrangement: Hybrid
Note:
  • Local candidates, experience creating data models from AWS Redshift, S3, Dynamo DB, DB2, and Postgres.
  • Candidate will have a strong background in data modeling, database tuning, and the development of structured and unstructured data models for business intelligence and analytics
Job Description:
We are seeking a skilled Senior Data Modeler (SOM) Specialist to design and implement modern data modeling solutions to meet our clients needs. This role involves creating conceptual, logical, and physical data models for various databases, including AWS Redshift, S3, Dynamo DB, DB2, and Postgres. The ideal candidate will have a strong background in data modeling, database tuning, and the development of structured and unstructured data models for business intelligence and analytics.
This will be a full-time contract role and hybrid in Trenton, NJ.
What You'll Do:
  • Design and implement modern data modeling solutions using relational, dimensional, snowflake, star schemas, and data lake models
  • Collaborate with Application Development teams to build data strategies, data flows, and conceptual data models
  • Optimize and update data models to support data initiative projects throughout various implementation phases
  • Perform reverse engineering of physical data models and analyze variances across source systems
  • Develop best practices for standard naming conventions and coding practices to ensure consistency
  • Evaluate system integration challenges and recommend appropriate solutions
  • Work with IT teams to address performance requirements, project limitations, and interfaces
  • Review modifications to existing software to improve efficiency and performance
What You'll Need:
Required:
  • 8+ years of experience in data modeling for databases such as DB2, AWS Redshift, Dynamo DB, Postgres, SQL Server, and PEGA Applications
  • 6+ years of experience with data modeling software
  • Proficiency in AWS and other cloud systems
  • Strong SQL and data profiling skills across various relational databases
  • Experience in building data lakes for structured and unstructured data
  • Database tuning techniques
  • Expertise in relational data, dimensional data, unstructured data, and master data
  • Excellent communication skills and ability to collaborate with internal and external teams
  • Self-motivated and capable of working independently with minimal supervision
Preferred:
  • Exposure to Snowflake's Cloud Data Warehouse
  • Knowledge of modern data management trends and modeling techniques

Job Tags

Full time, Contract work, Local area

Similar Jobs

USAA

Actuary Job at USAA

Why USAA? At USAA, our mission is to empower our members to achieve financial security through highly competitive products, exceptional service and trusted advice. We seek to be the #1 choice for the military community and their families. Embrace a fulfilling career...

Smiles of Virginia Family Dental Center

Paramedic Job at Smiles of Virginia Family Dental Center

 ...Job Opening: Paramedic locum tenens 500$ per day Company: Smiles of Virginia Family Dental Center Job Description Smiles of Virginia Family Dental Center is excited to announce a part-time contract/temporary opportunity/locum tenens for a dedicated Paramedic. Our... 

FocusGroupPanel

Virtual Data Entry Clerk Job at FocusGroupPanel

 ...Seeking Motivated Individuals For Data Entry Type Work From Home Our company is seeking applicants who are motivated to work from home and participate...  ...in paid research studies, product testing, opinion polls, online surveys and other remote research gigs which are taking... 

Remedi SeniorCare

Control Room Fulfillment Pharmacy Technician Job at Remedi SeniorCare

 ...substance Policies & Procedures. Qualifications: High school diploma or equivalent; advanced certifications in pharmacy operations preferred Current registration as a Pharmacy Technician with the VA State Board of Pharmacy required Minimum of 1 year of... 

ProCare Therapy

Travel Special Ed Teacher | Wilmington, Delaware Job at ProCare Therapy

 ...Strong communication, organizational, and team collaboration skills Willingness to undergo a background check including fingerprinting (an $85 fee payable by the candidate) Schedule and Work Hours: Full-time, 37.5 hours per week Monday through Friday...