2 Er Modeling Jobs

We are seeking an experienced ER Modeling Expert / Data Modeler to design, develop, and maintain conceptual, logical, and physical data models for enterprise applications and data warehouses. The ideal candidate should have a deep understanding of relational databases, normalization, data governance, and schema design while ensuring data integrity and scalability. Key Responsibilities: Design and develop Entity-Relationship (ER) models for databases, data warehouses, and data lakes. Create conceptual, logical, and physical data models using tools like Erwin, Visio, Lucidchart, or PowerDesigner. Define primary keys, foreign keys, relationships, cardinality, and constraints for optimal data integrity. Work closely with DBAs, data architects, and software developers to implement data models. Optimize database performance, indexing, and query tuning for relational databases. Define and enforce data governance, data quality, and master data management (MDM) standards. Develop and maintain metadata repositories, data dictionaries, and schema documentation. Ensure compliance with data security and privacy regulations (GDPR, HIPAA, etc.). Support ETL/ELT pipeline design to ensure smooth data flow between systems. Work with big data platforms (Snowflake, Databricks, Redshift, BigQuery, or Synapse) to support modern data architectures. Required Skills & Qualifications: 6+ years of experience in data modeling, database design, and ER modeling. Strong expertise in relational databases (SQL Server, Oracle, PostgreSQL, MySQL, etc.). Hands-on experience with data modeling tools (Erwin, PowerDesigner, DB Designer, Visio, or Lucidchart). Proficiency in SQL, indexing strategies, query performance tuning, and stored procedures. Deep understanding of normalization, denormalization, star schema, and snowflake schema. Experience with data governance, data quality, and metadata management. Strong knowledge of ETL processes, data pipelines, and data warehousing concepts. Familiarity with NoSQL databases (MongoDB, Cassandra, DynamoDB) and their modeling approaches. Ability to collaborate with cross-functional teams including data engineers, architects, and business analysts. Strong documentation and communication skills. Preferred Qualifications: Certifications in Data Management, Data Architecture, or Cloud Databases. Experience with cloud-based databases (AWS RDS, Azure SQL, Google Cloud Spanner, Snowflake). Knowledge of Graph Databases (Neo4j, Amazon Neptune) and hierarchical modeling.

Analyze, design develop, troubleshoot and debug software programs for commercial or end user applications. Writes code, completes programming and performs testing and debugging of applications. As a member of the software engineering division, you will perform high-level design based on provided external specifications. Specify, design and implement minor changes to existing software architecture. Build highly complex enhancements and resolve complex bugs. Build and execute unit tests and unit plans. Review integration and regression test plans created by QA. Communicate with QA and porting engineering as necessary to discuss minor changes to product functionality and to ensure quality and consistency across specific products. Duties and tasks are varied and complex needing independent judgment. Fully competent in own area of expertise. May have project lead role and or supervise lower level personnel. BS or MS degree or equivalent experience relevant to functional area. 4 years of software engineering or related experience. Career Level - IC3 We are the team building the next generation of the Oracle CX Sales applications that span across mobile devices on iOS/android, email clients such as Outlook, collaboration tools such as ms teams and slack, the web interface for a comprehensive and an immersive UI and a variety of other platforms with a long term vision to provide a consistent, easily customizable and a seamless engagement experience. These solutions are being built ground up and are designed to natively integrate with Oracle AI offeringss. The enterprise productivity landscape is changing at a rapid pace and Cloud Applications across these interfaces andplatformsare becoming both a strategic and an imperative offering for many customers Oracle CX Applications enables enterprise Sales/CQ teams to seamlessly move from on-line/connected applications to a mobile, occasionally connected mode with access to data and processes that maximize the effectiveness of their roles within the enterprise. These always available, composite applications are process-oriented interactions that improve the efficiency and effectiveness of the users. As an Engineer on the team, you get to: Innovate in niche areas such as being able to customize an application real time Conversationally allow users to interact with the Oracle CX system via both voice and text -- this is the next Generation AI sustem Work on a solution for the mobile application to be available while offline as wel Develop integrations such the ability to scan a business card Add to the motivation and have a lot of fun In addition the person in this role would: Work on the latest technologies .Make a big impact - we are a small but a growing team Work with some really smart engineers Interact with senior architects from the Oracle ecosystem Requirements: Bachelors or Masters degree in Computer Science. Strong programming skills - javascript, typescript, redux andnode. Excellent knowledge of design patterns, OO andER modeling Knowledge of JSON based REST APIs, OpenAPI standards, Android , Objective-C, Swift,python and java Strong understanding of computer science fundamentals including algorithms, designing ML models, data structures, databases and system concepts Complete product development life-cycle experience with good software engineering skills Ability to understand business concepts and processes is a plus Successful track record showing excellence and creativity Participate in Technical Discussions and contribute effectively to architectural and design decisions