Data Architect II

San Manuel • Highland, CA

7h • Onsite

About The Position

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.

Requirements

• 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.
• 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.
• 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.

Nice To Haves

• Experience with systems analysis, functional design and Microsoft Fabric preferred.
• 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.
• Knowledge of the Casino/Hospitality industry and related applications, preferred.
• A professional certification (MCDBA, MCSA SQL Server, CDMP) issued by a recognized professional organization (Microsoft, ICCP), preferred.
• ITIL (Foundation or higher) certification, preferred.

Responsibilities

• 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.
• Performs other duties as assigned to support the efficient operation of the department.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level