About Schneider Downs & Co.
Sourced by ZipRecruiter
Industry
Accounting services
Company size
501 - 1,000 Employees
Headquarters location
Pittsburgh, PA, US
Year founded
1956
Other
Posted yesterday
Job description
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
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
schneiderdowns.com
Most Popular Jobs Similar to Data Integration Analyst
data integration specialist
data integration developer
integration analyst
senior data integration developer
business integration analyst
data systems analyst
systems integration analyst
data migration consultant
data quality analyst
technical data analyst
Other Helpful Pages Related To Data Integration & Reporting Analyst
Power Bi Data Analyst Salaries
Frequently asked questions
Q: What skills or qualities help someone succeed as a Data Integration Analyst?
A: To succeed as a Data Integration Analyst, key technical skills include proficiency in data integration tools such as ETL (Extract, Transform, Load) software, data warehousing platforms, and programming languages like Python, Java, or SQL. Additionally, strong analytical and problem-solving skills, as well as attention to detail, are essential for identifying and resolving data integration issues. Effective communication and collaboration skills, along with adaptability and a willingness to learn, also contribute to success in this role, enabling Data Integration Analysts to effectively work with stakeholders and drive business outcomes.
Q: What is the career path for a Data Integration Analyst?
A: A Data Integration Analyst's typical career progression involves starting as a Junior Data Analyst or Data Integration Specialist, where they focus on data migration, data quality, and integration tool setup. As they gain experience, they can move into mid-level roles such as Data Integration Lead or Senior Data Analyst, where they oversee data integration projects, develop data governance policies, and collaborate with stakeholders to drive business insights. Ultimately, senior Data Integration Architects or Data Management Directors can leverage their expertise to design and implement enterprise-wide data integration strategies, driving business growth and innovation.
