Data Architect

Nixon Peabody LLP; Washington (District of Columbia); Remote; USD 93,000 - 139,000; Full time

Job summary

An established industry player is seeking a Data Architect to design and implement cutting-edge data solutions. This role focuses on creating enterprise-level data architectures, optimizing performance, and ensuring data integrity in both on-premises and cloud environments. You'll collaborate with cross-functional teams, drive architectural decisions, and maintain compliance with industry standards. If you're passionate about data governance and innovative technologies, this opportunity offers a flexible work environment and the chance to make a significant impact on strategic objectives.

Qualifications

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

Responsibilities

• Design and develop scalable, efficient, and secure data architectures.
• Implement robust data models to support complex business requirements.

Skills

SQL Development

Data Governance

Big Data Solutions

ETL Development

AI and Machine Learning Integration

Communication Skills

Organizational Skills

Problem Solving

Education

Bachelor's Degree

Tools

SQL Server

Azure Data Factory

SSIS

Azure SQL Database

Azure Synapse Analytics

Job description

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

5 days ago Be among the first 25 applicants

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 with 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, data governance, and successful implementation of scalable data systems. Additionally, the Data Architect will support operational aspects across the data environment, including managing data integrity, optimizing performance, and scaling solutions to meet evolving 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 business requirements.
3. Leveraging Azure services such as Azure Data Factory, Azure SQL Database, Azure Synapse Analytics, etc., to architect cloud-native data solutions.
4. Designing and implementing ETL processes using SSIS and other relevant technologies.
5. Providing oversight on database administration, including architecture, configuration, monitoring, maintenance, tuning, and security.
6. Collaborating with cross-functional teams to understand requirements and drive successful implementations.
7. Documenting data architecture designs, standards, and best practices.
8. Maintaining security compliance and adherence to ISO270001 standards.
9. Maintaining a knowledge base including documentation, problem resolutions, vendor contacts, and change logs.
10. Participating in training and industry events to maintain technical proficiency.
11. Participating in team and project 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.
• Bachelor’s degree from a four-year college or university.
• Experience in AI and machine learning integration into data architecture.
• Proficiency in designing and implementing big data solutions.
• Skills in data governance and quality management, especially in multi-cloud environments.
• Knowledge of modern data platforms, mesh, lakehouse architecture, and data fabrics.
• Understanding of AI-driven software development and technologies like vector databases.
• 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 minimal supervision and flexible work schedule.
• Strong organizational and communication skills.
• Ability to quickly learn and apply new technologies.

Location & Salary:

Locations include Boston, MA; Chicago, IL; Los Angeles, CA; New York City, NY; Rochester, NY; San Francisco, CA; Washington, DC. Salary ranges vary by location, e.g., Rochester, NY: $93,000 - $138,050; Boston, MA: $102,500 - $152,350, etc.

Additional Information:

Includes benefits, contingent compensation, and participation in E-Verify. Nixon Peabody is an Equal Opportunity Employer and considers qualified applicants with arrest and conviction records.