Role - Data Modeler Location: Mount Laurel, NJ (Hybrid - 3 Days Onsite /Week) Yrs. of experience: 10+ Yrs. Mode of employment: Full-Time JD for Data Modeler Role
This person will be working on BLDM BAU work.
Need excellent skills in Oracle, dimensional model, as well as entity relational data model.
Be able to come up with efficient, performing, and optimum design.
Experienced in data warehouse, dimensional and entity relational model.
We would love someone who can play a designer/solution lead role.
Definitely need DBA type skills: data modeling using Power Designer, and DDL.
Generating the DDS (Detailed Design Specification) from the BSA inputs to hand off to ETL team.
Data Modeler Responsibilities
Be in charge of developing conceptual, logical, and physical data models and implementing RDBMS, operational data stores (ODS), data marts, and data lakes on target platforms (SQL/NoSQL).
Manage the extension of existing data architecture and optimize data query performance through best practices. The applicant must be capable of working both alone and cooperatively.
Involve business users in determining their information requirements
Examine the business process and conceive the entities that interact inside it
Determine how the various entities are connected and create entity relationship diagrams to depict the links between the entities
Determine the qualities and properties of each entity and verify that the entities can be distinguished inside the model
Create a logical data model and validate it to ensure it meets the demands of the business application and its users
Convert the model's logical representation into a physical manifestation and collaborate with database administrators to instantiate and maintain the data
Work with the BI and Analytics teams to create an efficient, reusable semantic model that includes metadata and lineage information
Fine-tune the model to achieve consistent performance
Keep the metadata - the "data about the data" that describes the data model, its structure, and semantics - up to date
Recommend and implement design and maintenance standards, guidelines, and procedures
Data Modeler Requirements & Skills
A bachelor's degree in Management Information Systems, Computer Science, Computer Information Systems, or a related Information Technology area
Proficient in industry-standard data modelling methodologies
Excellent teamwork and communication abilities
Excellent consultative, facilitative, and consensus-building abilities
Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.