Data Architect II

Under the direction of Manager Data Services, the Data Architect II role is to work in conjunction with the Sr. Data Engineer and the Manager of Data Services to design, develop, maintain and improve data warehouse, as required by the evolving needs of the business. The Data Architect II’s primary focus will be on the design, creation and maintenance of new and current extract, transform, and load (ETL)/ extract, load, and transform (ELT) processes, employing industry standards and best practices.

They will also do database development for internally developed applications and software.

• Develop and support in-house database development efforts from internal application development. Participate in performance integration and system testing.
• Maintain ETL routines with Informatica and/or SQL Server Integration Services (SSIS) and SQL Server Agent jobs
• Maintain the San Manuel Enterprise Data Warehouse using Teradata, SQL Server and other database platforms.
• Develop and support various database platforms by creating tables, indexes, views, indexed views, functions, triggers, stored procedures, and tuning complex queries.
• Troubleshoot inefficiencies and gaps in current data warehousing and recommend appropriate solutions to Senior Data Architect.
• Work with Application Analysts and DBAs to perform root cause analysis on all data warehouse production issues and provide second level support for all ETL/ELT applications.
• Participate in Agile functions including Daily Scrums, Backlog Grooming, Sprint Planning and Sprint Retrospective.
• Perform other duties as assigned to support the efficient operation of the department.

• Bachelor’s degree in Information Technology, Business Intelligence Technology, or related field or commensurate experience, required.
• Minimum five (5) years of hands‑on experience using Microsoft SQL Server required.
• Experience with systems analysis, functional design and Microsoft Fabric preferred.
• Related, relevant, and/or direct experience may be considered in lieu of minimum educational requirements indicated above.

• Strong understanding of relational database structures, theories, principles, and practices.
• A demonstrated proficiency in writing procedural language SQL and developing processes that work with generic and proprietary APIs that interact with database management systems.
• A practical understanding of data warehouse design theory including logical and physical modeling.
• Experience with Informatica Power Center, required.
• Experience with Teradata, highly desired.
• Hands‑on experience with SSIS, preferred.
• Tableau or SAS experience is preferred, but SAP Business Objects, Cognos, Micro‑strategy, or equivalent experience is acceptable.
• Demonstrable knowledge of applicable data privacy practices and laws, and experience adhering to those practices and laws.
• Knowledge of the full software development lifecycle and/or agile development methodologies.
• Strong technical verbal and written communication skills with the ability to simplify terminology that a non‑technical end user and/or senior executive can understand.
• Ability to effectively communicate with technical professionals, and a basic understanding of software architecture.
• Knowledge of the Casino/Hospitality industry and related applications, preferred.

• At the discretion of the San Manuel Tribal Gaming Commission, you may be required to obtain and maintain a gaming license.
• A professional certification (MCDBA, MCSA SQL Server, CDMP) issued by a recognized professional organization (Microsoft, ICCP), preferred.
• ITIL (Foundation or higher) certification, preferred.
• No driving responsibilities:
  Role does not require a driver’s license or insurance.

• Primary work environment is in a climate‑controlled office setting.
• Work requires travel to attend meetings, trade shows, and conferences.
• Incumbents may be required to work evening, weekend and holiday shifts.
• Must be able to work in a fast‑paced, high‑demand environment.
• Strength sufficient to exert up…