Data Architect

Nixon Peabody LLP; San Francisco (CA); Remote; USD 120,000 - 160,000; Full time

Job summary

An established industry player is seeking a skilled Data Architect to design and implement innovative data solutions that support strategic objectives. This role involves architecting enterprise-level data warehouses, leveraging cutting-edge technologies like SQL Server and Azure services, and ensuring data integrity and performance optimization. The ideal candidate will have extensive experience in data architecture, governance, and modern data platforms. With a collaborative environment and opportunities for remote work, this position offers a chance to make a significant impact on the organization's data strategy and drive successful implementations.

Qualifications

• 7+ years of IT experience with 4+ years as a Data Architect.
• Experience in AI, Machine Learning, and big data solutions.

Responsibilities

• Designing scalable data architectures leveraging SQL Server and Azure services.
• Implementing ETL processes and ensuring data accuracy.

Skills

SQL Development

Data Governance

ETL Processes

AI and Machine Learning Integration

Big Data Solutions

Education

Bachelor's Degree

Tools

SQL Server

Azure Data Factory

Azure SQL Database

Azure Synapse Analytics

SSIS

PowerBI

SSRS

Job description

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

1 week ago Be among the first 25 applicants

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

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 with conventional database warehouse technologies and maintaining the corporate data warehouse environment within on-premises and cloud environments. The role involves close collaboration with leaders and technologists, driving architectural decisions, data governance, and successful implementation of scalable data systems. The Data Architect will also support operational aspects across the data environment, including managing data integrity, optimizing performance, and scaling solutions to meet business needs. A remote work arrangement is available.

Responsibilities include:

1. Designing and developing scalable, efficient, and secure data architectures leveraging SQL Server, Azure services, and data fabrics.
2. Implementing robust data models, including multidimensional modeling, to support complex requirements and ensure data accuracy.
3. Leveraging Azure services such as Azure Data Factory, Azure SQL Database, Azure Synapse Analytics to architect cloud-native data solutions.
4. Designing and implementing ETL processes using SSIS and other technologies to integrate data sources.
5. Providing oversight on database administration, including architecture, configuration, monitoring, and security.
6. Collaborating with cross-functional teams to understand requirements and drive implementation.
7. Documenting data architecture designs, standards, and providing guidance.
8. Maintaining security compliance and ISO270001 certifications.
9. Maintaining a knowledge base with documentation, change logs, and vendor info.
10. Participating in training, seminars, and industry events to stay current.
11. Participating in team meetings and performing other duties as assigned.

Minimum qualifications include:

1. At least 7 years of IT experience with 4+ years as a Data Architect or similar role.
2. Bachelor’s degree from a four-year college or university.
3. Experience in AI and Machine Learning integration, big data solutions, data governance, and modern data platforms.
4. Knowledge of SQL development, ETL tools, and reporting tools like SSRS, PowerBI.
5. Experience with SQL Server environments and self-motivation to work independently.

Salary ranges vary by location, and the role offers benefits and potential contingent compensation. Nixon Peabody is an Equal Opportunity Employer and participates in E-Verify.