What are the responsibilities and job description for the Data Architect position at CORNERSTONE ADVISORS OF ARIZONA LLC?
Job Details
Job Location: Cornerstone Advisors of Arizona LLC AZ - Scottsdale, AZ
Position Type: Full Time
Education Level: 4 Year Degree
Salary Range: Undisclosed
Travel Percentage: None
Job Category: Information Technology
Description
General Information
Description: The data architect is responsible for designing, creating, and managing an organization’s data architecture. This role ensures that data is organized, accessible, secure, and aligned with business objectives. The data architect designs warehouses, file systems, and databases, and defines how data will be collected and organized.
Responsibilities
- Interprets and delivers impactful strategic plans improving data integration, data quality, and data delivery in support of business initiatives and roadmaps
- Designs the structure and layout of data systems, including databases, warehouses, and lakes
- Defines and implements the long-term technology strategy and innovations roadmaps across analytics, data engineering, and data platforms
- Designs and implements processes for the ETL process from various sources into the organization’s data systems
- Translates high-level business requirements into data models and appropriate metadata, test data, and data quality standards
- Simplifies the existing data architecture, delivering reusable services and cost-saving opportunities in line with the policies and standards of the company
- Defines and manages standards, guidelines, and processes to ensure data quality
- Evaluate and recommend emerging technologies for data management, storage, and analytics
Qualifications
Job Requirements
Education
- A bachelor’s degree in computer science, data science, engineering, or related field
Experience
- At least five years of relevant experience in design and implementation of data models for enterprise data warehouse initiatives
- Experience leading projects involving data warehousing, data modeling, and data analysis
- Design experience in Azure Databricks, and Power BI
Skills
- Strong ability in programming languages such as Java, Python, and C/C
- Ability in data science languages/tools such as SQL, R, SAS, or Excel
- Proficiency in the design and implementation of modern data architectures and concepts such as cloud services (AWS, Azure, GCP), real-time data distribution (Kafka, Dataflow), and modern data warehouse tools (Snowflake, Databricks)
- Experience with database technologies such as SQL, NoSQL
- Understanding of entity-relationship modeling, metadata systems, and data quality tools and techniques
- Ability to think strategically and relate architectural decisions and recommendations to business needs and client culture
- Ability to assess traditional and modern data architecture components based on business needs
- Experience with business intelligence tools and technologies such as ETL, Power BI, and Tableau
- Ability to regularly learn and adopt new technology, especially in the ML/AI realm
- Strong analytical and problem-solving skills
- Ability to synthesize and clearly communicate large volumes of complex information to senior management of various technical understandings
- Ability to collaborate and excel in complex, cross-functional teams involving data scientists, business analysts, and stakeholders
- Ability to guide solution design and architecture to meet business needs.