Data Integration & Reporting Analyst

Schneider Downs•Pittsburgh, PA

1d•Hybrid

About The Position

As a trusted advisor in the professional services industry, you know what matters most to clients: Big thinking with a personal focus. You also know what matters most to your own success, including: career growth, work-life flexibility, leadership that cares about your ability to succeed, the opportunity to give and receive one-on-one coaching and mentoring, as well as learning opportunities that inspire professional development. Experience them all at Schneider Downs, where we’ve been providing accounting, tax, consulting, business advisory and wealth management services through our team of innovative thought leaders for over 65 years. Start building a career with people motivated to help you succeed—and enjoy more of what counts. As the Data Integration & Reporting Analyst, you will develop and maintain SQL-based data reporting solutions, support backend database troubleshooting, and assist in the buildout and optimization of the firm's data warehouse. This role requires a solid understanding of firm processes and how they are implemented in software systems, enabling effective data extraction and transformation for analytics and reporting. In this role, you will collaborate with cross-functional teams to align systems, processes, and reporting needs, supporting data integrity for business decision-making. You will also perform basic database administration (DBA) functions and supports software updates for on-premises databases. We understand the importance of work-life balance. That's why we've embraced a hybrid work model, allowing you to enjoy the flexibility of working from home as well as in the office.

Requirements

Bachelor’s degree in Computer Science, Information Systems, or related field
Minimum of three years of experience in SQL development, data integration and/or business analytics
Proficiency in SQL development for reporting, analytics, and data integration
Solid understanding of application backend databases (e.g., SQL Server, ETL tools)
Experience with data warehouse architecture, buildout, and maintenance
Ability to understand business processes and their mapping to software systems
Basic knowledge of Microsoft Fabric and Power BI
Experience with basic DBA functions (building and troubleshooting database instances, software updates for on-premise databases)
Familiarity with data governance, data integrity, and compliance standards
Excellent critical thinking and analytical skills
Effective communication and collaboration skills for working with cross-functional teams

Nice To Haves

Experience in a CPA firm or professional services environment
Exposure to reporting tools such as Power BI and SSRS
Experience with Lakehouse architecture
Familiarity with CI/CD practices for data pipelines
Experience with Python and Spark

Responsibilities

Develop SQL queries, stored procedures, and ETL/SSIS packages to support data reporting, analytics, and integration needs across the firm
Troubleshoot and optimize backend databases for performance, reliability, and data quality
Assist in the design, buildout, and maintenance of the data warehouse, including data modeling, integration, and reporting solutions
Perform basic DBA functions, such as building new database instances, troubleshooting current instances, and supporting software updates for on-premise databases
Understand firm processes and their implementation in software systems to facilitate effective data extraction and reporting (no documentation required)
Collaborate with cross-functional teams (IT, Finance, Operations, etc.) to gather requirements, align systems, and deliver reporting solutions that meet business needs
Apply critical thinking and problem-solving skills to analyze complex data issues and recommend effective solutions
Support data governance and integrity initiatives, ensuring compliance with internal standards and best practices