Vacancy expired!
Title : Data Modeler/Integration DesignerLocation : Remote with occasional travel to the client site, paid by the clientDuration : 6 Months - To permanent Work Requirements: US Citizen, GC Holders or Authorized to Work in the USQualifications: The role is going to be a 50-50 split between a Data modeler & an Integration designer
- Must have strong ELT and ETL experience.
- Experience with Near real time systems/processes.
- Strong experience designing integration solutions.
- Computer or Information Science or equivalent field
- DAMA Data certifications a plus
- 10+ years of experience in data modeling, database design, and data architecture.
- Experience in the Travel and Hospitality industry a plus.
- Proficient in Data Lineage / Modeling tools (ER Studio). Informatica toolsets including Data Archive, EDC, Oracle database.
- Expert understanding of Data Warehouse design for high volume processing and performance.
- Knowledge of Business Intelligence tools utilization including Hyperion, SAS, Tableau, and/or Microsoft PowerBI.
- Bachelors or Master s degree specialized in areas related to Information and Data management and Design.
- 12 years of deep data modeling and architecture experience
- Data modeling, Data lineage, Data standards
- In addition to other duties/functions, this position requires full commitment and support for promoting ethical and compliant culture.
- More specifically, this position requires integrity, honesty, and respectful treatment of others, as well as a willingness to speak up when they see misconduct or have concerns. Responsibilities:
- Design, develop, and enforce data models and naming standards across all deliverables.
- Reverse and forward engineer Business legacy data models.
- Effectively communicate the technical data integration requirements, design, and decisions that support the functional needs of Data Engineering to both IT and Business members via verbal or documentation.
- Reduce data redundancy consolidation, transformation, and training of Business and IT members.
- Design and develop data lineage with / without pre-existing documentation.
- Create and maintain current and target state data integration models and flows.
- Reverse and Forward engineer Business data models to the level needed for business Analytics usage.
- Develop an understanding of Business processes and the corresponding system architecture in order to determine Source system(s) of required data, data relationships, and impacted integrations.
- Partner with the Business Intelligence teams in defining the end state reporting goals and/or dashboard requirements.
- Design and develop Data models and solutions required to meet them.
- Ensure Design documentation includes appropriate Business rules and facilitates data Security,
- Quality, Lineage, and Harmonization.
- Support testing and deployment activities as required.
Vacancy expired!