1 Data Modeler Job in Fairmont, WV
Equiliem is Hiring a Data Modeler Near Fairmont, WV
In This Role, You Will Be Responsible For
- The capture of business requirements and rules.
- Design associated logical models, and create all required documentation to support, communicate, and validate the data model.
- Manage the conversion of the logical models to physical models.
- Design and develop replication mappings.
- Analyze logical and physical data models to support the business requirements in a dynamic, expanding business environment.
- Map data elements of data sources into the domain data models.
- Maintain documentation of data models and data flows, including relationships, constraints and metadata.
- Publish and conduct model reviews with business and technical project teams.
- Develop scripts to build database objects and roles, including stored procedure, views, tables, privileges, etc.
- Coordinate with development/implementation team to improve model formats and approaches with regard to implementation issues.
- Manage the replication and Change Data Capture process for source databases to targets.
- Bachelor’s degree and 8 years of relevant experience. Additional years of relevant experience will be considered in lieu of Bachelor’s degree.
- Strong experience in Oracle SQL and PL/SQL development environment using SQL Developer, TOAD, and other tools.
- Strong analytical skills, able to translate business requirements and translate them into complex database models and execute them to completion.
- Knowledge of ER/Dimensional modeling and have extensive experience in developing logical and physical data models in complex, multi-application environments.
- Hands-on experience in data management, data warehousing, data transformation, metadata and reference data management.
- Experience with a data modeling tool supporting an enterprise environment.
- Able to support production promotions and/or issues after hours or weekends.
- US Citizenship is required and able to obtain security clearance.
- Experience with Oracle Golden Gate replication or a similar tool
- Experience with Idera ER Studio or a similar modeling tool
- Experience with tuning in Oracle
- Knowledge of VPD security
- Understanding of big data solutions, including commercial cloud solutions is a plus.
- Knowledge of deployment architectures, e.g. distributed, cloud, transaction, warehouse.
- Experience with one or more BI tools such as Oracle OBI, Tableau, PowerBI, etc.
Job Summary
Contractor
$95k-120k (estimate)
07/03/2024
07/31/2024
The job skills required for Data Modeler include Data Modeling, SQL, Oracle, Big Data, Data Management, Business Requirements, etc. Having related job skills and expertise will give you an advantage when applying to be a Data Modeler. That makes you unique and can impact how much salary you can get paid. Below are job openings related to skills required by Data Modeler. Select any job title you are interested in and start to search job requirements.
The following is the career advancement route for Data Modeler positions, which can be used as a reference in future career path planning. As a Data Modeler, it can be promoted into senior positions as a Data Modeling Analyst, Sr. that are expected to handle more key tasks, people in this role will get a higher salary paid than an ordinary Data Modeler. You can explore the career advancement for a Data Modeler below and select your interested title to get hiring information.
If you are interested in becoming a Data Modeler, you need to understand the job requirements and the detailed related responsibilities. Of course, a good educational background and an applicable major will also help in job hunting. Below are some tips on how to become a Data Modeler for your reference.
Step 1: Understand the job description and responsibilities of an Accountant.
Quotes from people on Data Modeler job description and responsibilities
Data modeling serves as a means to complement business modeling and to work towards generating a sufficient database.
03/26/2022: Salt Lake City, UT
They also maintain the data models they create, define data modeling and design standards, and evaluate any existing data systems.
03/28/2022: Phoenix, AZ
They develop best practices for standard naming conventions and data coding to ensure consistency of data models.
02/20/2022: Indianapolis, IN
They evaluate existing data systems to design and build databases that can be useful for a variety of purposes.
01/26/2022: Fort Myers, FL
They may have to work with other teams to create data models and data flows.
03/09/2022: Rapid City, SD
Step 2: Knowing the best tips for becoming an Accountant can help you explore the needs of the position and prepare for the job-related knowledge well ahead of time.
Career tips from people on Data Modeler jobs
Top companies and start-ups choose Toptal data modeling freelancers for their mission-critical software projects.
03/21/2022: Houston, TX
As soon as a novice modeler starts their training period, they are assigned to an experienced mentor.
02/10/2022: Terre Haute, IN
When needed, they perform reverse engineering of physical data models from databases and update and optimize local and metadata models.
02/27/2022: Port Arthur, TX
Data modelling can also be used to reverse-engineer the efforts of programmers and extract models from existing systems.
04/08/2022: Madison, WI
Choose one or more potential models and algorithms.
01/29/2022: Erie, PA
Step 3: View the best colleges and universities for Data Modeler.
Similar Jobs
Popular Articles
