Data Integration & Reporting Analyst

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.

WHAT YOU’LL DO
•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

WHAT YOU’LL NEED
Required:
•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
Preferred:
•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
Other:
•Excellent critical thinking and analytical skills
•Effective communication and collaboration skills for working with cross-functional teams

WHERE CULTURE COUNTS
At Schneider Downs, our culture is our identity. And it’s our culture of care that makes us unique. Even as we grow, we work hard to retain this culture to continuously promote a positive, supportive work environment through our core values: Care & Respect, Integrity, Be Great, Adaptive and We Not Me.

ENJOY MORE OF THE THINGS THAT MATTER MOST
- Competitive compensation
- Insurance, including health, dental, and vision, that begin on day one
- 20+ days of paid time off and 13 paid holidays
- Flex Fridays and office closures for summer and winter breaks
- Parental leave, family care leave, and volunteer time
- 401(k) plans and profit sharing
- CPA exam bonus, education assistance program, and pet insurance

A PLACE WHERE INCLUSIVITY COUNTS
Schneider Downs is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, and other protected characteristics. We believe a culture of care that celebrates diversity, equity, and inclusion contributes to a better company, better client services, and a better world.