Data Architect

Nixon Peabody LLP; New York (NY); Remote; USD 112,000 - 168,000; Full time

Job summary

An established industry player is seeking a skilled Data Architect to lead the design and implementation of innovative data solutions. This role offers the opportunity to work with cutting-edge technologies in a dynamic environment that values collaboration and innovation. As a key player, you will drive architectural decisions, ensuring data integrity and optimizing performance across various platforms. With a focus on AI integration and big data solutions, this position is perfect for someone eager to shape the future of data architecture. Join a team that prioritizes growth and learning, and make a significant impact in a forward-thinking organization.

Qualifications

• 7+ years IT experience with 4 years as a Data Architect.
• Expertise in SQL development and ETL processes.
• Experience with cloud-native data solutions using Azure.

Responsibilities

• Design and develop scalable data architectures leveraging SQL Server and Azure.
• Implement ETL processes to integrate data from various sources.
• Collaborate with cross-functional teams to define data architecture solutions.

Skills

Data Governance

AI and Machine Learning Integration

Big Data Solutions

SQL Development

ETL Development

Data Modeling

Data Architecture

Cloud Services (Azure)

Education

Bachelor's Degree

Tools

SQL Server

Azure Data Factory

SSIS

PowerBI

Job description

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

5 days 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 design of enterprise-level data warehouse solutions with conventional database warehouse technologies and maintain the corporate data warehouse environment, within on-premises and cloud environment. This involves close collaboration with leaders and technologists, driving architectural decisions, data governance and successful implementation of scalable data systems. The Data Architect will also play a critical role in operational support across the entire data environment including managing data integrity, optimizing performance, and scaling solutions to meet evolving business needs. A remote work arrangement is available for this position.

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 design of enterprise-level data warehouse solutions with conventional database warehouse technologies and maintain the corporate data warehouse environment, within on-premises and cloud environment. This involves close collaboration with leaders and technologists, driving architectural decisions, data governance and successful implementation of scalable data systems. The Data Architect will also play a critical role in operational support across the entire data environment including managing data integrity, optimizing performance, and scaling solutions to meet evolving business needs. A remote work arrangement is available for this position.

A career at Nixon Peabody is the opportunity to do work that matters. It’s the chance to use your knowledge to shape what’s ahead. To share, to innovate, to learn at a firm that taps the power of collective thinking.

We’ve created a dynamic, energizing environment that promotes success for our clients and each other. We offer fast growth, connectedness and training in business as well as law. And our rigorous standards assure you are part of a diverse team of top talent at every turn.

If you’re someone who’s looking toward the future, we’d love to hear from you.

Location: Boston, MA; Chicago, IL; Los Angeles, CA; New York City, NY; Rochester, NY; San Francisco, CA; Washington, DC

• Design and develop scalable, efficient, and secure data architectures leveraging SQL Server, Azure services, and data fabrics.
• Implement robust data models, including multidimension modeling, to support complex business requirements and ensure data accuracy and consistency.
• Leverage Azure services such as Azure Data Factory, Azure SQL Database, Azure Synapse Analytics, and others to architect cloud-native data solutions.
• Design and implement Extract, Transform, Load (ETL) processes using SSIS and other relevant technologies to integrate data from various sources into the data architecture.
• Provide technical and operational oversight on database administration across the entire database environment including architecture, configuration, monitoring, maintenance, tuning and security
• Collaborate with cross-functional teams including developers, data engineers, data analysts, and business stakeholders to understand requirements, define data architecture solutions, and drive successful implementations.
• Document data architecture designs, standards, and best practices, and provide guidance and support to ensure adherence across projects.
• Maintain security compliance and adherence to ISO270001 certifications
• Populate and maintain a knowledge base (Application Portfolio) including installation documentation, problem resolutions, vendor contact information, change log, and other application information.
• Maintain technical proficiency and industry knowledge through participating in technical and business-related training programs, seminars and industry events
• Contribute to team efforts by participating in regularly scheduled team / project meetings
• Perform other duties as assigned
  
  
  

To perform this job successfully, you must be able to perform each essential job responsibility listed above, satisfactorily, with or without reasonable accommodation. Nixon Peabody retains the right to change or assign other duties to this position. The requirements listed below are representative of the skills and abilities required.

• Minimum of 7 years of Information Technology experience with at least 4 years of experience as a Data Architect or similar role.
• Bachelor’s degree from a four-year college or university
• AI and Machine Learning Integration: Experience in integrating AI and machine learning models into data architecture. This includes building and testing sustainable data infrastructure to facilitate data search and retrieval.
• Big Data Solutions: Proficiency in designing and implementing big data solutions
• Data Governance and Quality: Advanced skills in data governance and quality management, especially in multi-cloud environments.
• Modern Data Platforms: Knowledge of modern data platforms, mesh and lakehouse architecture and data fabrics
• AI-Driven Software Development: Understanding of AI-driven software development, including the use of large language models and image generation technologies including vector databases.
• Demonstrated experience in data warehousing principles, approaches, technologies, and architectures.
• Extensive knowledge of complex SQL development and troubleshooting (tables, views, stored procedures, functions, indexes, scripts, etc.)
• Expertise in ETL development using SSIS, and Azure Data Factory or similar tools.
• Experience with a reporting tool, preferably Reporting Services (SSRS, PowerBI), Qlik
• Knowledge of SQL Server 2016, 2019, 2022 environment
• Must be self-motivated and able to work independently with minimal supervision. Flexibility in work schedules (after hours support) required
• Strong organizational skills and a demonstrated ability to communicate on all levels
• Demonstrated ability to learn and apply new technologies quickly within a business environment
  
  
  

In accordance with applicable Federal and State laws, the anticipated annual salary range for this position, depending on location, is as follows:

• Rochester, NY: $93,000 to $138,050
• Boston, MA: $102,500 to $152,350
• Chicago, IL: $102,500 to $152,350
• Los Angeles, CA: $102,500 to $152,350
• Washington, DC: $102,500 to $152,350
• New York, NY: $112,500 to $167,200
• San Francisco, CA: $112,500 to $167,200
  
  
  

In addition to a standard benefits package, this role may be eligible for additional contingent compensation based on an array of factors, including but not limited to: work performance, geographic location, work experience, education, and qualifications. Because such contingent compensation is not yet calculable or may be zero ($0) in some circumstances, the above-listed salary range(s) are Nixon Peabody’s good faith estimate of the annual salary(ies) it reasonably expects to pay for the position at the time of this posting.

Nixon Peabody LLP is an Equal Opportunity / Affirmative Action Employer. Pursuant to the San Francisco Fair Chance Ordinance and the Los Angeles Fair Chance Initiative, we will consider for employment qualified applicants with arrest and conviction records.

To comply with Federal law, Nixon Peabody participates in E-Verify. All newly hired employees are verified through this electronic system established by the Department of Homeland Security (DHS) and the Social Security Administration (SSA) to confirm their identity and employment eligibility. Please refer to the Notice of E-Verify Participation and the Right to Work posters on the Nixon Peabody Careers page for more information.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Engineering and Information Technology

• Industries

  Law Practice

Referrals increase your chances of interviewing at Nixon Peabody LLP by 2x

Get notified about new Data Architect jobs in New York, NY.

New York, NY $140,000.00-$160,000.00 3 months ago

New York, NY $140,000.00-$200,000.00 1 month ago

New York City Metropolitan Area 2 weeks ago

Consulting Field Solutions Architect - Unstructured Data

New York City Metropolitan Area 2 days ago

Senior Presales Solutions Architect - East 2

Business Intelligence (BI) Architect/Lead - Remote

GCP Solutions Architect (Salesforce Integration Experience)

New York City Metropolitan Area 1 week ago

Director of Cloud Platform Engineering - Digital and Technology Partners - Remote

New York, NY $153,000.00-$210,000.00 4 months ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.