Search Jobs

Find your next opportunity here.

Posted: 01/02/2025 Employment Type: Direct Hire Industry: SQL Database Architect Job Number: 42741

Job Description

Senior Data Architect
The Senior Data Architect is responsible for data modeling, validation, integrity, and security. The position requires significant skills in database design and optimization and the ability to interpret business rules into technical outcomes. This position will report to the CIO and will be tasked with creating an enterprise-wide data architecture with automated integrations among systems. This role will be responsible for executing the vision of a centralized data structure that promotes high quality and allows for reliable communication among systems used by legal and support staff alike.

Job duties will include but not be limited to:

Collaborate with IT leadership to implement data integration strategies to connect disparate data sources and take advantage of existing technologies, as well as bring forth new technologies that address business needs effectively.
Architect optimal and scalable data engineering solutions to extract, organize, and present solutions for stakeholder needs.
Create efficient Extract Transform and Load (ETL) processes to facilitate smooth data flow across firm systems.
Partner with Business Intelligence to ensure the data architecture supports reporting requirements and data analytics.
Review business processes with the Business Intelligence lead, recommend and implement supportable data changes, including any relevant tools to better secure those processes.
Advise and execute database designs and work together with the DBA lead to improve the structure, quality, and ownership of data from the agreed systems of record.
Work with Project Management team and Business Analysts to gather business and technical requirements on assigned projects.
Implement effective data models and develop best practices with the head of Information Governance for data integration and data security.
Manage the migration of data from legacy systems to new solutions.
Collaborate with subject matter experts from various firm departments and stakeholders to achieve firm strategic goals.
Create and maintain clear documentation of data models, database structures, and data management processes, as well as provide training to team members on data systems and best practices.

Skills & Competencies:

Effective communication skills, both written and oral
Strong interpersonal skills required to communicate with other IT team members, and members of the firm (users of systems).
Must have a customer service attitude and ability to work well with other groups.
Strong attention to detail and time management skills with a proven ability to multi-task

Qualifications & Required Experience:

Bachelor’s degree preferred, preferably in a computer-related field.
5+ years Data Architecture experience preferred
5+ years of experience in DBA roles preferred
Proven experience leading data integrations.
Microsoft or other industry certifications are a plus.
Prior Information Technology experience in the legal market is a plus.
The position requires the ability to work under pressure to meet strict deadlines.

Computer Skills:
To perform this job successfully, an individual must be proficient in the following software:

SQL standards and best practices, including optimization.
Master Data Management concepts and design.
Working knowledge of reporting tools such as PowerBI, Qlik, Tableau

DoE $125-145K

Meet Your Recruiter

Wendy Pearce

Apply Now:

Apply Later

Share This Job:

Apply Online

Apply with LinkedIn Apply with Facebook Apply with X

Share This Job:

Related Jobs:

About Chicago, IL

Unlock your potential in the bustling job market around Chicago, Illinois! Dive into a world of endless possibilities and growth opportunities in the Windy City and its vibrant suburbs. From iconic landmarks like the Willis Tower and Navy Pier to the world-class cuisine of deep-dish pizza and Chicago-style hot dogs, this area is rich in culture and charm. Immerse yourself in the thriving arts scene at the Art Institute of Chicago or enjoy a night out at the renowned Second City comedy club. With top-notch theaters, professional sports teams like the Cubs and the Bears, and lush green spaces like Millennium Park, Chicago offers an unbeatable lifestyle for career-driven individuals. Explore our job listings today and discover why Chicago is the perfect place to kickstart your career journey!