Architect IT Enterprise Data

Boyd Gaming, Inc. Las Vegas, NV
* Must be at least 21 years of age.

* Bachelor's Degree preferred in a related discipline, or equivalent in academic institution; significant applied experience or a combination of education and experience may be substituted.

* 4+ years of professional data architecture development experience.

* At least 8 years of hands-on database development using any SQL/query language/toolset in engineering solutions.

* In-depth hands-on understanding of data design methodologies, data architecture principles, Data modeling and interrelation of various enterprise data or Business Intelligence-related solutions.

* 3+ years using SQL tools: Server Management Studio and Business Intelligence Development Studio, or equivalent toolsets.

* 3+ years experience using SSIS, or equivalent extraction/transformation tools

* 4+ years experience developing and optimizing SQL procedures and DB structures.

* Must have an understanding of principles of Extract Load and Transform (ETL) processes.

* Must have Working knowledge of database physical and logical design.

* Development skills with SQL Server databases/ TSQL in a high transaction volume environment.

* Knowledge of SQL Server internals.

* ITIL V3 Awareness Training preferred.

* Proven ability to lead an mentor 1-2 junior engineers in design, development and deployment.

Must be able to obtain/maintain any necessary licenses and/or certifications.

The Enterprise Data Architect is a senior-level data structure developer, lead data infrastructure designer and is fully competent in a defined data delivery discipline or product. This position resolves semi-routine issues involving design, development and database redesign, and is typically assigned to design, retrofit or debug most aspects of a data-related product or major sub component. This person will be responsible for contributing development efforts to multiple systems that are under the core responsibility of the architecture team.

Some duties will include, but are not limited to:

* Lead the establishment and documentation of technology direction and standards for data platforms, involving all aspects of information access and retrieval, integration, middleware translators, utilities, tools, and languages for use by information technology groups. Communicate the benefits and advocate the use of enterprise wide data architecture and standard platforms, products and tools to senior management, business area staff and technical staff.

* Analyze the current state innovation, product development and manufacturing operating model, including organizational constructs, business processes, systems, information and data

* Analyze, design and implement new/improved operational capabilities in our master data architecture.

* Defines and achieves the strategy roadmap for the enterprise; including data modeling, implementation and data management for our enterprise data warehouse and advanced data analytic systems.

* Evangelize Data Governance and value of accurate master data and metadata.

* Develops and implements strategies for data warehouse following industry best practice (Kimball), creating conceptual, logical and physical models.

* Expert in data warehousing principles utilizing fact and dimension tables, star and snowflake schema data modeling and data normalization preferred.

* Provide support to enterprise data infrastructure management and analysts throughout the project cycle to ensure development of efficient data systems utilizing established standards, procedures and methodologies (i.e. design reviews, architect reviews).

* Drive the execution of data architecture using industry best practices. Specifically - Provide technical and architectural guidance to teams across all platforms and infrastructures, including promoting adherence to design standards and methodologies.

* Applies extensive knowledge of business drivers, technology strategy, architecture goals and infrastructure to develop and deliver clear, comprehensive data, technical and product architectures. Reviews and ensures major data designs are consistent, maintainable, flexible and cost effective.

* Investigates and forecasts market trends to define the technical information strategy direction and recommends innovations that anticipate the future direction of the business, its drivers and technology strategy.

* Recommend emerging technological solutions to increase market share and reduce operational costs.

* Conduct systems architecture studies of new and existing data infrastructure; develop tactical plans to address short-term deficiencies in current data architecture.

* Review project plans and technical documents to ensure consistency, accuracy and compliance with enterprise data architecture.

* Define implementation plan for new technologies.

* Mentor team members on new technology and database best practices.

Other duties as assigned.