Senior Data Modeler

2 days ago


Trenton, United States CAI Full time

Job ID NumberR4467Employment TypeFull timeWorksite FlexibilityHybridJob SummaryAs the Senior Data Modeler, you will design and implement modern data modeling solutions using relational, dimensional, snowflake, star, data lake that meet the client's needs using conceptual, logical, and physical data models.Job DescriptionWe are looking for a Senior Data Modeler to design and implement modern data modeling solutions using relational, dimensional, snowflake, star, data lake that meet the client's needs using conceptual, logical, and physical data models. The data modeler should be capable of modelling for various data bases like AWS Redshift, S3, Dynamo DB , DB2, and post GRE. This role will be full-time and hybrid in Trenton, NJ.What You'll DoUnderstand and translate business needs into data models supporting long-term solutions for different systemsWork with the Application Development teams (ex: Pega Applications) to implement data strategies, build data flows and develop conceptual data modelsCreate logical and physical data models using best practices to ensure high data quality and reduced redundancyOptimize and update logical and physical data models to support Data Initiative project for different phases of implementationDevelop best practices for standard naming conventions and coding practices to ensure consistency of data modelsRecommend opportunities for reuse of data models in new environmentsPerform reverse engineering of physical data models from databases like DB2 and SQL scriptsEvaluate data models and physical databases for variances and discrepancies across the different source systemsAnalyze data-related system integration challenges and propose appropriate solutions and develop the model according to client standardsWork with all IT teams like System Analysts, Engineers, Programmers, BI and others on project limitations and capabilities, performance requirements and interfacesReview modifications to existing software to improve efficiency and performanceWhat You'll NeedRequired:Candidate should have over all 8+ years of Data Modelling experienceBachelor's DegreeMinimum 4 years of overall experience and 3 years into Bigdata TechnologiesStrong work experience in Data modeling and usage of data modeling toolsExposure with Snowflake’s Cloud Data Warehouse, if possibleWell versed in understanding relational data, dimensional data, unstructured data, and master dataShould have recent data management trend skills such as developing data lake model along with traditional modelling practices like snowflake and starKnowledge of recent modeling techniques that are adapted for data warehousing and analytical structures.Able to build logical data model and translate logical model into physical databaseAble to demonstrate expertise with the most recent and relevant technologies in the data modelling implementationExcellent communication skills and possess the ability to collaborate with internal and external groups including vendors8+ 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 mustStrong SQL and data profiling skills in various relational databasesAnalyzing source databases, source data, source database referential integrity and profiling source data (8 years)Database tuning techniques (minimum 4 years)Experience in building Data Lakes for both structured and unstructured data (2 years)Physical DemandsAbility to safely and successfully perform the essential job functions consistent with the ADA and other federal, state and local standardsSedentary work that involves sitting or remaining stationary most of the time with occasional need to move around the office to attend meetings, etc.Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitorReasonable Accommodation StatementIf you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to application.accommodations@cai.io or (888) 824 – 8111.Equal Employment Opportunity Policy StatementIt is the policy of CAI not to discriminate against any employee or applicant due to race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or being a protected veteran. It is also the policy of CAI to take affirmative action to employ and to advance in employment, all persons regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or being a protected veteran, and to base all employment decisions only on valid job requirements. This policy shall apply to all employment actions, including but not limited to recruitment, hiring, upgrading, promotion, transfer, demotion, layoff, recall, termination, rates of pay or other forms of compensation and selection for training, including apprenticeship, at all levels of employment. Employees and applicants of CAI will not be subject to harassment due to race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or being a protected veteran. Additionally, retaliation, including intimidation, threats, or coercion, because an employee or applicant has objected to discrimination, engaged or may engage in filing a complaint, assisted in a review, investigation, or hearing or have otherwise sought to obtain their legal rights under any Federal, State, or local EEO law is prohibited.



  • Trenton, United States Crescens Full time

    Job title : Senior Data Modeler Specialist Location: Trenton , NJ (Hybrid) Duration : 6+ monthsJob Responsibilities: This SDM position is for designing and implementing modern data modeling solutions using relational, dimensional, snowflake, star, data lake that meet Judiciary needs using conceptual, logical, and physical data models. The SDM should be...


  • Trenton, United States Hudson Data Full time

    Job Title: PEGA Senior System Architect Location: Trenton, NJ (Hybrid) Duration: Long Term Description: The Certified PEGA Senior Systems Architect evaluates existing systems and/or user needs to analyze, design, recommend, and implement information system changes. Local Candidates Only - Please submit those who currently live within a commutable...


  • Trenton, New Jersey, United States Core Software Technologies Inc. Full time

    Unlock Business Potential with Data ExcellenceWe are seeking a highly skilled Data Transformation and Modeling Specialist to join our team at Core Software Technologies Inc. In this pivotal role, you will be responsible for leveraging your expertise in data transformation and modeling to drive business growth and innovation.

  • Senior Data Architect

    3 weeks ago


    Trenton, New Jersey, United States Core Software Technologies Inc. Full time

    About the RoleWe are seeking a highly skilled Senior Snowflake Developer to join our team at Core Software Technologies Inc.Job DescriptionThis is a pivotal role in architecting data warehouses, data lakes, and ETL processes to enable efficient data storage, processing, and analytics for our organization. Key responsibilities include designing and...


  • Trenton, New Jersey, United States CVS Health Full time

    CVS Health is committed to delivering enhanced human-centric health care for a rapidly changing world. We are seeking a highly skilled and experienced Senior Data Scientist with Machine Learning Expertise to join our dynamic team. In this role, you will work closely with data scientists, software developers, and product managers to take ML-powered services...


  • Trenton, New Jersey, United States Tandym Group Full time

    Tandym Group, a leading broadcasting corporation, is seeking a highly skilled Senior Data Engineering Project Lead to join their data engineering team in NJ. This role offers an excellent opportunity for experienced professionals to grow their career in a dynamic and technically challenging environment.Job Summary:The Senior Data Engineering Project Lead...

  • Senior Data Architect

    1 month ago


    Trenton, New Jersey, United States Core Software Technologies Inc. Full time

    About the RoleWe are seeking a highly skilled Senior Snowflake Developer to join our team at Core Software Technologies Inc. This role plays a pivotal part in architecting data warehouses, data lakes, and ETL processes to enable efficient data storage, processing, and analytics for the organization.

  • Senior Data Architect

    2 weeks ago


    Trenton, New Jersey, United States Netflix Full time

    Unlock the Power of Data at NetflixAs a Senior Data Architect at Netflix, you will play a critical role in shaping the future of our data-driven workflow tooling. Our team is responsible for enabling partners to develop data-driven solutions that power statistical/machine learning-based data features in high-visibility internal Studio Creative Production...

  • Senior Data Analyst

    1 week ago


    Trenton, New Jersey, United States TerraCycle Full time

    Job SummaryTerraCycle is seeking an experienced Senior Power BI Analyst to join our team. As a key member of our data analytics team, you will be responsible for developing, maintaining, and optimizing Power BI dashboards and reports. This role requires strong analytical and problem-solving skills, as well as excellent communication and collaboration...


  • Trenton, New Jersey, United States Tek Tree LLC Full time

    We are seeking a skilled Senior Tableau Developer to join Tek Tree LLC in Trenton, NJ. This is a hybrid position requiring 3 days on-site and 2 days remote work.As a Senior Tableau Developer at Tek Tree LLC, you will be responsible for visualizing complex data in a clear and compelling way, delivering impactful data-driven insights to stakeholders. The ideal...


  • Trenton, New Jersey, United States Eliassen Group Full time

    We are seeking an experienced Data Products Engineer to join our team at Eliassen Group. As a Data Products Engineer, you will play a key role in designing and implementing robust data pipelines, APIs, and scalable software solutions with best-practice data architectures.The ideal candidate will have 10+ years of professional experience in data engineering...

  • Data Steward

    3 weeks ago


    Trenton, United States firstPRO, Inc Full time

    FirstPRO is in search of a Master Data Steward for our client located in Trenton, NJ. The Data Steward will be responsible for for the creation, maintenance, and assisting with continuous improvement of master and product data to support our client's businesses, under the guidance of more senior data stewards or managers. This is a hybrid, 6 month contract...


  • Trenton, New Jersey, United States CAI Full time

    Job DescriptionSalary: $120,000 - $180,000 per year (estimated)As a Senior Tableau Developer at CAI, you will be responsible for designing and developing robust data visualizations and reports using Tableau Desktop and Online. You will collaborate with stakeholders to understand business requirements, gather data, and deliver actionable insights.Key...


  • Trenton, United States JobRialto Full time

    Job Summary We are Seeking a Senior Tableau Developer with extensive experience in Tableau, Salesforce integration, and cloud data warehousing (e.g., Snowflake). This role involves gathering requirements, building reports, delivering dashboards, and providing training to help stakeholders make data-driven decisions. Key Responsibilities • Collaborate with...


  • Trenton, United States Tek Tree LLC Full time

    Job title: Senior Tableau DeveloperLocation: Trenton, NJ (Hybrid).Duration: ContractNote: This is a Hybrid position - 3 Days On-Site, 2 Days Remote.Candidates must be willing to complete an assignment and share the Public Tableau dashboard of the assignment, if selected for an interview.We are seeking a Senior Tableau Developer to visualize complex data in a...


  • Trenton, United States Tek Tree LLC Full time

    Job title: Senior Tableau DeveloperLocation: Trenton, NJ (Hybrid).Duration: ContractNote: This is a Hybrid position - 3 Days On-Site, 2 Days Remote.Candidates must be willing to complete an assignment and share the Public Tableau dashboard of the assignment, if selected for an interview.We are seeking a Senior Tableau Developer to visualize complex data in a...


  • Trenton, New Jersey, United States Core Software Technologies Inc. Full time

    Job OverviewWe are seeking a skilled Data Transformation Expert to join our team at Core Software Technologies Inc. This is an exciting opportunity for someone who wants to work with cutting-edge technologies and make a significant impact on our data-driven business.About the RoleThe ideal candidate will have 3+ years of experience using dbt for data...


  • Trenton, New Jersey, United States JobRialto Full time

    Job SummaryWe are seeking an experienced Senior Tableau Developer to join our team at JobRialto. This role involves gathering requirements, building reports, delivering dashboards, and providing training to help stakeholders make data-driven decisions.Key ResponsibilitiesCollaborate with stakeholders to gather and understand business requirements.Design,...


  • Trenton, New Jersey, United States Core Software Technologies Inc. Full time

    Job DescriptionWe are seeking an experienced Data Transformation Specialist to join our team at Core Software Technologies Inc. in a SQL Engineer role focused on data modeling.About the Role:Design and implement efficient data transformations and models using data to create structured, cleaned, and aggregated datasets.Develop and maintain accurate data...


  • Trenton, United States Core Software Technologies Inc. Remote Work Freelance Full time $65 - $70

    A Senior Snowflake Developer is a highly skilled professional responsible for designing, implementing, and optimizing data solutions using the Snowflake cloud data platform. This role plays a pivotal part in architecting data warehouses, data lakes, and ETL processes to enable efficient data storage, processing, and analytics for the...