Sr. Data Architect

Caesars Enterprise Services Las Vegas , NV 89119

Posted 2 months ago

ESSENTIAL JOB FUNCTIONS
The Senior Data Architect is a key member of the Data Architecture & Management team responsible for managing the flow of data between the various source systems, the data integration platform, and business intelligence applications, across the enterprise. This position will develop data models including dimensional models for analytics and reporting, address data migration issues, formulate plans for data governance and data lineage, enhance metadata, and serve as the technical data steward for enterprise data. The Senior Data Architect will be responsible for ensuring data quality and optimal data movement from a holistic perspective across all subject areas, projects, and system implementations as a representative of the Data Engineering team.

Responsibilities include, but may not be limited to the following:

Create data models and supplemental documentation for the existing Data Warehouse platform and ongoing for all new implementations
Contribute to the development of an Enterprise Logical Data Model from which the EDW logical and physical data models would be developed
Provide suggestions for improving performance, data integrity, and system quality
Work closely with the Business Intelligence team to create enhanced data models for dimensional design as required by tools such as Tableau, and Power BI.
Devise standards to be implemented within the Data Warehouse environment for database consistency while reducing redundancy and increasing integrity
Participate on project teams to ensure the end to end vision of data movement is optimized and results in the highest quality of data for operational and analytical use
Serve as the data expert across all subject areas stored in the data integration platform
Provide oversight to ensure that the needs of the Data Engineering team is represented in all cross-functional projects
Work closely with the ETL architects and programmers to ensure database objects are adhering to standards
Perform design reviews for all modifications and additions to the existing data warehouse
Provide expertise in the area of Data Governance and Data Lineage
Document data flow between systems and ensure accuracy
Conform data as necessary to integrate data from multiple systems
Mentor others in proper data modeling and best practices
Lead or direct the work of others
Rarely requires guidance, even on most complex systems analysis

KNOWLEDGE AND EXPERIENCE

Required
7+ years work experience in physical and logical relational database modeling is required.
7+ years work experience in architecting data solutions is required.
6+ years work experience in dimensional modeling is required.
6+ years work experience with data warehousing is required.
6+ years work experience with a data modeling tool such as ERWIN is required.
3+ years work experience with project leadership is required.
Experience with Azure cloud platform
Experience with Master Data Management
Extensive knowledge of database uses and design is required.
Expert level ability to understand and write Structured Query Language (SQL) is required.
Understanding of OLAP, ROLAP, and MOLAP concepts is required.
Exposure to agile data architectures, logical data lakes, and logical data warehouses is required
Ability to design by leveraging business, technical and economic drivers is required
Experience in leveraging data to enable business transformations is required

Preferred
Exposure to data virtualization tools like Denodo preferred
Experience with MDM tools like Profisee and data governance tools like Collibra preferred
Experience with Business Intelligence tools such as Tableau and Power BI is preferred.
Experience with Teradata and Teradata Utilities is preferred.
Knowledge of both UNIX and Windows operating systems is preferred.

Soft Skills
An inquisitive mindset
Ability to abstract general principles from specific requirements
Strong communication and relationship management skills

EDUCATION
Bachelors degree in Information Systems, Computer Science or technical training equivalent

Skills:
Azure Cloud, Master Data Management, SQL, OLAP, Data Modeling, Data Warehousing
Permanent


See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Sr Data Architect

Caesars Entertainment Corporation

Posted 3 months ago

VIEW JOBS 8/25/2018 12:00:00 AM 2018-11-23T00:00 ESSENTIAL JOB FUNCTIONS The Senior Data Architectis a key member of the Data Architecture & Management team responsible for managingthe flow of data between the various source systems, the data integrationplatform, and business intelligence applications, across the enterprise. This position will develop data modelsincluding dimensional models for analytics and reporting, address datamigration issues, formulate plans for data governance and data lineage, enhancemetadata, and serve as the technical data steward for enterprise data. The Senior Data Architect will be responsiblefor ensuring data quality and optimal data movement from a holistic perspectiveacross all subject areas, projects, and system implementations as arepresentative of the Data Engineering team. Responsibilities include, but may notbe limited to the following: * Createdata models and supplemental documentation for the existing Data Warehouseplatform and ongoing for all new implementations * Contributeto the development of an Enterprise Logical Data Model from which the EDWlogical and physical data models would be developed * Providesuggestions for improving performance, data integrity, and system quality * Workclosely with the Business Intelligence team to create enhanced data models fordimensional design as required by tools such as Tableau, and Power BI. * Devisestandards to be implemented within the Data Warehouse environment for databaseconsistency while reducing redundancy and increasing integrity * Participateon project teams to ensure the end to end vision of data movement is optimizedand results in the highest quality of data for operational and analytical use * Serveas the data expert across all subject areas stored in the data integrationplatform * Provideoversight to ensure that the needs of the Data Engineering team is representedin all cross-functional projects * Workclosely with the ETL architects and programmers to ensure database objects areadhering to standards * Performdesign reviews for all modifications and additions to the existing datawarehouse * Provideexpertise in the area of Data Governance and Data Lineage * Documentdata flow between systems and ensure accuracy * Conformdata as necessary to integrate data from multiple systems * Mentorothers in proper data modeling and best practices * Lead ordirect the work of others * Rarelyrequires guidance, even on most complex systems analysis KNOWLEDGE ANDEXPERIENCE Required * 7 years work experience in physical and logicalrelational database modeling is required. * 7 years work experience in architecting datasolutions is required. * 6 years work experience in dimensional modelingis required. * 6 years work experience with data warehousingis required. * 6 years work experience with a data modelingtool such as ERWIN is required. * 3 years work experience with project leadershipis required. * Experience with Azure cloud platform * Experience with Master Data Management * Extensive knowledge of database uses and designis required. * Expert level ability to understand and writeStructured Query Language (SQL) is required. * Understanding of OLAP, ROLAP, and MOLAP conceptsis required. * Exposure to agile data architectures, logicaldata lakes and logical data warehouses is required * Ability to design by leveraging business,technical and economic drivers is required * Experience in leveraging data to enable businesstransformations is required Preferred * Exposure to data virtualization tools likeDenodo preferred * Experience with MDM tools like Profisee and datagovernance tools like Collibra preferred * Experience with Business Intelligence tools suchas Tableau, and Power BI is preferred. * Experience with Teradata and Teradata Utilitiesis preferred. * Knowledge of both UNIX and Windows operatingsystems is preferred. SoftSkills * An inquisitive mindset * Ability to abstract general principles fromspecific requirements * Strong communication and relationship managementskills EDUCATION Bachelor's degree in InformationSystems, Computer Science or technical training equivalent Caesars Entertainment Corporation Las Vegas NV

Sr. Data Architect

Caesars Enterprise Services