Data Warehouse/Application Architect

TalentEdge | Rochester, NY

Posted Date 4/01/2024

Direct Hire

Beyond TalentEdge has a direct hire opportunity for an experienced Data Warehouse/Application Architect for a local college.

In this role you will be responsible for the design, development and management of a data warehouse environment used for analytics and reporting. You will also work in partnership with the Institutional Research and campus stakeholders to develop data models and intelligence delivery system.

A partial list of responsibilities/qualifications and skills are listed below (a full job description will be provided to interested/qualified candidates).

Key Responsibilities:

  • Engage with stakeholders to gather requirements for reporting and analytic solutions in support of campus initiatives.

  • Manage and coordinate the completion and change management of multiple projects at a time.

  • Create high level architecture and specifications.

  • Design/Develop and communicate appropriate data structures and architectures.

  • Develop and test programs using T-SQL and other ETL tools to support reporting and extracting solutions

  • Support business and technical staff

  • Maintain table structures, programs, scripts and documentation

Minimum Qualifications

  • Bachelor’s degree in Computer Science, Information Science or related field

  • 8-10 years of experience in BI data warehousing.

  • Advanced degree in related field a plus.

Desired Experiences/Skills (partial list):

  • Extensive architectural design experience for Business Data Warehouse and Analytics

  • Architecture and deployment experience with IBM BI & Analytical Tools, Oracle and Information Server products.

  • Experience implementing data governance principles

  • Work independently with customers to determine information technology status, desires, needs and cross-system issues on Highly sensitive and/or complex projects

  • Demonstrated knowledge of data warehousing/business intelligence best practices, methodologies, standards and architecture.

  • Proven full-cycle development of delivering BI projects

  • Experience with MS SQL Server BI technology stack (T-SQL, SSAS cubes, stored procedures)

  • Experience with contemporary BI Tools (i.e. Cognos 10.2.x, iDashboard)

  • Proficiency in Unix and Windows environments

  • Unix – Solaris, HP/UX, and/or Linux

  • Excellent written and verbal skills

"Beyond TalentEdge is an Equal Opportunity Employer. It is the policy off Beyond TalentEdge to provide equal opportunity in employment and conditions of employment to all individuals regardless of age, race, color, religious beliefs, national origin, sexual orientation, gender identity, sex, veteran or military status, disability, pregnancy-related condition, predisposing genetic characteristics, genetic information, marital status, familial status, prior arrest, domestic violence victim status, non-job related convictions, participation in lawful activities outside of our workplace, or any other status protected by law.”

Employment Type
Full Time

Share this job