Senior Data & Reporting Engineer (Power BI, SQL, Azure)

LEVI, RAY & SHOUP, INC; Chicago, Northern (IL, KY); Hybrid; USD 83,000 - 110,000; Full time

Job summary

Levi, Ray & Shoup, Inc. seeks a Sr. Data & Reporting Analyst for a hybrid onsite contract opportunity with a financial client in downtown Chicago, IL.

You will design, develop, and maintain SQL-based data solutions and Power BI reporting to support lending, private credit, and investor reporting initiatives. You will collaborate with global teams, modernize on-premises pipelines to Azure, and participate in Agile delivery using Azure DevOps.

Qualifications

• Bachelor's 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 with 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.

Responsibilities

• 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.

Skills

Consultative communicator

Agile collaboration

Stakeholder engagement

Distributed teams experience

Education

Bachelor's degree in CS/IS/Finance or related

Tools

Microsoft SQL Server

SSIS

Azure Data Factory

Power BI

Databricks

Snowflake

Azure DevOps

GitHub

Copilot / AI tools

Job description

Levi, Ray & Shoup, Inc. seeks a Sr. Data & Reporting Analyst for a hybrid onsite contract opportunity with a financial client in downtown Chicago, IL.

You will design, develop, and maintain SQL-based data solutions and Power BI reporting to support lending, private credit, and investor reporting initiatives. You will collaborate with global teams, modernize on-premises pipelines to Azure, and participate in Agile delivery using Azure DevOps.