Data Architect

Nixon Peabody LLP; Los Angeles (CA); Remote; USD 120,000 - 180,000; Full time

Job summary

An established industry player is seeking a skilled Data Architect to design and implement innovative data solutions. This role involves creating scalable data architectures, leveraging cutting-edge technologies like SQL Server and Azure services, and ensuring data governance across cloud environments. The ideal candidate will have extensive experience in data warehousing and a passion for integrating AI and machine learning into data architecture. Join a collaborative team that values flexibility and innovation, and play a pivotal role in shaping the data landscape of the organization. This is a fantastic opportunity to make a significant impact in a dynamic work environment.

Qualifications

• 7+ years of IT experience with 4+ years as a Data Architect.
• Proficient in designing big data solutions and data governance.

Responsibilities

• Design and develop scalable data architectures using SQL Server and Azure services.
• Implement ETL processes and ensure data integrity and performance.

Skills

Data Governance

SQL Development

Data Architecture

ETL Development

Cloud Solutions

AI Integration

Big Data Solutions

Communication Skills

Education

Bachelor's Degree

Tools

SQL Server

Azure Data Factory

SSIS

Azure Synapse Analytics

Job description

Join to apply for the Data Architect role at Nixon Peabody LLP.

Get AI-powered advice on this job and more exclusive features.

Job Description:

The Data Architect will play a crucial role in designing, implementing, and refining our data warehouse framework to support our organization's strategic objectives. This includes designing enterprise-level data warehouse solutions using conventional database warehouse technologies and maintaining the corporate data warehouse environment within on-premises and cloud environments. The role involves collaboration with leaders and technologists, driving architectural decisions, ensuring data governance, and implementing scalable data systems. Additionally, the Data Architect will support operational tasks such as managing data integrity, optimizing performance, and scaling solutions to meet evolving business needs. A remote work arrangement is available.

Responsibilities include:

• Designing and developing scalable, efficient, and secure data architectures leveraging SQL Server, Azure services, and data fabrics.
• Implementing robust data models, including multidimensional modeling, to support complex business requirements and ensure data accuracy and consistency.
• Leveraging Azure services such as Azure Data Factory, Azure SQL Database, Azure Synapse Analytics, and others for cloud-native data solutions.
• Designing and implementing ETL processes using SSIS and similar tools to integrate data from various sources.
• Providing oversight on database administration, including architecture, configuration, monitoring, tuning, and security.
• Collaborating with cross-functional teams to understand requirements and drive successful data architecture implementations.
• Documenting data architecture designs, standards, and best practices.
• Maintaining security compliance and adherence to ISO270001 standards.
• Maintaining a knowledge base with documentation, vendor contacts, change logs, etc.
• Participating in training, seminars, and industry events to stay current.
• Participating in team meetings and performing other duties as assigned.

Minimum qualifications:

• At least 7 years of IT experience with 4+ years as a Data Architect or similar role.
• Bachelor’s degree from a four-year college or university.
• Experience integrating AI and machine learning models into data architecture.
• Proficiency in designing big data solutions.
• Advanced skills in data governance and quality management, especially in multi-cloud environments.
• Knowledge of modern data platforms, mesh, lakehouse architecture, and data fabrics.
• Experience with AI-driven software development, including large language models and vector databases.
• Demonstrated experience in data warehousing principles, technologies, and architectures.
• Extensive SQL development and troubleshooting skills.
• Experience with ETL development using SSIS, Azure Data Factory, or similar tools.
• Knowledge of SQL Server environments (2016, 2019, 2022).
• Self-motivated with the ability to work independently and flexibility in work hours.
• Strong organizational and communication skills.
• Ability to quickly learn and apply new technologies.

Salary ranges vary by location and are estimated based on the position.

Nixon Peabody LLP is an Equal Opportunity Employer and participates in E-Verify.