Data Modeler Specialist with ER Studio experience
Miejsce pracy: Wrocław
Nr ref.: JO-1706-356269BJDM
Location: Wrocław
Type of contract: Contract of employment
Responsibilities:
- Responsible for the analysis and design of data models at the conceptual, logical and physical levels for business intelligence projects involving reporting Data Warehouse.
- Analyze customer’s requirements, gaps and challenges, design and consolidate data model to meet both the business and technical requirements.
- Work closely with database administration team and ensure the database is architected and designed to support data model solutions.
- Assist in identifying, validating and documenting source system data issues, along with supporting triage of data defects found during test cycles. Develop & unit test data model solutions for optimal performance.
- Provide level-4 production support.
- Collaborate with subject matter experts, business analysts, data analysts and other data modelers to create data models that extend and attribute the current level of detail, along with accompanying documentation in conformance with the applicable data standards.
- Performance tune data model solutions.
Requirements:
- 4 years’ of experience in database implementation
- Experience with Embarcadero ER Studio, Data Modeling, Star Schema
- Experience working with ETL developers responsible for implementing the mappings, responding to and participating in the resolution of issues. This includes assistance in defining required data transformations and business rules.
- Experience in creating source-to-target mapping document across environments.
- Demonstrate good communication and presentation skills and the ability to work with people in various groups and departments.
- Proven track record creating dimensional, normalized and hybrid models for business intelligence projects.
- Create source-to-target mapping document across environments.