Business Intelligence Developer

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.

Job Description

Essential Job Functions:

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

Knowledge, Skills And Abilities:

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

Education And Experience:

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

Additional Job Description

Location(S)

Philadelphia

Time Type

Full time

Dechert LLP is committed to ensuring equal employment opportunity and non-discrimination.  The Firm prohibits unlawful discrimination in any term or condition of employment against any employee or applicant for employment because of the individual’s race, color, creed, religion, sex, age, marital status, national origin, ancestry, citizenship, sexual orientation, gender identity or expression, genetic information, disability, membership or service in the armed forces, or any other characteristic protected by law.