Job Description
JOB SUMMARY:
Job Title: Data Modeler
Location: Allen, TX
Duration : 6+ months contract
We are seeking a Data Modeler – EDW build and maintain a company's database by identifying structural and installation solutions. They will work with database administrators and analysts to secure easy access to company Data.
JOB DUTIES
- Strong communication skills as would be required to work directly with Business Units and Senior Management
- Translate business needs to technical specifications
- Collaborate with teams to integrate systems
- Prepare design for all Oracle/Teradata according to various ETL processes.
- Perform troubleshoot on all ETL processes and resolve issues effectively.
- Prepare appropriate status reports and submit it to management.
- Analyze all data warehouse architecture goals and identify skill requirement for same.
- Develop both physical and logical data models.
- Prepare designs for database systems and recommend improvements for performance.
- Maintain and develop various database scripts and tools to facilitate automation process.
- Provide support to all data warehouse initiatives.
- Analyze all data warehouse activities and identify key resources for same.
- Design various ETL processes and perform tests on data.
- Define data standards and rules for Governance for the data warehouse
- Monitor processes and develop plans to capture and access.
- Develop and implement various work plans for projects.
- Evaluate all proposals requests and assist to improve structure of data warehouse.
- Assist with Informatica Administration Duties