Reporting & Integrations Engineer

Dicello Levitt LLP
Chicago, United States of America
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate

Job location

Chicago, United States of America

Tech stack

Microsoft Windows
API
Artificial Intelligence
Data analysis
Azure
Databases
Data Files
Data Integration
ETL
Data Mining
Data Visualization
Relational Databases
Database Design
Software Debugging
Document Management Systems
Python
Power BI
Salesforce
SharePoint
SQL Databases
Systems Integration
Tableau
Workflow Management Systems
Data Processing
Scripting (Bash/Python/Go/Ruby)
File Transfer Protocol (FTP)
Data Storage Technologies
Cloud Platform System
GIT
Information Technology
QlikView
Data Pipelines
Programming Languages

Job description

Join a firm that is shaping front-page headlines pursuing justice every day, whether litigating some of the most significant civil and human rights cases of our time or ensuring that companies take responsibility for their actions and remediate the harm they have caused., The Reporting & Integrations Engineer position sits at the intersection of data analysis, ETL (Extract, Transform, Load) automation, and emerging AI capabilities with a focus on supporting the firm's capabilities advancement in data visualization and analysis capabilities. This role is responsible for designing, building, and maintaining data pipelines, integrations, and reporting solutions across enterprise systems. As part of the firm's Product team, this role plays a key role in enabling automation, improving data accessibility, and supporting business intelligence through scalable solutions. Major Duties & Responsibilities:

  • Perform statistical analysis and generate reports to identify trends, patterns, and key insights that inform business decisions.
  • Design, develop, and maintain data pipelines and ETL processes to support reporting and analytics needs with a focus on optimizing statistical efficiency and quality.
  • Build and manage API/REST integrations between internal enterprise systems and third-party platforms.
  • Develop and optimize SQL queries and Python scripts for data processing, transformation, and automation.
  • Monitor, troubleshoot, and debug automation workflows and data processes to ensure reliability and accuracy.
  • Implement and maintain version-controlled code (Git) for scripts, pipelines, and integration solutions.
  • Automate recurring tasks using scheduling and/or orchestration tools, like Windows Task Scheduler.
  • Maintains current and accurate knowledge of data storage and management best practices.
  • Create clear, actionable visualizations and dashboards for both technical and non-technical audiences.
  • Design and maintain interactive dashboards and reports using BI tools like Tableau or Power BI.
  • Integrate data from multiple sources and ensure data consistency for accurate reporting.
  • Monitor data quality, identify gaps or inconsistencies, and recommend improvements to data collection processes or reporting methods to enhance decision-making accuracy.
  • Ensures that database projects are completed on time and within estimated costs.
  • Work closely with cross-functional teams (e.g., practice groups, Finance, Human Resources, IT) to understand business needs, deliver actionable insights, and integration requirements.
  • Document system dependencies, workflows, and integrations for maintenance and knowledge sharing.
  • Performs other duties as assigned.

Requirements

Do you have experience in Windows?, Do you have a Master's degree?, * Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.

  • Demonstrated proficiency in Python or other coding languages for scripting, automation, and/or data manipulation.
  • Strong skills in SQL for querying, extracting, and manipulating data from relational databases.
  • Familiarity with data modeling, ETL (Extract, Transform, Load) processes, and integrating data from multiple sources.
  • Curiosity about data and a passion for finding answers hidden in data sets.
  • Analytical, diligent, and rigorous in your approach to problems.
  • Technical expertise regarding data models, database design development, data mining, and segmentation techniques.
  • Ability to interpret data in a business context, providing actionable insights and solving complex analytical problems.
  • Strong written and verbal communication skills for presenting findings to stakeholders and working effectively with cross-functional teams.
  • Ability to multitask and prioritize multiple high-level assignments in a fast-paced environment.
  • Extremely organized with great attention to detail.
  • Knowledge of legal industry processes is a plus, though not required., * Bachelor's degree in Information Technology, Business Intelligence or Analytics, other related field, or equivalent work experience required.
  • A minimum of four years of experience in a similar role.
  • Experience with business intelligence tools such as Tableau, Power BI, Qlik, or similar platforms for data visualization and reporting.
  • Salesforce certification(s) such as Salesforce Administrator or Platform App Builder not required, but beneficial.
  • Experience with AI integrations, SharePoint environments and integrations, SFTP workflows, and Azure or other similar cloud platform preferred.
  • Experience in statistical modeling, advanced data analysis, and complex data visualization.
  • Optional: A Master's Degree in a more specialized area, such as Applied Analytics or Data Science.

Benefits & conditions

Pulled from the full job description

  • AD&D insurance
  • Health insurance
  • Paid time off
  • Vision insurance
  • Health savings account
  • Dental insurance
  • Life insurance, * Comprehensive benefits package, effective the first day of the month following your start date: medical, dental, vision
  • Health Savings Account (HSA)
  • Life Insurance
  • Additional Insurance Plans: Life and AD&D and Short-Term Disability plans
  • 401(k) retirement savings plan with 3% employer contribution

Time Off:

  • Personal Time Off (PTO)
  • Sick Leave Time (SLT)
  • 10 Paid Holidays Annually

About the company

DiCello Levitt, a nationally prominent, Chambers and Benchmark-rated law firm with offices nationwide, is seeking interested individuals for the Product Management group in the Firm's Chicago, IL office., DiCello Levitt is a leading national plaintiffs' law firm representing clients in class action, business-to-business, public client, whistleblower, personal injury, civil rights, and mass tort litigation. The firm has delivered $20B+ in awards and settlements to our clients and has been recognized for our excellence in litigation by Chambers USA, Law360, Benchmark Litigation, Lawdragon, and The National Law Journal.

Apply for this position