| Data Modeler - Remote at Remote, Remote, USA |
| Email: [email protected] |
| From: Bhanu Prakash, Intellectt [email protected] Reply to: [email protected] Hi, Hope you are doing well, This is Bhanu from Intellectt INC; we have an immediate opportunity with one of our clients. Please find the below job description and if you are interested, please forward your resume to [email protected] Role: Data Modeler Duration: 6+ Months Location: Remote Overview: The Data Modeler for Data Warehouse Projects is responsible for designing and implementing data models for data warehouse solutions. This role involves understanding business requirements, analyzing data sources, creating data models, and ensuring the integrity, security, and performance of the data warehouse. Key Responsibilities: Requirements Gathering: Collaborate with business analysts and stakeholders to gather and understand data requirements. Translate business needs into data models supporting long-term solutions. Data Analysis: Analyze complex data sources and systems to understand the data and extract relevant information. Evaluate the suitability of the data for inclusion in the data warehouse. Data Modeling: Design conceptual, logical, and physical data models for the data warehouse. Develop entity-relationship diagrams, dimensional models (star schemas, snowflake schemas), and other data models as needed. Data Integration: Work closely with ETL (Extract, Transform, Load) developers to ensure smooth integration of data models into the ETL processes. Collaborate with data engineers to optimize data pipelines for efficient data loading and processing. Data Quality and Integrity: Implement data quality standards and ensure data integrity within the data warehouse. Identify and resolve data quality issues by working with relevant stakeholders. Performance Tuning: Optimize data models and queries for improved performance and responsiveness. Monitor and analyze query performance and make necessary adjustments to enhance data warehouse efficiency. Documentation: Maintain comprehensive documentation of data models, data dictionaries, and metadata. Ensure that documentation is up-to-date and accessible to the relevant teams. Collaboration: Collaborate with cross-functional teams, including database administrators, business analysts, and developers, to ensure seamless operation and integration of data warehouse solutions. Data Security: Implement and maintain data security measures, including access controls, encryption, and data masking, to protect sensitive information within the data warehouse. Qualifications: Bachelor's or Master's degree in Computer Science, Information Technology, or related field. Proven experience as a data modeler, preferably in the context of data warehouse projects. Proficiency in data modeling tools such as SQLDBM, ERwin, ER/Studio, or similar tools. Strong understanding of data warehousing concepts, ETL processes, and data integration techniques. Experience with database technologies (e.g.,Snowflake, Oracle.) Excellent analytical and problem-solving skills. Strong communication skills to collaborate effectively with diverse teams and stakeholders. Ability to work independently and manage multiple tasks and priorities effectively. Keywords: |
| [email protected] View all |
| Fri Nov 03 20:57:00 UTC 2023 |