Job Title: Data Architect Job ID: 2023-11948 Job Location: Remote Job Travel Location(s): # Positions: 1 Employment Type: W2 Candidate Constraints: Duration:Long Term # of Layers:0 Work Eligibility:All Work Authorizations are Permitted – No Visa Transfers Key Technology: Skills and Experience Required: 10+ Years of Experience as a Data Architect with strong SQL skills. Strong hands on experience with Data Model Architecture Expert in designing data models, building views from tables loaded through ETL Solid understanding of database architecture – Relational models, replication strategies, SQL with 1 or more major database platforms (Oracle, SQL Server, DB2, Postgres, MySQL), Indexing, Tuning queries, Partitioning Ability to understand functional requirements, profile multiple data sources and define the right data model that can be used for reporting Extensive experience with operational data management disciplines, principles and practices such as Master Data Management, Metadata Management, and Data Quality Management Knowledge of cloud based architectures (Redshift, BigQuery, Azure SQL, Databricks), SaaS, PaaS including cloud migration strategies Implement best practices for Performance, Security, Scalability, and Availability (Data Governance) Write technical documentation that explains the rationale/logic behind a data model proposal Ability to design logical/physical BI models using Visio or other software Desired: Financial domain knowledge and experience Software engineering background #J-18808-Ljbffr