IT Business Analyst

Looking for more than just another assignment? Were looking for you! This isnt just another assignment, but a real opportunity and a challenge for the right person. LRS Consulting Services is seeking a BI Analyst for a 6-month contract opportunity with our client in Central Illinois! Local candidates will be given preference.

LRS Consulting Services has been delivering the highest quality consultants to our clients since 1979. Weve built a solid reputation for dealing with our clients and our consultants with honesty, integrity, and respect. We work hard every day to maintain that reputation, and were very interested in candidates who can help us. If youre that candidate, this opportunity is made for you! 

Job Summary

The Power BI Developer is responsible for designing, developing, and maintaining business intelligence solutions that enable data-driven decision-making. This role works with multiple data sources, including SharePoint, Excel, relational databases, and ODBC connections, to create reliable, scalable, and user-friendly Power BI reports and dashboards. The developer collaborates closely with business and IT stakeholders to translate reporting requirements into actionable insights.

Key Responsibilities

• Design, develop, and maintain interactive Power BI dashboards and reports
• Integrate data from SharePoint lists and libraries, Excel files, databases, and ODBC-connected data sources
• Create and optimize data models using Power Query, DAX, and relationships
• Develop ETL processes to cleanse, transform, and load data into Power BI datasets
• Ensure data accuracy, performance optimization, and best practices in report design
• Collaborate with business users to gather requirements and define KPIs
• Implement role-based security (RLS) and data governance standards
• Publish and manage reports in Power BI Service, including refresh schedules
• Document data sources, transformation logic, and report definitions
• Troubleshoot data quality, performance, and connectivity issues

Required Qualifications

• 4+ years of experience developing solutions using Power BI
• Strong experience working with SharePoint
• Advanced experience with Excel, including formulas, Power Query, and data modeling
• Experience with relational databases such as SQL Server or Oracle
• Experience using and managing ODBC connections
• Experience writing and optimizing SQL queries
• Strong analytical, problem-solving, and communication skills

Preferred Qualifications

• Microsoft Power BI certification (PL-300 or equivalent)
• Experience with Azure data services such as Azure SQL, Data Factory, or Synapse
• Knowledge of data warehousing concepts and dimensional modeling
• Experience with data governance, security, and performance tuning in Power BI
• Familiarity with Agile or Scrum methodologies

Key Skills

• Power BI development
• SharePoint data integration
• Excel data analysis
• SQL and database querying
• ODBC connectivity
• Data modeling
• Business intelligence reporting

- Candidate must be able to effectively communicate in English (written & verbal)
- Candidate must have permanent authorization to work in the USA for any employer

The base range for this contract position is $25.00 - $45.00 per hour, depending on experience. Our pay ranges are determined by role, level, and location. The range displayed on each job posting reflects the minimum and maximum target for new hires of this position across all US locations. Within the range, individual pay is determined by work location and additional factors, including job-related skills, experience, and relevant education or training.

LRS is an equal opportunity employer. Applicants for employment will receive consideration without unlawful discrimination based on race, color, religion, creed, national origin, sex, age, disability, marital status, gender identity, domestic partner status, sexual orientation, genetic information,  citizenship status or protected veteran status.

In some cases, LRS Consulting uses generative artificial intelligence (“AI”) in support of our hiring processes. LRS takes steps to ensure the use of AI does not result in discrimination based on protected class(es). AI may be used in the hiring process solely in support of the assessment of candidate qualifications. All decisions in the hiring process are made by LRS employees. If AI will be used in the hiring process for the position for which you are applying, you will be notified and will have the opportunity to opt out.