Ogletree Deakins
Business Intelligence Developer

How your CV stacks up
Upload your CV to see how well it fits this job role
?%
Position Summary
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.
Please note, we are looking for a candidate with Salesforce experience for this opening. If you do not have Salesforce experience, please apply to our other Business Intelligence Developer opening found here.
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.
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.
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.
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.
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.
Reasons to use Rodeo
I’m in my final year doing Economics and I don’t know whether to apply for grad schemes now or do a masters first. What do you think?
Honest answer — it depends on where you want to end up. A lot of top grad schemes (Big 4, civil service, banking) don’t need a masters. Let’s look at the ones you’d be competitive for now, and we can decide if a masters actually adds anything.
Also worth knowing: most autumn 2026 applications are open now. Timing matters more than you think.
Start with a chat, not a search bar
Grad scheme, placement, apprenticeship? Not sure what you want yet — that's fine. Your agent talks it through with you and turns "I have no idea" into a shortlist.
Graduate Consultant — 2026 Scheme
Why you're a good match
StrongYour economics background and your summer at a regional bank line up with what PwC looks for on the consulting scheme. Applications close in four weeks.
See breakdownIt searches the market for you
Every day your agent scans the market matching roles against what actually matters to you, not just keywords on a CV.
Why you're a good match
You’ve got the grades and the economics background, and your bank internship is exactly the experience this scheme looks for. Apply soon — deadlines close within the month.
Experience fit
Your summer at the bank plus your econometrics coursework map directly to the day-one responsibilities on this scheme — client modelling, market briefings, and deal support.
Only hits
No noise. No "maybe this fits." Just roles with a clear explanation of why they're right — and where to focus when applying.
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
- Salesforce experience is strongly 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.
Wage Transparency
The pay range for this remote position varies by location. Pursuant to the applicable state and local regulations the pay range for each location is listed below. Actual compensation is contingent on relevant experience, education, skills, and other job-related factors as permitted by law.
Ogletree is a multi-state employer. The pay ranges listed reflect compensation for the specific location identified. For roles performed in locations not listed, compensation will be determined based on the applicable location for the position. This role is also eligible for performance-based bonuses and the benefits described below. The application deadline for this position is 12/31/2026.


Get help with your application
Your very own career expert that helps elevate your application to the next level.
Pay Ranges by Location
- California: Pay range $102,095 to $176,545
- Colorado: Pay range $107,744 to $161,616
- Connecticut: Pay $112,771 to $169,157
- Illinois: Pay range $112,771 to $169,157
- Jersey City, New Jersey: Pay range $117,697 to $176,545
- Nevada: $98,977 to $123,721
- Maryland: Pay range $102,095 to $127,619
- Massachusetts: Pay range $117,697 to $147,121
- Minnesota: Pay range $102,095 to $127,619
- New Jersey: Pay range $117,697 to $176,545
- New York City, New York: Pay range $117,697 to $147,121
- New York State: Pay range $117,697 to $147,121
- Ohio: Pay range $98,977 to $123,721
- Rhode Island: Pay range $98,977 to $123,721
- Washington, D.C.: Pay range $112,771 to $169,157
- Washington (State): Pay range $112,771 to $169,157
Benefits
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, affordable 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 at Libby.Naikelis@ogletree.com with “Business Intelligence Developer" in the subject line. Please note, 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. Best Law Firms® has named Ogletree Deakins a “Law Firm of the Year” for 14 consecutive years. In the 2025 edition, the publication named Ogletree Deakins its “Law Firm of the Year” in the Litigation – Labor and Employment category. Ogletree Deakins has more than 1,100 attorneys located in 60 offices across the United States and in Europe, Canada, and Mexico. The firm represents a diverse range of clients, including many of the Fortune 50 companies in the U.S.
We are fully committed to the importance of diversity within the legal profession, as well as all workplace environments.
Equal Opportunity Employer.
“It took my CV and asked me questions relevant to understanding what kind of jobs to suggest for me. Suggestions were almost perfect. Jobs were exactly what I’ve been looking for.”
Jessica, London
Skills
Location