tekHouse
Senior Data Modeler Hybrid New Jersey 10 year Experience
tekHouse, Bayonne, New Jersey, us, 07002
12 month plus Contract 1099 or Corp to Corp
2-3 Days onsite New Jersey
Responsible for the development of the conceptual, logical, and physical data models on Cloud Data Warehouse, data marts, and data lakes on target platforms like Redshift.
Oversee and govern the expansion of existing data architecture and the optimization of data query performance via best practices. The candidate must be able to work independently and collaboratively.
Implement data requirements through new data strategies and designs across all data platforms (relational, dimensional, and NoSQL)and data tools (reporting, visualization, analytics, and machine learning).
Work with business and application/solution teams to implement data strategies, build data flows, and develop conceptual/logical/physical data models Define and govern data modelling and design standards, tools, best practices, and related development for enterprise data models.
Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization.
Requirements
Skills & Experience:
10 years of hands on design and implementation of Data Warehouse, Dimensional model and business semantic modelsShould have hands on experience in designing and build data models from scratch on Cloud Data Warehouse like Redshift, Aurora , Dynamo DBExperience in using data modelling tools like Erwin or ER Studio or others is required.Experience on modelling in Big data environment on -premise implementation, Hive Database is preferableHave a experience in SQL and good understanding of source systems like Oracle , SQL Server , Teradata etc is mustShould have knowledge of Knowledge of any ETL tool, Informatica is preferableStrong communication skillsExposure to Insurance domain is preferable
2-3 Days onsite New Jersey
Responsible for the development of the conceptual, logical, and physical data models on Cloud Data Warehouse, data marts, and data lakes on target platforms like Redshift.
Oversee and govern the expansion of existing data architecture and the optimization of data query performance via best practices. The candidate must be able to work independently and collaboratively.
Implement data requirements through new data strategies and designs across all data platforms (relational, dimensional, and NoSQL)and data tools (reporting, visualization, analytics, and machine learning).
Work with business and application/solution teams to implement data strategies, build data flows, and develop conceptual/logical/physical data models Define and govern data modelling and design standards, tools, best practices, and related development for enterprise data models.
Identify the architecture, infrastructure, and interfaces to data sources, tools supporting automated data loads, security concerns, analytic models, and data visualization.
Requirements
Skills & Experience:
10 years of hands on design and implementation of Data Warehouse, Dimensional model and business semantic modelsShould have hands on experience in designing and build data models from scratch on Cloud Data Warehouse like Redshift, Aurora , Dynamo DBExperience in using data modelling tools like Erwin or ER Studio or others is required.Experience on modelling in Big data environment on -premise implementation, Hive Database is preferableHave a experience in SQL and good understanding of source systems like Oracle , SQL Server , Teradata etc is mustShould have knowledge of Knowledge of any ETL tool, Informatica is preferableStrong communication skillsExposure to Insurance domain is preferable