Data Architect

Nixon Peabody LLP; Chicago (IL); Remote; USD 90,000 - 150,000; Full time

Job summary

An established industry player is seeking a Data Architect to lead the design and implementation of innovative data solutions. This role involves crafting scalable data architectures, optimizing performance, and ensuring data integrity across diverse environments. With opportunities to work remotely, you will collaborate with cross-functional teams and drive architectural decisions while adhering to best practices in data governance and security. This is a chance to leverage your expertise in SQL, Azure services, and modern data platforms in a dynamic and supportive environment, making a significant impact on the organization's strategic objectives.

Qualifications

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

Responsibilities

• Design and develop scalable data architectures leveraging SQL Server and Azure services.
• Implement ETL processes and maintain data integrity.
• Collaborate with cross-functional teams for successful data architecture implementations.

Skills

Data Governance

SQL Development

AI and Machine Learning

Data Quality Management

Cloud Environments

Communication Skills

Organizational Skills

Education

Bachelor’s Degree in IT

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

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 implementing scalable data systems. The Data Architect will also support operational needs across the data environment, including managing data integrity, optimizing performance, and scaling solutions. 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. Utilizing Azure services such as Azure Data Factory, Azure SQL Database, Azure Synapse Analytics for cloud-native data solutions.
4. Designing and implementing ETL processes using SSIS and similar technologies.
5. Providing oversight on database administration, including architecture, configuration, monitoring, and security.
6. Collaborating with cross-functional teams to understand requirements and drive successful data architecture implementations.
7. Documenting data architecture designs, standards, and best practices.
8. Maintaining security compliance and adhering to ISO270001 standards.
9. Maintaining a knowledge base including installation documentation, problem resolutions, and change logs.
10. Participating in training and industry events to stay current with technology trends.
11. Participating in team meetings and performing other duties as assigned.

Minimum qualifications:

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, Machine Learning integration, and big data solutions.
4. Advanced skills in data governance, quality management, and multi-cloud environments.
5. Knowledge of modern data platforms, mesh, lakehouse architecture, and data fabrics.
6. Experience with SQL development, troubleshooting, and ETL tools like SSIS and Azure Data Factory.
7. Proficiency with reporting tools such as SSRS, PowerBI, or Qlik.
8. Knowledge of SQL Server environments (2016, 2019, 2022).
9. Self-motivated with strong organizational and communication skills.
10. Ability to learn new technologies quickly.

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