Data Architect
Share
Job Location:
Roseland, CA - USA
Monthly Salary:
$ 150000 - 160000
Posted on:
01-11-2025
Vacancies:
1 Vacancy
Job Summary
Description
Who We Are:
Lowenstein Sandler is one of the most sophisticated law firms in the United States with over 375 lawyers and 300 business services professionals serving clients from offices in New York Palo Alto New Jersey Utah and Washington D.C. We recruit candidates who seek a collaborative entrepreneurial culture that prioritizes our clients our colleagues and the communities where we work and live. Committed to career development and to a diverse equitable and inclusive workplace the firm offers many programs and opportunities for personal and professional growth. We seek professionals for our business services group who share these values.
What You Will Do:
The Data Architect will be responsible for designing implementing and managing a robust enterprise data architecture for the firm with a particular focus on building and optimizing a data lakehouse using Microsoft Fabric with Delta Lake and Parquet file formats organized and governed through the Medallion Architecture (Bronze Silver and Gold layers). This platform will serve as the foundation for both analytics and machine learning initiatives providing seamless integration with Power BI for business intelligence while maintaining compatibility with advanced AI/ML platforms for future workloads. Leveraging all related Microsoft Fabric tools and Microsoft Purview for data governance the Data Architect will ensure high performance interoperability and availability of data across the firm.
Data Architecture & Strategy:
- Lead the design and implementation of a modern data architecture to support the firms business and legal operations.
- Architect develop and maintain a secure scalable and high-performance data lakehouse built on Medallion Architecture principles leveraging the Delta Lake format for ACID transactions time travel and schema evolution.
- Implement the Bronze (raw ingestion) Silver (validated and standardized) and Gold (curated analytics-ready) data layers to support the lifecycle of data transformation and refinement.
- Design data storage strategies using Parquet file format optimized for analytical workloads and columnar data processing.
- Define strategies to ensure seamless integration with Power BI for analytics and reporting while maintaining Delta Lake compatibility to support advanced machine learning and AI use cases on compatible platforms.
- Establish data modeling standards practices and governance for structured and unstructured data.
- Define strategies for metadata management master data management and data quality frameworks.
- Utilize Microsoft Fabric tools (e.g. Data Factory Synapse Data Engineering Power BI Data Activator and related services) to orchestrate data pipelines and integrations.
- Develop and maintain ETL/ELT processes for ingestion transformation and distribution of data across systems.
- Engineer data movement and transformation logic aligned with Medallion layer principles ensuring traceability and lineage from raw to curated datasets.
- Ensure interoperability between on-premises systems cloud platforms and external data sources.
- Implement and optimize Delta Lake-based storage using Parquet file format for unified analytics and machine learning pipelines enabling ACID transactions and time travel capabilities for historical data queries.
- Implement and manage Microsoft Purview for comprehensive data governance cataloging classification and lineage tracking across the enterprise.
- Collaborate with Information Security to enforce compliance with data privacy security and regulatory requirements.
- Implement role-based access controls encryption standards and monitoring to protect sensitive client and firm data.
- Partner with business stakeholders attorneys and service professionals to understand data needs and translate them into scalable solutions.
- Provide technical guidance and mentorship to database developers analysts and engineers.
- Serve as a subject matter expert on Microsoft Azure Fabric Delta Lake Parquet file format Medallion Architecture and Microsoft Purview data services.
- Bachelors or Masters degree in Computer Science Information Systems Data Management or related field.
- Minimum of 3 years of experience in data architecture and engineering.
- Proven expertise with Microsoft Azure Data Services and Microsoft Fabric including full utilization of F64 SKU capacity features and integrated toolsets.
- Hands-on experience developing and optimizing Delta Lake-based data lakehouses with Parquet storage.
- Strong working knowledge of Medallion Architecture (Bronze Silver Gold layers) for data transformation standardization and analytics enablement.
- Deep understanding of Delta Lakes ACID transaction capabilities time travel features and schema evolution for maintaining data quality and auditability.
- Experience with Parquet file format optimization for analytical workloads and columnar storage.
- Experience with Microsoft Purview for data governance cataloging data lineage and compliance management.
- Strong experience with data lake design data warehousing and distributed data processing.
- Proficiency in SQL Python and data transformation frameworks.
- Minimum of 2-3 years of experience developing and optimizing Power BI reports dashboards and data models.
- Experience with data warehouse tools and lakehouse platforms beyond Microsoft (e.g. Databricks Snowflake Amazon Redshift Google BigQuery) is a plus.
- Familiarity with legal technology applications such as Aderant and Intapp a plus.
- Strong analytical problem-solving and communication skills.
- Ability to work collaboratively with both technical and non-technical stakeholders.
Schedule: Full-Time Hybrid Monday-Friday (9:00 am 5:00 pm EST)
Amount of Travel Required: None
For candidates meeting the requirements the expected base salary is $150000 to $160000. The range provided is the salary that Lowenstein Sandler in good faith believes at the time of this posting that it is willing to pay for the advertised position. Exact compensation will be determined based on individual candidate qualifications and location. Our benefits package includes coverage options for medical dental vision prescription drug life insurance disability FSAs 401K and paid time off.
Disclaimers:
This job description is not designed to cover or contain a comprehensive listing of all activities duties or responsibilities required by employee.
Lowenstein Sandler LLP is not accepting resumes from search firms for this position. Regardless of past practice all resumes submitted by search firms are to be deemed the sole property of Lowenstein Sandler LLP and no fee will be paid in the event the candidate is hired by Lowenstein Sandler LLP as a result of the referral.
Lowenstein Sandler LLP is committed to equal employment opportunity and providing reasonable accommodations to applicants with physical and/or mental disabilities. We value and encourage diversity and solicit applications from all qualified applicants without regard to race color gender sex age religion creed national origin ancestry citizenship marital status sexual orientation physical or mental disability medical condition veteran status gender identity genetic information or any other characteristic protected by federal state or local law.
Key Skills
- Fund Management
- Drafting
- End User Support
- Infrastructure
- Airlines
- Catia
About Company
Lowenstein Sandler is a national law firm with more than 300 lawyers working from five offices in New York, New Jersey, California, Washington, D.C., and Utah.
