Business Intelligence Developer

April 30, 2026

Other Jobs To Apply

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 <a href="https://careers.ogletree.com/jobs/6350?lang=en-us">here.</a> We will consider qualified applicants with criminal histories in the manner consistent with the <a title="http://clkrep.lacity.org/onlinedocs/2014/14-0746_ord_184652_12-9-16.pdf" href="http://clkrep.lacity.org/onlinedocs/2014/14-0746_ORD_184652_12-9-16.pdf" target="_blank" rel="noopener">Los Angeles Fair Chance Initiative for Hiring. </a>Qualified applicants with arrest and conviction records will be considered for the position in accordance with the <a title="https://sfgov.org/olse/sites/default/files/filecenter/documents/11600-art%20%2049%20official%20notice%20final%20091114.pdf" href="https://sfgov.org/olse/sites/default/files/FileCenter/Documents/11600-Art%20%2049%20Official%20Notice%20Final%20091114.pdf" target="_blank" rel="noopener">Fair Chance Ordinance.</a> Essential Functions Data Analysis & Insights<ul style="margin-top: 0in;"><li>Analyze, interpret, and visualize trends or patterns in complex data sets to support business decisions.</li><li>Perform data quality reviews and data assessments to identify anomalies, inconsistencies, and improvement opportunities.</li><li>Generate ad-hoc reports for internal stakeholders and external clients under tight deadlines.</li></ul>Business Intelligence Development<ul style="margin-top: 0in;"><li>Design, develop, deploy, and manage Power BI/Tableau datasets, dashboards, and paginated reports.</li><li>Build effective, user-friendly visualizations that meet business requirements and align with reporting standards.</li><li>Maintain and enhance existing BI solutions to improve performance, usability, and data accuracy.</li></ul>SQL Development & Database Management<ul style="margin-top: 0in;"><li>Write, optimize, and maintain SQL queries to extract and manipulate data from enterprise data systems.</li><li>Build, maintain, and enhance SQL Server stored procedures to support automated reporting and data pipelines.</li><li>Enhance and troubleshoot existing SQL queries and database logic to improve performance and reliability.</li></ul>Cross-Functional Collaboration<ul style="margin-top: 0in;"><li>Collaborate with business partners across departments to capture reporting requirements, clarify data needs, and design effective BI solutions.</li><li>Serve as a key technical liaison between business teams, IT, and data stakeholders.</li><li>Interact with client contacts regularly to deliver reporting, understand needs, and provide support.</li></ul>Data Systems & Collaboration Tools<ul style="margin-top: 0in;"><li>Develop and maintain SharePoint and Smartsheet solutions used for workflow management, collaboration, and data consolidation.</li><li>Ensure data governance standards, documentation, and best practices are adhered to across BI assets.</li></ul> Requirements <ul style="margin-top: 0in;"><li>Bachelor’s degree in Data Analytics, Information Systems, Computer Science, Business, or a related field; or equivalent experience.</li><li>Strong proficiency in SQL, including stored procedure development.</li><li>3-5 Years of Experience with Power BI, Tableau, or similar BI visualization tools.</li><li>Ability to analyze large and complex data sets.</li><li>Experience creating dashboards, reports, and data models.</li><li>Strong background in data modeling, DAX/MDX, or equivalent analytics languages.</li><li>Strong communication skills, with experience gathering and translating business requirements.</li><li>Analytical thinking and problem-solving</li><li>Strong attention to detail</li><li>Technical proficiency in BI and database tools</li><li>Business requirements gathering</li><li>Cross-functional communication</li><li>Time management and ability to meet tight deadlines</li></ul>Preferred<ul style="margin-top: 0in;"><li>Salesforce experience is strongly preferred.</li><li>Experience with SharePoint, Smartsheet, or similar collaboration tools.</li><li>Knowledge of ETL concepts or familiarity with data pipelines.</li><li>Familiarity with Microsoft Fabric’s end-to-end analytics capabilities, including integration with Power BI and OneLake.</li><li>Experience working directly with clients or business stakeholders.</li><li>Understanding of data governance, metadata, and data quality best practices.</li><li>Hands-on experience with Python frameworks or libraries</li></ul> Benefits In accordance with the Colorado Equal Pay for Equal Work Act, the expected salary range for this Colorado position is between $107,744 and $161,616. In accordance with New York State’s Wage Transparency Law, the expected salary range for this New York State position is between $98,977 and $176,545. In accordance with California’s amended labor code as stated in Senate Bill 1162, the expected salary range for this California position is between $102,095 and $176,545. In accordance with the Washington Equal Pay and Opportunities act, the expected salary range for this Washington position is between $112,771 and $169,157.  In accordance with the Wage Transparency Omnibus Amendment Act, the expected salary range for this DC position is between $112,771 and $169,157. In accordance with Maryland’s Equal Pay for Equal Work-Wage Range Transparency Law, the expected salary range for this Baltimore position is between $102,095 and $153,143. In accordance with Illinois Equal Pay Act Transparency Notice, the expected salary range for this Illinois position is between $112,771 and $169,157.  In accordance with Massachusetts Frances Perkins Workplace Equity Act, the expected salary range for this Massachusetts position is between $117,697 and $176,545. In accordance with Minnesota Pay Transparency Law, the expected salary range for this Minnesota position is between $102,095 and $153,143. In accordance with New Jersey Senate Bill 2310, the expected salary range for this New Jersey position is between $117,697 and $176,545. In accordance with applicable laws and regulations, as of the date of this posting, a good faith estimate of the current scale range for this position in Cleveland, OH is $98,977 and $148,465 annually. Actual pay will be adjusted based on experience, geographic location, and other job-related factors as permitted by law. This position qualifies for the benefits below.  The application deadline for this position is December 31st, 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, 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.

Back to blog

Ads

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...

DISCLAIMER