Business Intelligence Developer

Lexicon; St. Louis (MO); Hybrid; USD 85,000 - 110,000; Full time

Benefits offered by this job

Health coverage

401(k) with company match

Flexible Spending Account (FSA/HSA)

Wellness programs

Job summary

Lexicon is seeking a Business Intelligence Developer to model complex data, prepare it for reporting, and develop Power BI reports to support the Data Science team in discovering insights. You will work on data mining, visualization, and statistical analysis to identify opportunities for the organization.

The ideal candidate has 3+ years in analytics/BI environments, strong SQL and Python skills, and experience with Power BI or Tableau.

Qualifications

• Bachelor's Degree in a quantitative field or related discipline.
• 3+ years of experience in Analytics/BI Development environments.
• Experience with Microsoft Fabric data analytics tools.
• Strong SQL and Python/PySpark data processing and ETL.
• Proficient in Power BI or Tableau for data visualization.

Responsibilities

• Model, transform, and prepare data for reporting and analysis across varied data sources.
• Build dashboards and visualizations to present actionable insights.
• Collaborate with analysts to define objectives and quantify impact; communicate results clearly.
• Handle data quality and integrity, processing and cleansing data as needed.
• Support the Data Science team with data mining, analysis, and reporting tasks.

Skills

Data modeling

SQL

Power BI

Python

ETL

Data visualization

Education

Bachelor's Degree in a quantitative discipline

Master's Degree is a plus

Tools

Microsoft Fabric

Power BI

Tableau

Python

Job description

About Lexicon and Cordell & Cordell: Cordell & Cordell is the nation's largest family law firm, supported by Lexicon, a professional legal services organization providing comprehensive operational and client support. Together, we are committed to a client-centered approach, delivering a high-quality experience at every stage of the client journey. We invest in people who are passionate about helping others, building trust, and contributing to the growth and success of the firm through meaningful client engagement.

About Lexicon and Cordell & Cordell: Cordell & Cordell is the nation's largest family law firm, supported by Lexicon, a professional legal services organization providing comprehensive operational and client support. Together, we are committed to a client-centered approach, delivering a high-quality experience at every stage of the client journey. We invest in people who are passionate about helping others, building trust, and contributing to the growth and success of the firm through meaningful client engagement.

Job Summary

The Business Intelligence (BI) Developer will be responsible for modeling complex data and problems, preparing data for reporting and analysis, and developing Power BI reports. This role supports the Data Science team's efforts to discover insights and identify opportunities through data mining, visualization, statistical analysis, and algorithmic techniques. The BI developer 

The ideal candidate will bring the following characteristics:

• Enjoys working for an organization that is growing.
• Able to adapt in a changing environment.
• Has a high aptitude and experience with data modeling, statistics, and data visualization.
• Has strong analytical and problem-solving skills.

Note: No C2C or 1099

Responsibilities

• Work with data of varying degrees of size and complexity, including both structured and unstructured data
• Transform data into actionable insights and recommendations. This includes processing, cleansing, and verifying the integrity of data used for analysis. Present clear and concise results.
• Collaborate with analysts to create dashboards and visualizations of processed data using business intelligence tools (e.g., Power BI) to draw inferences and conclusions, such as identifying trends and anomalies
• Process work requests in accordance with organizational priority. Work closely with stakeholders such as internal business teams and external clients to formulate quantitative and measurable objectives that have an impact on the business
• Professional, courteous attitude with peers, colleagues and customers
• Additional duties and projects as assigned.

Technical Qualifications

• Bachelor's Degree in any quantitative discipline such as Computer Science, Statistics, Mathematics, or Operational Research (Master's Degree is a plus)
• 3+ years of experience working in an Analytics / BI Development environment
• Experience with Microsoft Fabric suite of data analytics tools
• Highly proficient in data extraction and transformation (ETL) with SQL and Python / PySpark
• Robust experience with data transformation, BI, and data visualization tools like Power BI or Tableau
• Strong skills in data exploration, analysis, and visualization with languages such as Python
• Understanding of methods in statistical analysis (e.g., hypothesis testing, supervised machine learning methods, etc.)

Professional Qualifications

• Strong problem-solving skills, with experience breaking down a large problem into smaller, solvable components
• Ability to initiate and drive projects to completion
• Excellent written and verbal communication skills; with the ability to communicate the results of your work in meaningful ways
• Strong collaboration skills with both technical and non-technical groups across all levels of the organization
• Self-motivated, highly organized and able to prioritize and manage multiple projects simultaneously.
• Goes above and beyond on simple and complex requests
• Work location: Hybrid. This role is largely remote with necessary equipment provided but will require working in our Town & Country, MO office for meetings or training. Working in-office is also acceptable if preferred.
• Work Hours: Full-time, Monday through Friday.

Core Values

• Collaboration: At Lexicon, an emphasis is placed on working together seamlessly and leveraging the collective strengths of individuals within the organization. Employees promote communication, teamwork, and the sharing of ideas to achieve common goals and objectives.
• Responsiveness: Responsiveness measures our ability to react quickly and effectively to changes, demands, or challenges. A responsive Employee fulfills all obligations effectively and timely to our current and future clients, while maintaining effectiveness and staying aware of evolving business needs or circumstances.
• Culturally Positive: The "Courage to Ask Why" reflects our culture that encourages curiosity, understanding, critical thinking, and challenging the status quo. Employees professionally question existing processes, seek new viewpoints, and explore customer-focused solutions. Employees embrace and promote the values and beliefs of the organization and demonstrate respect for their colleagues, our clients, and the broader community. Employees create a culture that encourages "asking why" through professional curiosity, understanding, critical thinking, and challenging the status quo.
• Customer Service: Employees are committed to prioritize and exceed the expectations of current and future clients. Employees know and anticipate the needs of internal and external customers and act accordingly – providing high priority to customer satisfaction.

Acknowledgement

The above statements describe the job's essential responsibilities and requirements. They are not an exhaustive list of the duties that may be assigned to job incumbents.

Lexicon Services provides exceptional benefits and a collaborative working environment. As a member of our team, you'll enjoy:

• Industry-Leading Health Coverage: Access to top-tier health, dental, and vision insurance plans, ensuring you and your family stay healthy and protected.
• Financial Security: Enjoy peace of mind with life insurance, as well as both short-term and long-term disability coverage.
• An Investment in Your Future: Our competitive 401(k) plan with company match, helps you plan ahead, with opportunities to build and grow your retirement savings.
• Flexible Spending Options: Take advantage of flexible spending accounts (FSA/HSA) to cover out-of-pocket medical, dental, and childcare expenses with pre-tax dollars.
• And So Much More: From wellness programs to additional perks, we go above and beyond to create a workplace that values and supports you every step of the way.