Senior Data Modeler

3 hours ago

Elmwood Park, New Jersey, United States GSK Solutions Full time

Job Title: Senior Data Modeler (Hybrid)

Location: Elmwood Park, NJ

Duration: 12 months

Interview Process: iLinc Web Cam Interview Only

Summary:

Seeking a Senior Data Modeler to design and implement advanced data modeling solutions (relational, dimensional, snowflake, star, data lake) for Judiciary systems using conceptual, logical, and physical data models. The role involves working with various databases (AWS Redshift, S3, DynamoDB, DB2, Postgres) and collaborating with business and IT teams.

Responsibilities:

  • Translate business needs into data models supporting long-term systems.
  • Work closely with Application Development teams to implement data strategies, build data flows, and develop conceptual models.
  • Create and optimize logical and physical data models using best practices.
  • Support Data Initiative projects through multiple implementation phases.
  • Develop and enforce standard naming conventions and coding practices for consistency.
  • Identify opportunities for data model reuse in new environments.
  • Reverse engineer physical models from existing databases and SQL scripts.
  • Evaluate data models and physical databases for variances across source systems.
  • Analyze integration challenges and propose/implement solutions per Judiciary Standards.
  • Collaborate with IT teams (System Analysts, Engineers, Programmers, BI, etc.) on project requirements, limitations, and interfaces.
  • Review software modifications for efficiency and performance improvements.

Qualifications:

  • 8+ years overall data modeling experience (including DB2, AWS Redshift, DynamoDB, Postgres, SQL Server, Pega Application).
  • 4 years of college degree or equivalent technical study.
  • Minimum 4 years overall experience and 3 years in Big Data technologies.
  • 6+ years experience with data modeling software.
  • 3+ years AWS and other cloud systems experience.
  • Recent experience with Snowflake's Cloud Data Warehouse is preferred.
  • Proficient in relational, dimensional, unstructured, and master data modeling.
  • Advanced knowledge of developing data lake models and traditional techniques (e.g., snowflake/star).
  • Expertise using modern modeling techniques for data warehousing and analytics.
  • Skilled in building logical and translating logical models into physical database structures.
  • Ability to compare actual project procedures with specified standards and procedures.
  • Excellent communication and collaboration skills with internal/external teams and vendors.
  • Ability to work independently with minimal supervision.

Skills:

  • Data modeling for multiple databases (DB2, AWS Redshift, DynamoDB, Postgres, SQL Server, Pega Application).
  • Data modeling software proficiency.
  • Cloud systems expertise (AWS, others).
  • Strong SQL and data profiling experience in relational databases.
  • Source database/data profiling and referential integrity analysis.
  • Database tuning techniques (preferred).
  • Experience building data lakes for structured and unstructured data.

Company Overview:

GSK Solutions Inc. is a leading IT services company delivering consulting solutions and staff augmentation. Known for quality, reliability, and timely execution, GSK serves Fortune 500 clients nationwide in areas including information security, software development, consulting, and IT audits.

Recruiter Contact: Arun at gsksolutions dot com

Contact: Eight three two – Nine nine zero – Two nine three three

Job Type: Contract

Pay: $ $90.00 per hour

Expected hours: 40 per week

Work Location: In person

  • Product Manager, Data and AI Products

    2 days ago

    Elmwood Park, New Jersey, United States ELLKAY Full time $120,000 - $180,000 per year

    ELLKAY started out providing connectivity solutions to laboratories and within a few years, grew to also provide data management solutions to ambulatory organizations. ELLKAY is now a trusted data management partner in five healthcare segments. ELLKAY's solutions continue to serve laboratories and ambulatory practices and have expanded to empower hospitals...

  • Senior Operator

    2 days ago

    Elmwood Park, New Jersey, United States Dr. Praeger's Sensible Foods, Inc Full time $42,000 per year

    Senior OperatorCompany History:Dr. Praeger's was founded in 1994 with the mission to bring delicious frozen food to everyone. It's not every day that two heart surgeons get into the food business, but over 20 years ago that's exactly what our dads did. Motivated by what they saw in their practice, our parents set out on a mission to encourage sensible...

  • Senior Utility Engineer

    7 days ago

    Elmwood Park, New Jersey, United States Yu & Associates Full time $105,000 - $120,000 per year

    YU & Associates, Inc., an awarding winning engineering firm located in Elmwood Park, New Jersey is seeking a Senior Utility Engineer to join our team. As a Senior Utility Engineer, you will be responsible for supporting the planning, design, and preparation of contract documents for the construction of stormwater and utility...

  • Senior Data Integration Engineer

    6 days ago

    Florham Park, New Jersey, United States Reworld Waste Full time

    Who we areFor more than 40 years, Reworld has been a leader in sustainable waste solutions, providing our customers with innovative solutions that help them achieve carbon-negative outcomes.Our VisionReworld is leading the charge to a carbon-negative future through revolutionary sustainable materials management solutions that reduce, reuse, recycle and...

  • Senior Tableau Developer

    6 days ago

    Florham Park, New Jersey, United States Info Services Full time $120,000 - $180,000 per year

    Job Title: Senior Tableau DeveloperLocation:Florham Park, NJ - Hybrid (3 Days/Week)About the RoleWe are seeking an exceptionally skilledSenior Tableau Developerwith14+ years of experiencein data visualization, business intelligence, and analytics solutions. The ideal candidate will be responsible for designing, developing, and optimizing complex Tableau...

  • Sr. Director Business Applications

    13 hours ago

    Elmwood Park, New Jersey, United States ELLKAY, LLC Full time

    ELLKAY started out providing connectivity solutions to laboratories and within a few years, grew to also provide data management solutions to ambulatory organizations. ELLKAY is now a trusted data management partner in five healthcare segments. ELLKAY's solutions continue to serve laboratories and ambulatory practices and have expanded to empower hospitals...

  • Controller

    3 days ago

    Elmwood Park, New Jersey, United States SPENCER SAVINGS BANK Full time $134,529 - $212,600 per year

    SUMMARY OF RESPONSIBILITIESResponsible for the Bank's financial records, reporting and processes are accurate, consistent with regulatory and generally accepted accounting principles (GAAP) and standards, adheres to tax laws and properly reflects the financial position of the Bank at time of reporting, and distributed in a manner to support the Board of...

  • Senior Data Management Analyst

    2 days ago

    Floral Park, New York, United States City of New York Full time $100,000 - $120,000 per year

    Job Description Hours: Full Time- 35 HoursWork Location: 30-30 Thomson Ave, LIC, Queens 11101Only candidates who are permanent in the Associate Staff Analyst title or those who are reachable on the current Promotional list (Exam #9537), or Open-Competitive list (Exam #9061) may apply. Please include a copy of your Notice of Result card or indicate if you are...

  • Senior Tax Analyst

    3 days ago

    Florham Park, New Jersey, United States GTM (Global Tax Management) Full time $82,000 - $96,000 per year

    Global Tax Management (GTM) is a leading corporate tax services firm with 30+ years of helping dynamic organizations solve complex tax challenges. We deliver scalable, practical solutions with precision and integrity- powered by people and rooted in a culture that supports both client success and team growth. Our core services include tax provision, income...

  • Senior Human Resource Specialist

    6 days ago

    Florham Park, New Jersey, United States Insperity Full time $71,280 - $81,098

    Insperity provides the most comprehensive suite of scalable HR solutions available in the marketplace with an optimal blend of premium HR service and technology. With more than 90 locations throughout the U.S., Insperity is currently making a difference for thousands of businesses and communities nationwide.Behind our success is the unshakeable belief in the...