Business Intelligence Developer

Overview Ogletree’s Knowledge and Innovation department has an opportunity for an experienced Business Intelligence Developer to join the expanding department. The Business Intelligence (BI) Developer is responsible for designing, developing, and maintaining analytics solutions that support data-driven decision-making across the organization. This role works closely with business partners to gather requirements, build scalable BI datasets, create dashboards and reports, and maintain the underlying data infrastructure that powers business insights. The BI Developer also performs complex data analysis, ensures data quality, and supports client-facing reporting needs. We will consider qualified applicants with criminal histories in the manner consistent with the Los Angeles Fair Chance Initiative for Hiring. Qualified applicants with arrest and conviction records will be considered for the position in accordance with the Fair Chance Ordinance. Responsibilities Essential Functions - Data Analysis & Insights: Analyze, interpret, and visualize trends or patterns in complex data sets to support business decisions. Perform data quality reviews and data assessments to identify anomalies, inconsistencies, and improvement opportunities. Generate ad-hoc reports for internal stakeholders and external clients under tight deadlines. Essential Functions - Business Intelligence Development: Design, develop, deploy, and manage Power BI/Tableau datasets, dashboards, and paginated reports. Build effective, user-friendly visualizations that meet business requirements and align with reporting standards. Maintain and enhance existing BI solutions to improve performance, usability, and data accuracy. Essential Functions - SQL Development & Database Management: Write, optimize, and maintain SQL queries to extract and manipulate data from enterprise data systems. Build, maintain, and enhance SQL Server stored procedures to support automated reporting and data pipelines. Enhance and troubleshoot existing SQL queries and database logic to improve performance and reliability. Essential Functions - Cross-Functional Collaboration: Collaborate with business partners across departments to capture reporting requirements, clarify data needs, and design effective BI solutions. Serve as a key technical liaison between business teams, IT, and data stakeholders. Interact with client contacts regularly to deliver reporting, understand needs, and provide support. Essential Functions - Data Systems & Collaboration Tools: Develop and maintain SharePoint and Smartsheet solutions used for workflow management, collaboration, and data consolidation. Ensure data governance standards, documentation, and best practices are adhered to across BI assets. Requirements Bachelor’s degree in Data Analytics, Information Systems, Computer Science, Business, or a related field; or equivalent experience. Strong proficiency in SQL, including stored procedure development. 3-5 years of experience with Power BI, Tableau, or similar BI visualization tools. Ability to analyze large and complex data sets. Experience creating dashboards, reports, and data models. Strong background in data modeling, DAX/MDX, or equivalent analytics languages. Strong communication skills, with experience gathering and translating business requirements. Analytical thinking and problem-solving. Strong attention to detail. Technical proficiency in BI and database tools. Business requirements gathering. Cross-functional communication. Time management and ability to meet tight deadlines. Preferred Experience with SharePoint, Smartsheet, or similar collaboration tools. Knowledge of ETL concepts or familiarity with data pipelines. Familiarity with Microsoft Fabric’s end-to-end analytics capabilities, including integration with Power BI and OneLake. Experience working directly with clients or business stakeholders. Understanding of data governance, metadata, and data quality best practices. Hands-on experience with Python frameworks or libraries. Benefits In accordance with various state laws, the expected salary ranges for this position vary by location. This position qualifies for the benefits below. The application deadline for this position is December 31, 2026. Ogletree Deakins offers a robust suite of benefits for our staff including: Paid Time Off, Paid Sick Leave, a 401(k) matching program, Profit Sharing, Paid Holidays, Paid Parental Leave, health and life insurance including dental & vision coverage, Health Savings Account / Flexible Spending Accounts to help offset the cost of dependent care and/or health care expenses, Tuition Reimbursement and an Employee Assistance Program. Contact Information If you have questions, please e-mail Libby Naikelis at View email address on click.appcast.io with “Business Intelligence Developer" in the subject line. Applications submitted via e-mail will not be considered. Firm Overview Ogletree Deakins is one of the largest labor and employment law firms representing management in all types of employment-related legal matters. Equal Opportunity Employer. #J-18808-Ljbffr