Data Integration & Reporting Analyst Job at Schneider Downs & Co., Inc., Pittsburgh, PA

NU9id0NKdlkreFdqU3p6YmU1T1pmOElLZFE9PQ==
  • Schneider Downs & Co., Inc.
  • Pittsburgh, PA

Job Description

As a trusted advisor in the professional services industry,you know what matters most to clients: Big thinking with a personal focus. Youalso know what matters most to your own success, including: career growth,work-life flexibility, leadership that cares about your ability to succeed, theopportunity to give and receive one-on-one coaching and mentoring, as well aslearning opportunities that inspire professional development. Experience themall at Schneider Downs, where we've been providing accounting, tax, consulting, business advisory and wealth management services through our team of innovative thought leadersfor over 65 years. Start building a career with people motivated to help yousucceed-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'sour culture of care that makes us unique. Even as we grow, we work hard toretain this culture to continuously promote a positive, supportive workenvironment 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 andwinter breaks
- Parental leave, family care leave, and volunteertime
- 401(k) plans and profit sharing
- CPA exam bonus, education assistance program, andpet insurance


A PLACE WHERE INCLUSIVITY COUNTS
Schneider Downs is an Equal Opportunity Employer. Allqualified applicants will receive consideration for employment without regardto race, color, religion, sex, sexual orientation, gender identity, nationalorigin, disability, veteran status, and other protected characteristics. Webelieve a culture of care that celebrates diversity, equity, and inclusioncontributes to a better company, better client services, and a better world.

#LI-HYBRID

Job Tags

Summer holiday, Work at office, Flexible hours

Similar Jobs

Fresenius Medical Care

Dialysis Outpatient Registered Nurse - RN Job at Fresenius Medical Care

 ...This position will be for HHD, PD, and Transitional Care Unit. PURPOSE AND SCOPE: The professional registered nurse Outpatient RN CAP 2 may be an entry level designation into the Clinical Advancement Program (CAP) for new employees who meet the RN CAP 2 criteria... 

UnitedHealth Group

Remote RN Clinical Appeals Reviewer Job at UnitedHealth Group

UnitedHealth Group is seeking an experienced RN for a remote role focused on reviewing member and provider appeals. The position requires an active RN license and a minimum of 5 years of clinical experience in an acute hospital setting. Primary responsibilities include... 

BayCare Health System

RN - Registered Nurse - Outpatient Cardiac Rehab (PRN) Job at BayCare Health System

 ...BayCare is looking for its newest PRN Cardiac Rehab, RN in New Port Richey, FL. The PRN Cardiac Rehab Registered Nurse delivers care...  ..., a long-term acute care facility, home health services, outpatient centers and thousands of physicians. With the support of more than... 

Consolidated Business Services, Inc.

Junior Project Manager Job at Consolidated Business Services, Inc.

NYC company seeks Jr Project Manager/Assistant for their busy office. Responsibilities include...  ...(from multiple locations).THIS IS AN ENTRY LEVEL POSIITION. THE IDEAL CANDIDATE WILL HAVE...  ...EXPERIENCE. Full benefits and some remote work is possible.ApplyPlacing professionals... 

TJ Maxx

Retail Store Cleaning Associate Early Mornings Job at TJ Maxx

T.J. Maxx - 750 Butler Crossing, Butler Crossing, Butler, PA 16001, United States of America [Cleaning Technician] As a Cleaning Associate at T.J. Maxx, you'll: Maintain all organizational, cleanliness, and recovery standards for the sales floor; Participate in the maintenance...