Data Platforms Engineer

Blank Rome LLP; United States; Remote; USD 100,000 - 115,000; Full time

Job summary

An established industry player is seeking a Data Platforms Engineer to enhance its data environment. This role involves designing and maintaining data systems, ensuring security, and transforming raw data into actionable insights. The ideal candidate will have extensive experience in data platforms, SQL, and various programming languages. This innovative firm offers a remote working arrangement while emphasizing collaboration and efficiency. Join a team dedicated to excellence in legal services and make a significant impact on data-driven initiatives.

Benefits

Medical insurance

Dental insurance

Vision insurance

401(k) retirement benefits

Commuter benefits

Annual discretionary bonuses

Profit-sharing contributions

Well-being programs

Qualifications

• 5+ years of experience in data platforms with strong SQL skills.
• Familiarity with tools like SSIS and Azure SQL preferred.

Responsibilities

• Monitor and improve data platform performance and security.
• Design and implement engineering solutions for business opportunities.

Skills

Data Platform experience

SQL DB design and maintenance

Transact-SQL

Programming objects

Troubleshooting skills

Power BI

Microsoft Suite

Communication skills

Education

Associate degree or equivalent technical education

Tools

SSIS

IntApp Integration Builder

Azure SQL

Microsoft Fabric

Job description

This range is provided by Blank Rome LLP. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$100,000.00/yr - $115,000.00/yr

About Us

Blank Rome is an Am Law 100 firm with 16 offices and nearly 750 attorneys who provide comprehensive legal and advocacy services to clients operating in the United States and around the world. Our professionals have built a reputation for their leading knowledge and experience across a spectrum of industries and are recognized for their commitment to pro bono work in their communities. Since our inception in 1946, Blank Rome’s culture has been dedicated to providing top-level service to all of our clients and has been rooted in the strength of our diversity and inclusion initiatives.

Job Overview

The Data Platforms Engineer assists with the data platform blueprint and design, encompassing the relevant data platform components. The Engineer is responsible for building and maintaining the data environment and the data housed within the platforms.

The Data Platforms Engineer will use various methods to transform raw data into useful data systems. The Engineer strives for efficiency by aligning data systems with business goals by combining data from diverse sources. The Engineer also benefits from familiarity with various programming languages.

This role has a remote working arrangement. Potential candidates must reside within one of the 10 states in which we have a physical office. In this role, you will report to the Senior Data Engineering, Platforms, and Architecture Manager.

Essential Functions

• Monitor systems performance and capacity, identifies, tests and coordinates data platforms, suggested improvements/upgrades and verifies results.
• Ensure adequate security.
• Prepare regular status reports for manager regarding progress towards achievement of objectives.
• Write and analyze queries, object oriented and/or scripting languages.
• Design and implement end-to-end engineering solutions for business opportunities.
• Build tools that enable the team to scale and effectively monitor the data environment.
• Install, deploy, and maintain data management tools.
• Create robust automated procedures to ingest and process structured and unstructured data from source systems into analytical platforms.
• Implement custom processes using tools such as SSIS, CozyRoc, Intapp Integration builder, Boomi, and other tools as required to address use cases.
• Engineers and supports data structures including but not limited to SQL databases.
• Engineer and maintain ELT processes for loading data.
• Leverage best-in-class tools to deliver modern data solutions.
• Support application and web teams’ development by writing stored procedures and other SQL queries/views.
• Research data questions, identifies root causes, and interacts closely with business users and technical resources.
• Performance tunes queries and stored procedures to keep databases and applications optimized.
• Identify technical obstacles and work closely with the team to find creative solutions.
• Possess ability to grasp new technologies rapidly to progress varied initiatives.
• Work with vendors as necessary to effectively integrate systems and data regardless of technical challenges or business environments.
• Perform other responsibilities as assigned.
• Work additional hours as needed to fulfill job requirements.

The above essential functions represent the general nature and level of responsibilities for this position and is not intended to be an all-inclusive list. The firm may modify and amend any job description at any time in its sole discretion.

Skills/Qualifications

• 5+ years of Data Platform experience.
• Associate degree or equivalent technical education (preferred).
• Experience in a legal environment or professional services (preferred).
• Experience with Microsoft Fabric (Lakehouse, Semantic Models, Pipelines, etc.) (preferred).
• Experience with SQL DB design and maintenance.
• Experience with Transact-SQL.
• Experience with Programming objects (Views, Triggers, Stored Procedures, etc.), Optimization and Performance Tools, Replication and Security.
• Sophisticated troubleshooting skills.
• Familiarity with IntApp Integration Builder and IIS(Boomi) (preferred).
• Experience using and building SSIS packages to gather and normalize data to/from various systems.
• Ability to develop SQL structures that support high volumes and scalability using RDBMS’s.
• Ability to model and design modern data structures, SQL/NoSQL databases, Cloud Data Warehouse.
• Experience building transactional databases.
• Experience with all versions of Windows.
• Experience using and developing in Power BI, on-prem and online.
• Knowledgeable in best practices guidelines from Microsoft, VMware, and storage vendors.
• Knowledgeable in Azure SQL cloud offerings.
• Understanding of disaster recovery terminology and design.
• Experience migrating SQL servers, on-prem and to/from cloud offerings.
• Unquestioned integrity and professionalism.
• Strong communication skills (verbal and written) with the ability to develop positive working relationships (in-person and virtually).
• Meticulous attention to detail and accuracy.
• Ability to manage multiple tasks with effective organizational skills.
• Proven problem solving, critical thinking, and decision-making skills.
• Working knowledge of the Microsoft Suite (Word, Excel, Outlook, Teams).
• Working knowledge of web-based conference call/web-sharing applications.
• Promote positive work habits, including effective and timely communication, teamwork, and demonstrating respect for colleagues.
• Contribute to providing the highest quality of service to internal and external clients.
• Take appropriate initiative and ownership of job responsibilities while ensuring the assignments/job duties are performed successfully and on time.
• Understand and abide by firm policies and embrace firm values.
• Ability to maintain regular attendance and work regularly scheduled hours.
• Ability to sit for long periods of time, type, and handle light lifting (files, copy paper, etc.) in a professional office environment.
• Comply with safe work practices including compliance with the firm’s COVID-19 policies and safety measures.

Compensation

The salary range for this role is $100,000 - $115,000. Actual salaries will depend on a candidate's geographic location, relevant experience, and skillset. The salary range listed is just one component of Blank Rome’s total compensation package for employees. Other monetary rewards include annual discretionary bonuses based on performance and profit-sharing contributions based on eligibility and firm profitability.

In addition, Blank Rome provides a comprehensive suite of benefits to promote health and financial security, including medical, dental, and vision insurance as well as life, accident, and disability insurance plans. The firm also provides the opportunity to participate in 401(k) retirement benefits, commuter benefits, and well-being programs.

EEO Statement

Blank Rome is an Equal Opportunity Employer and does not discriminate against any employee or applicant for employment because of race, color, ethnicity, religion, sexual orientation, gender, gender identity or expression, national origin, citizenship status, age, disability, genetic information, marital or family status, or any other status protected by law.

Our core values of respect for the individual, the community, and the law are clearly demonstrated in our ability to recruit and develop a diverse group of exceptionally talented attorneys and business professionals who enable us to best serve our clients and our communities.

Seniority level

Mid-Senior level

Employment type

Full-time

Job function

Information Technology

Industries

Law Practice