Sr. Data & Reporting Analyst

LRS has prospered for over 40 years because our corporate philosophy embraces honest ethical and hard-working people. If that describes your approach to IT consulting we need to talk! LRS Consulting Services is seeking a Sr. Data & Reporting Analyst for a hybrid onsite contract opportunity with our financial client in downtown Chicago IL!

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!

The Sr. Data & Reporting Analyst will:

• Design develop and maintain SQL-based data solutions supporting commercial lending private credit portfolio management and investor reporting initiatives.
• Develop and support reporting solutions using Power BI including paginated reports datasets and related analytics tools.
• Troubleshoot and resolve data reporting and integration issues across existing production environments.
• Build enhance and support ETL processes utilizing SQL Server SSIS Azure Data Factory or related technologies.
• Partner with business stakeholders to gather requirements and translate business needs into scalable data and reporting solutions.
• Support modernization efforts focused on migrating on-premises SQL Server SSIS and reporting environments to Azure-based platforms.
• Contribute to cloud data initiatives involving technologies such as Azure Databricks Snowflake and related data platforms.
• Collaborate with global technology teams throughout requirements gathering development testing deployment and production support activities.
• Participate in Agile delivery processes including backlog refinement sprint planning and work tracking within Azure DevOps.
• Develop documentation and promote best practices around data quality reporting and solution support.
• Stay current with emerging technologies including AI-assisted analytics development and productivity tools.
• Other duties as assigned.

Requirements:

• Bachelors degree in Computer Science Information Systems Finance or a related field
• 8 years of experience in data engineering business intelligence reporting analytics or related disciplines.
• Strong industry experience in the financial services domain specifically private credit commercial lending direct lending &/or asset management
• Consultative communicator with the ability to collaborate with business stakeholders in addition to technical teams.
• Strong experience with Microsoft SQL Server including advanced querying stored procedures performance tuning and data analysis.
• Experience developing and supporting ETL solutions using SSIS &/or Azure Data Factory.
• Experience with Power BI reporting and analytics solutions with focus on report development.
• Exposure to Azure-based data platforms and cloud modernization initiatives.
• Experience with Databricks Snowflake or similar modern data platforms is preferred.
• Ability to work support globally distributed teams managing multiple priorities in a fast-paced environment.
• Familiarity with Agile delivery methodologies Azure DevOps GitHub or related development and collaboration tools.
• Experience using AI-assisted development analytics or productivity tools such as Microsoft Copilot GitHub Copilot or similar technologies.
• Candidates must have permanent authorization to work in the USA for any employer
• Corp to Corp candidates will not be considered

The base range for this contract position is $60.00 - $80.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.