IT Business Analyst

Job Description

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

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. Please contact with any questions.