Business Intelligence Developer

Dechert LLP • Philadelphia, PA

113d

About The Position

We’re looking for a Business Intelligence Developer with strong data engineering and SQL expertise to join our team. This role focuses on building and maintaining robust data pipelines, ETL processes, and scalable data models to support analytics and reporting across the organization. As a Microsoft-focused environment, we rely heavily on SQL Server, SSIS, SSRS and SSAS, with Python supporting certain ETL workflows and Tableau powering our data visualization. You’ll work closely with teams across Finance, IT, Marketing and Operations to deliver reliable data solutions and actionable insights.

Requirements

• 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.
• 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.
• 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.

Nice To Haves

• 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.

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.
• Perform any and all other duties as necessary and as assigned by your supervisor for efficient functioning of the Department, Office and Firm.

Benefits

• Equal employment opportunity and non-discrimination policies.
• Commitment to attracting a diverse group of highly talented individuals.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Bachelor's degree
• Number of Employees: 501-1,000 employees