Manager, Data Integration and Reporting

2 weeks ago

Columbus, United States InsideHigherEd Full time

Screen reader users may encounter difficulty with this site. For assistance with applying, please contact hr-accessibleapplication@osu.edu. If you have questions while submitting an application, please review these frequently asked questions.

Current Employees and Students:If you are currently employed or enrolled as a student at The Ohio State University, please log in to Workday to use the internal application process. Welcome to The Ohio State University's career site. We invite you to apply to positions of interest. In order to ensure your application is complete, you must complete the following:
  • Ensure you have all necessary documents available when starting the application process. You can review the additional job description section on postings for documents that may be required.
  • Prior to submitting your application, please review and update (if necessary) the information in your candidate profile as it will transfer to your application.
Job Title:Manager, Data Integration and ReportingDepartment:ERIK | Office of Research Information Systems

The Manager, Data Integration and Reporting is responsible for providing services related to data analysis and reporting to all units and centers under the direction of the Senior Manager, Project Development & Data Reporting within the Enterprise for Research, Innovation and Knowledge (ERIK) Office of Research Information Systems (ORIS).

Oversees and leads the Data Integration and Reporting team charged with the analysis, design, development, and management of Business Intelligence solutions using SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Workday, Tableau, Excel, and other relevant tools.

Works with data across multiple systems, like SQL Server, AWS Redshift, Workday, Huron and other solutions for efficient data retrieval, analysis, processing and management of large and disparate datasets.

Manages a team responsible for data extraction, transformation, and loading (ETL) solutions for integrating and consuming data in any format from a variety of sources. Analyzes, designs, develops and manages database solutions incorporating stored procedures, functions, and database objects by utilizing complex T-SQL.

Work collaboratively in a small, cross-functional team and respond quickly to urgent, complex, or difficult requests. Manages expectations and ensures projects are on track to execute and deliver on strategic goals. Works closely with Senior Manager to identify goals for the team related to opportunities and enhancements to reporting that align with the ERIK Information Systems strategic goals.

Participates in the recruitment of new staff members to the team; Onboards and trains new employees; oversees the daily activities of all team members, including conducting performance evaluations and addressing employee relations concerns, in consultation with Human Resources and leaders within the unit.

Responsibilities:

40%: Oversees, leads, and participates in enterprise-wide data reporting and analytics projects to deliver actionable insights to support and improve research administration processes. Oversees and leads the Data Integration and Reporting team charged with the analysis, design, development, and management of Business Intelligence solutions.

30%: Manages a team responsible for data extraction, transformation, and loading (ETL) solutions for integrating and consuming data in any format from a variety of sources. Designs, develops and maintains data-driven Business Intelligence solutions made available through the ORIS Reporting Portal, Tableau dashboards, Workday and other relevant platforms and technologies.

10%: Designs, develops and maintains database solutions incorporating stored procedures, functions, and database objects by utilizing complex T-SQL and data extraction, transformation and loading jobs.

10% Participates in the recruitment of new staff members to the team; Onboards and trains new employees; oversees the daily activities of all team members, including conducting performance evaluations and addressing employee relations concerns, in consultation with Human Resources and leaders within the unit.

10%: Keeps updated on industry trends, emerging technologies, and best practices in data management, reporting and analytics; participates in training and performs administrative duties as requested.

Required Qualifications:

  • Bachelor's degree in computer & information science or an equivalent combination of education and experience.
  • Minimum of 5 years experience with MS SQL Server, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS), Tableau, Workday, Excel, SQL query execution, execution analysis & optimization, indexing strategies, REST based web services, and use of APIs and scripting techniques to automate processing.
  • At least 4 years of experience in working with enterprise data environments creating intuitive, interactive, and effective reports, dashboards, KPIs and visualizations.
  • Experience in data analysis, data relationships, data aggregation, and summarization with the ability to consolidate data from disparate systems.
  • Demonstrated proficiency in Workday reporting tools and modules, including Report Writer, Composite Reporting, and Advanced Reporting.
  • Must have excellent team management, communication (written and verbal) and interpersonal skills, problem-solving abilities, solid analytical/critical thinking skills and time management skills.
  • Supervisory experience.

Desired Qualifications:

  • Minimum of 8-12 years of relevant working experience. Experience with Cloud computing services like AWS, Azure, Data Lake and Warehouse tools, and be able to make recommendations where and how new systems can be deployed in a hybrid cloud environment. Possesses or is pursuing an AWS and/or Azure certification.
  • Experience in Database Administration (DBA) skills for managing MS SQL Server, Data Analysis, Modeling and Profiling.
  • Working knowledge of Data security standards, web accessibility standards, application workflow design, automated testing and Source control tools.
  • Knowledge of Research Administration based processes and systems related to Proposal and Award management, Responsible research practices, Compliance, Funding opportunity, etc.
  • Ability to effectively communicate complex technical concepts to non-technical stakeholders, build relationships with internal teams and external partners, and foster a collaborative work environment.

A resume or CV is required to be considered for this position. A cover letter is strongly preferred.

Function: Information Technology

Subfunction: Data Engineering

Career Level: M2

The target hiring rate for this position is $110,000.

Additional Information:Location:Mount Hall (0311)Position Type:RegularScheduled Hours:40Shift:First ShiftFinal candidates are subject to successful completion of a background check. A drug screen or physical may be required during the post offer process.

Thank you for your interest in positions at The Ohio State University and Wexner Medical Center. Once you have applied, the most updated information on the status of your application can be found by visiting the Candidate Home section of this site. Please view your submitted applications by logging in and reviewing your status. For answers to additional questions please review the frequently asked questions.

The Ohio State University is an equal opportunity employer.

All qualified applicants will receive consideration for employment without regard to age, ancestry, color, disability, ethnicity, gender identity or expression, genetic information, HIV/AIDS status, military status, national origin, race, religion, sex, gender, sexual orientation, pregnancy, protected veteran status, or any other basis under the law.

Applicants are encouraged to complete and submit the Equal Employment Identification form.

  • Data Integration Specialist

    4 weeks ago

    Columbus, Ohio, United States FST Logistics Full time

    About the Role:FST Logistics is seeking a skilled ETL Developer/Report Writer to join our team. As a key member of our data analytics team, you will be responsible for designing, developing, and maintaining ETL processes using Pentaho. You will also create insightful reports to support business operations and decision-making.Responsibilities:Design, develop,...

  • Data Integrations Product Manager

    4 weeks ago

    Columbus, Ohio, United States Cribl, Inc. Full time

    Cribl, Inc. is a serious company that doesn't take itself too seriously. We're looking for a collaborative, curious, and motivated Product Manager who is passionate about putting customers first. As a remote-first company, we believe in empowering our employees to do their best work, wherever they are. Our data engine is trusted by the biggest names in the...

  • Data Integration Specialist

    4 weeks ago

    Columbus, Ohio, United States The Christ Hospital Cardiovascular Associates Full time

    The Christ Hospital Cardiovascular Associates is seeking a skilled Data Integration Specialist to join our Data & Analytics team. This role will focus on the day-to-day maintenance and support of our Epic Cogito related systems, including Clarity, Caboodle, and other SQL databases. The ideal candidate will have experience with ETL processes, data mappings,...

  • Product Manager, Data Integrations Specialist

    4 weeks ago

    Columbus, Ohio, United States Cribl, Inc. Full time

    Empowering InnovationCribl, Inc. is a forward-thinking company that values creativity and collaboration. We're seeking a skilled Product Manager, Data Integrations to drive our product strategy and execution, ensuring seamless alignment with customer needs and company values. As a key member of our Product Management team, you'll work closely with...

  • Product Manager, Data Integrations Specialist

    4 weeks ago

    Columbus, Ohio, United States Cribl, Inc. Full time

    Cribl, Inc. is a serious company that doesn't take itself too seriously. We're looking for a collaborative, curious, and motivated Product Manager to join our team. As a remote-first company, we empower our employees to do their best work, wherever they are.Why You'll Love This RoleThe Cribl Product Management team sits at the center of the entire company,...

  • Finance Data Reporting Axiom Developer, Sr.

    6 months ago

    Columbus, United States Huntington National Bank Full time

    Description Finance Data Group within Huntington Finance & Controllership partners with Regulatory Reporting, FP&A and Balance Sheet Management groups supporting key functions such as monthly/quarterly external report filings and internal management reporting and analytics. The Senior Finance Data Reporting Axiom Developer has profound knowledge of...

  • IT Manager, Development and Integration

    4 weeks ago

    Columbus, Ohio, United States Nordson Full time

    Nordson's IT Manager, Development and IntegrationCollaboration drives Nordson's success as a market leader in Industrial Precision Solutions and Advanced Technology. Our employees thrive in an environment where we help each other reach our personal best and enable our company to continuously improve and grow, and our customers to succeed.Key...

  • Data and Analytics Manager

    4 weeks ago

    Columbus, Ohio, United States Orveon Full time

    About UsOrveon is a global beauty company that operates in over 40 countries, with a presence in major cities worldwide. Our headquarters are located in New York, and we have a diverse team of over 1,000 employees.Our MissionWe are committed to changing the way the world thinks about beauty. Our goal is to create a sustainable cultural impact by leveraging...

  • Data Integrity Specialist

    1 week ago

    Columbus, Ohio, United States IGS Energy Full time

    Job OverviewWe are seeking a highly motivated Data Integrity Specialist to join our Compressed Natural Gas (CNG) team at IGS Energy. This role will involve working closely with our CNG & Biogas division to ensure data integrity and compliance of our business.ResponsibilitiesData Audits and Assessments: Conduct regular audits and assessments of operations to...

  • Senior Oracle Data Integrator Specialist

    4 weeks ago

    Columbus, Ohio, United States Diverse Lynx Full time

    Job Title: Senior Oracle Data Integrator SpecialistJob Summary:We are seeking a highly skilled Senior Oracle Data Integrator Specialist to join our team at Diverse Lynx LLC. As an ODI expert with 10+ years of experience, you will be responsible for designing, developing, and implementing ETL mappings, workflows, and packages using Oracle Data Integrator...

  • Senior Finance Data Reporting Axiom Developer

    1 month ago

    Columbus, Ohio, United States Huntington National Bank Full time

    Job SummaryHuntington National Bank is seeking a highly skilled Senior Finance Data Reporting Axiom Developer to join our team. As a key member of our Finance Data Group, you will be responsible for leading the development of our Axiom application to ensure regulatory reporting is accurate and reliable.Key ResponsibilitiesCollaborate with regulatory partners...

  • Data Center Civil Engineering Manager

    1 month ago

    Columbus, Ohio, United States Amazon Data Services, Inc. Full time

    About the RoleWe are seeking a highly experienced Civil Engineering Manager to lead our Data Center design team at Amazon Web Services. As a key member of our Americas Design Engineering team, you will be responsible for leading a team of civil engineers in the design of data center critical infrastructure systems.Your primary focus will be on facilitating...

  • Integrated Marketing Manager

    1 month ago

    Columbus Grove, United States Consolidated Communications Enterprise Services, I Full time

    Major Duties Classification: Exempt / Non-Bargaining Position may be located remote. #LI-Remote Consolidated Communications is rapidly deploying world-class fiber internet service across a 20-plus state service area. From our first connection over 125 years ago, Consolidated is dedicated to turning technology into solutions, connecting people, and enriching...

  • Data Engineering Manager

    4 weeks ago

    Columbus, Ohio, United States FlightSafety International Full time

    About FlightSafety InternationalFlightSafety International is the world's premier professional aviation training company and supplier of flight simulators, visual systems and displays to commercial, government and military organizations.The company provides training for pilots, technicians and other aviation professionals from 167 countries and independent...

  • Senior Finance Data Reporting Axiom Developer

    2 weeks ago

    Columbus, Ohio, United States Huntington National Bank Full time

    Job Summary: We are seeking a highly skilled Senior Finance Data Reporting Axiom Developer to join our team at Huntington National Bank. This role will lead the development of our financial reporting application, ensuring compliance with regulatory requirements. The successful candidate will have in-depth knowledge of Axiom and experience with financial data...

  • Senior Data Integration Specialist

    1 month ago

    Columbus, Ohio, United States HexaQuEST Global, Inc. Full time

    Job Requirements:Candidate should have 12+ years of experience in ETL/ELT, finance domain, and data warehousing concepts.Candidate should have expertise in Abinitio GDE with different components, Unix-scripting, Oracle/PL SQL.Candidate should have a good understanding of Ab Initio EME and experience working in control-m scheduler.Candidate should be able to...

  • ASG Rochade Integration Specialist

    4 weeks ago

    Columbus, Ohio, United States Central Point Partners Full time

    Job Title: ASG Rochade Integration SpecialistJob Summary:We are seeking an experienced ASG Rochade Integration Specialist to join our team at Central Point Partners. The ideal candidate will have a minimum of 4 years of experience in implementing ASG Rochade data catalog, governance, and lineage capabilities.Key Responsibilities:Collaborate with stakeholders...

  • ASG Rochade Integration Specialist

    1 month ago

    Columbus, Ohio, United States RulesIQ LLC Full time

    Job Title: ASG Rochade Integration SpecialistLocation: HybridDuration: 6 months plusWe are seeking an experienced ASG Rochade Integration Specialist to join our team at RulesIQ LLC. The ideal candidate will have 4+ years of experience in implementing ASG Rochade data catalog, governance, and lineage capabilities.Key Responsibilities:Assess and refine...

  • Senior Data Engineering Manager

    4 weeks ago

    Columbus, Ohio, United States BJSS Full time

    About UsBJSS is an award-winning innovative tech consultancy that has been finding better, more sustainable ways to solve complex technology problems for some of the world's leading organizations since 1993.We bring together teams of creative experts with diverse backgrounds and experiences, who enjoy working and learning in our collaborative and open...

  • ASG Rochade Integration Engineer

    4 weeks ago

    Columbus, Ohio, United States Central Point Partners Full time

    Job Title: ASG Rochade Integration EngineerJob Summary: We are seeking an experienced ASG Rochade Integration Engineer to join our team at Central Point Partners. The successful candidate will have a minimum of 4 years of experience in implementing ASG Rochade data catalog, governance, and lineage capabilities.Key Responsibilities:Conduct interviews with...