Data Architect

Pace University – Valhalla, NY

The Data Architect will design and implement a secure, accessible, flexible, and easy to use reporting infrastructure. This infrastructure utilizes the Microsoft Business Intelligence stack and Blackboard Analytics as well as a myriad of data sources external and within the analytics and reporting Data Warehouse solution.


Position Duties
  • Works with the different functional areas, the Data Analyst, and IT software developers to design and implement a sustainable and robust Higher Education Data Warehouse and Data marts.
  • -Design and implement a reporting infrastructure that is flexible, easy to use, accessible, and secure. This infrastructure will be used to address the universitys needs to respond to routine, ad-hoc reports. -Maintain and develop data security access through determined standards, processes, and procedures.
  • Maintain and upgrade the technical architect and infrastructure to provide uninterrupted service to the campus, as well as additional duties as assigned.
  • Professional development in enhancing and maintaining the technical skills required for this position.
  • Work with end-users, executives, and other technical staff to identify and collect requirements.
  • Build and maintain ETL routines by following best practices and utilizing the Microsoft Business Intelligence solution (SSIS, SQL Server, SSAS) to Extract data from Banner and other sources.
  • Transform data to meet the requirements.
  • Load data into the Blackboard Analytics data warehouse and other data tools where applicable.
  • Develop and maintain Reports, OLAP cubes, and Dashboards.
  • Works closely with different functional areas, managers and directors to identify and collect requirements.
  • Performs other such duties as assigned from time to time.

  • Position Qualifications
  • Undergraduate degree in Information Systems, Computer Science, or related field experience required. Masters degree preferred.
  • -Minimum of four (4) years experience and extensive knowledge of Structured Query Language (SQL, TSQL, or PL/SQL). -Minimum of two (2) years experience using Microsoft Business Intelligence Software (SQL Server, Analysis Services (SSAS), Reporting Services (SSRS), and Integration Services (SSIS)). Multidimensional modeling and Tabular modeling with an understanding of MDX and DAX is a plus.
  • Strong data modeling and dimensional modeling skills are required.
  • Knowledge of Blackboard Analytics, Ellucian Banner and Blackboard Learn are highly desirable.
  • Knowledge of, reporting tools such as Pyramid Analytics, SAS, and Excel pivot tables.
  • -Strong analytical skills, business knowledge, technical skills, and people skills to define, and guide data strategy. -Excellent interpersonal and conflict-resolution skills
  • Excellent oral and written communications skills
  • Self-motivated with experience working with minimum supervision.

  • Work Hours

    M F 9:00 a.m. to 5:00 p.m. Other hours as required


    Posting Detail Information

    Posting Number S00543P
    Job Open Date 05/21/2019
    Job Close Date 06/21/2019
    Open Until Filled No
    Special Instructions to Applicant
    About the Institution

    Pace University has a proud history of preparing its diverse student body for a lifetime of professional success as a result of its unique program that combines rigorous academics and real-world experiences. Pace is ranked the #1 private, four-year college in the nation for upward economic mobility by Harvard Universitys Opportunity Insights, evidence of the transformative education the University provides.

    From its beginnings as an accounting school in 1906, Pace has grown to three campuses, enrolling 13,000 students in bachelors, masters, and doctoral programs in more than 150 majors and programs, across a range of disciplines: arts, sciences, business, health care, technology, law, education, and more. The university also has one of the most competitive performing arts programs in the country. Pace has a signature, newly renovated campus in New York City, located in the heart of vibrant Lower Manhattan, next to Wall Street and City Hall, and two campuses in Westchester County, New York: a 200-acre picturesque Pleasantville Campus and a Law School in White Plains.


    AA/EEO Statement

    Pace University is an Equal Opportunity, Affirmative Action employer. Minorities, women, veterans and individuals with disabilities are encouraged to apply.


    Benefits Offered http://www.pace.edu/human-resources/compensation-benefits/prospective-full-time-employee

    Pace University - 26 days ago - save job - original job

    All Jobs in Valhalla, NY

    • Chief Architect

      Lynk Manhattan, NY

      View Job
    • Software Architect Sr

      PNC Financial Services Group New York, NY

      View Job
    • Software Architect Sr

      PNC Financial Services Group New York, NY

      View Job
    • Robotics & Cognitive Architect

      Deloitte New York, NY

      View Job
    • UI & UX Digital Services Lead

      Pfizer New York, NY

      View Job
    • Managed Services & Products Senior Solution Architect

      Deloitte New York, NY

      View Job
    • Associate Project Manager

      New York City FIRE DEPARTMENT Queens, NY

      View Job
    • AVP, IAM Architecture Engineer

      Synchrony Stamford, CT

      View Job
    • Expert Solution Engineer & Architect

      Swiss Re Armonk, NY

      View Job
    • Lead Data Engineer

      CleanChoice Energy New York, NY

      View Job
    • IT Infrastructure Lead

      Mirador, LLC Darien, CT

      View Job

    Featured Articles

    SAP TSW Online Training For Learning Monitorizing

    29 April 2016

    SAP TSW stands for SAP Trader’s and Scheduler’s Workbench. It is useful for an organization as it helps in monitoring the current and future supply chain activities, including all inventory, trading and scheduled movements. It takes the responsibility to plan and execute efficiently the supply c

    read more..

    Tips and Importance of Networking as an International Students in the US

    26 April 2019

    “Networking has been cited as the number one unwritten rule of success in business. Who you know really impacts what you know.” This famous line by Sallie Krawcheck, in simple words, explains what importance Networking carries along with it. It an important factor to help you fetch a job afte

    read more..

    Why Can’t I Find a Job? – Reasons of Unemployment

    24 August 2018

    If you’re asking yourself “why can’t I find a job?” question despite being perfectly qualified and determined in your job search, it’s time to sit back and introspect. Below are some of the reasons that might lead you to a dead end in your w

    read more..

    President Trump’s “Merit-Based Immigration” System for H-1B and L-1 Visas could benefit Indians

    03 March 2017

    After taking the strong step on the ban of travel to the US by citizens from seven Muslim countries as an executive order; now Mr. Trump softens stand on immigration. US President Donald Trump called for a “merit-based i

    read more..

    Thanks For Your Feedback

    Attach A Resume First