Apply on Employer Site

Dechert LLP · 8 hours ago

Business Intelligence Developer

Philadelphia, PA

Full-time

Onsite

Mid Level

3+ years exp

Dechert LLP is seeking a Business Intelligence Developer to join their team, focusing on building and maintaining data pipelines and ETL processes. The role involves collaborating with various departments to deliver reliable data solutions and actionable insights using Microsoft technologies and tools like SQL Server, SSIS, and Tableau.

AdviceConsultingLaw EnforcementLegal

Comp. & Benefits

H1B Sponsor Likely

Responsibilities

Design, develop, and maintain ETL processes using SSIS and Python, ensuring accuracy and efficiency of data

Develop and optimize SQL scripts, stored procedures, and queries for large, complex datasets in SQL Server data warehouses

Collaborate with stakeholders to define data requirements, build data models, and deliver analytical solutions that drive decisions

Support and enhance Tableau dashboard and SSRS reports, ensuring data consistency and usability

Monitor, troubleshoot, and optimize existing workflows and data pipelines for performance and reliability

Identify opportunities to improve data quality, architecture and BI processes

Provide documentation and communicate project progress and updates to BI leadership and business stakeholders

Support both FP&A and Business Intelligence teams in day-to-day operations, analysis, and reporting

Utilize proprietary AI tools to enhance reporting accuracy, streamline workflows, and uncover new insights

Performs any and all other duties as necessary and as assigned by your supervisor for efficient functioning of the Department, Office and Firm

Qualification

SQLSSISETL processesTableauPythonSSRSSSASMicrosoft ExcelData modelingAnalytical skillsCommunication skillsProblem-solving

Required

Strong proficiency in SQL – complex joins, stored procedures, indexing and query optimization

Hands-on experience with SSIS for ETL and data ingestion

Strong foundation in Microsoft Excel; familiarity with pivot tables, advanced formulas, and data modeling

Excellent analytical, organizational, and communication skills

Ability to interpret data, generate insights, and communicate findings clearly to both technical and non-technical stakeholders

Desire to learn and grow in both technical and business-focused dimensions

Team-oriented, adaptable, and proactive in problem-solving

Bachelor's Degree in Computer Science, Information Systems, or a related field (or equivalent work experience)

3-5 years of relevant experience in business intelligence or data development roles

Preferred

Experience with Tableau for reporting and visualization is a plus

Exposure to SSRS and SSAS is a plus

Exposure to Python for data analysis or automation is a plus

Familiarity with service-based industries and/or financial systems (e.g., general ledger) is a plus

Understanding of data warehousing concepts, such as star/snowflake schema design is a plus

Company

Dechert LLP

Glassdoor3.7

Dechert is the law firm that helps business leaders lead.

Founded in 1875

Philadelphia, Pennsylvania, USA

1001-5000 employees

http://www.dechert.com/

H1B Sponsorship

Dechert LLP has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (27)

2024 (15)

2023 (9)

2022 (14)

2021 (11)

2020 (10)