Current jobs related to Data Warehouse/Application Architect - Rochester, New York - St. John Fisher

  • Senior Voice Solutions Architect

    6 days ago

    Rochester, New York, United States OpTech Full time

    OpTech Voice Architect Job DescriptionWe are seeking a highly skilled Voice Architect to join our team at OpTech. As a Voice Architect, you will be responsible for designing and implementing complex voice solutions for our clients.Key Responsibilities:Design and implement voice solutions for multi-site VoIP networksManage and maintain complex voice...

  • Systems Architect

    4 weeks ago

    Rochester, New York, United States Soleo Communications Full time

    Systems ArchitectSoleo Communications is seeking a dedicated Systems Architect with a strong background in overseeing both hardware and cloud-based solutions. The successful candidate will play a pivotal role in diagnosing, developing, and sustaining our organization's systems and networks.Key Responsibilities: Diagnose and resolve hardware, software, and...

  • ThingWorx Platform Architect

    18 hours ago

    Rochester, New York, United States TEPHRA Full time

    Job Title: ThingWorx Solution ArchitectWe are seeking a highly skilled ThingWorx Solution Architect to join our team at TEPHRA. As a key member of our team, you will be responsible for designing and implementing analytics and IoT solutions for the Med Device sector using the PTC ThingWorx platform.Key Responsibilities:Develop expertise in PTC products and...

  • Cybersecurity Solutions Architect

    6 days ago

    Rochester, New York, United States VirtualVocations Full time

    Cybersecurity Solutions at VirtualVocations**Job Summary**VirtualVocations is seeking a Senior Cybersecurity Solutions Architect to join our team.**Key Responsibilities:*** Deploy, optimize, and showcase the capabilities of data processing tools* Engage with customers to understand and address their cybersecurity challenges* Develop use cases and lead...

  • Warehouse Worker/Cover Driver

    6 days ago

    Rochester, New York, United States UPS Full time

    Warehouse Worker Job DescriptionAs a Warehouse Worker at UPS, you will be responsible for a variety of tasks including loading and unloading, packing and unpacking, auditing, and general housekeeping. You will also be responsible for scanning orders and data entry into computerized inventory control systems.Key Responsibilities:Loading and unloading...

  • Chief Security Architect

    2 days ago

    Rochester, New York, United States Unlimited Technology Full time

    Job Title: Chief Security ArchitectWe are seeking a highly skilled Chief Security Architect to join our team at Unlimited Technology. As a key member of our security team, you will be responsible for providing technical leadership and strategy in the domain of physical and cyber security.Key Responsibilities:Establish security architectures and...

  • Warehouse Stock Control Specialist

    3 weeks ago

    Rochester, New York, United States Adecco Full time

    Job OverviewAdecco is seeking a Warehouse Stock Control Specialist to become part of a prominent manufacturer in the telecommunications sector. This role presents a fantastic opportunity to be part of a compact yet expanding organization that values a supportive culture and work environment aimed at retaining top talent in the industry.Position...

  • AI Solutions Architect

    1 week ago

    Rochester, New York, United States NetApp Full time

    Job SummaryThe Data-Centric Solution Specialist will be a senior technical sales executive who is integral to our customers' Digital Transformation journey. They will be excited by the unique value that NetApp Solutions can deliver against their business requirements to create world-class AI or ML development environments.Key ResponsibilitiesCombining...

  • AI Solutions Architect

    4 days ago

    Rochester, New York, United States NetApp Full time

    Job SummaryThe Data-Centric Solution Specialist will be a senior technical sales executive who is integral to our customers' Digital Transformation journey. They will be excited by the unique value that NetApp Solutions can deliver against their business requirements to create world-class AI or ML development environments.Key ResponsibilitiesCombining...

  • Warehouse Worker

    2 days ago

    Rochester, New York, United States Cascade Innovations Full time

    Job Opportunity: Warehouse WorkerWe are seeking a reliable and detail-oriented Warehouse Worker to join our team at Cascade Innovations. As a Warehouse Worker, you will be responsible for picking and checking the completeness of goods, ensuring accurate and efficient inventory management.What We Offer:Competitive hourly wage starting at €13.50Permanent...

  • IoT Solutions Architect

    4 weeks ago

    Rochester, New York, United States TEPHRA Full time

    Position Overview:We are seeking a skilled Solutions Architect specializing in the PTC ThingWorx platform. The ideal candidate will collaborate closely with clients to deliver innovative solutions.Key Responsibilities: Engage in development activities using PTC products. Possess domain expertise in pharmaceutical manufacturing. Create extraction and mashup...

  • Logistics - Warehouse Associate

    4 weeks ago

    Rochester, New York, United States Nesco Resource Full time

    Job Overview: Warehouse AssociatePosition Overview: Join a dynamic Temp-to-Perm role in the renewable energy industry with Nesco Resource, a forward-thinking organization focused on the innovation of hydrogen fuel cell systems that serve as alternatives to traditional batteries in electric-powered equipment and vehicles. As a Warehouse Associate, you will be...

  • Logistics Warehouse Specialist

    4 weeks ago

    Rochester, New York, United States Border States Full time

    Position Overview As a vital member of our team, you will contribute to the efficiency and effectiveness of our warehouse operations. This role involves managing incoming shipments, ensuring the integrity of materials, and maintaining organized inventory systems. Key Responsibilities Receive and inspect incoming shipments for quality and accuracy. Allocate...

  • Senior Software Architect

    1 week ago

    Rochester, New York, United States L3Harris Full time

    Job Title: Lead Software ArchitectJob Summary:L3Harris is seeking an experienced Lead Software Architect to lead the technical design, development of new functionality, and provide support for the Network simulation environment. This role will utilize project management skills to help plan out sprints for an Agile development. The candidate will be key in...

  • Radiology Data Management Specialist

    3 days ago

    Rochester, New York, United States Mayo Clinic Full time

    About Mayo ClinicMayo Clinic is a world-renowned healthcare organization that values innovation, diversity, and inclusion. As a leader in patient care, research, and education, we strive to create an environment that supports the growth and development of our employees.Job SummaryWe are seeking a highly skilled Radiology Data Management Specialist to join...

  • Cloud Security Architect

    1 week ago

    Rochester, New York, United States MKS Instruments Full time

    Job OverviewAs a Senior Cybersecurity Cloud Security Architect at MKS Instruments, you will play a pivotal role in shaping the security posture of our cloud-based systems. You will be responsible for developing and implementing cloud security strategies, architecting secure cloud solutions, and providing guidance to ensure that our cloud environments are...

  • Warehouse Delivery Associate

    1 week ago

    Rochester, New York, United States Compass Group, North America Full time

    Job SummaryWe are seeking a highly skilled and experienced Warehouse Delivery Associate to join our team at Compass Group, North America. As a key member of our operations team, you will be responsible for ensuring the safe and efficient receipt, storage, and delivery of products and supplies to our customers.Key Responsibilities:Withdraw merchandise and...

  • Data Engineer II

    7 days ago

    Rochester, New York, United States Paychex Full time

    About the RoleWe are seeking a highly skilled Data Engineer II to join our Paychex Data, Analytics, & Artificial Intelligence (DAAI) organization. As a key member of our team, you will be responsible for supporting department initiatives with hands-on actions combined with strong attention to detail.Key ResponsibilitiesAssist with DAAI owned data warehouse...

  • Lead Landscape Architect and Project Supervisor

    4 weeks ago

    Rochester, New York, United States Hilgartwilson Full time

    Position OverviewHilgartWilson is seeking a Lead Landscape Architect and Project Supervisor to enhance our dynamic team. Our group comprises licensed landscape architects and LEED-accredited professionals who adopt a comprehensive approach to each assignment.We excel in collaborating with architects, planners, and other stakeholders to select amenities,...

  • Warehouse Operations Specialist

    5 days ago

    Rochester, New York, United States Wegmans Food Markets Full time

    Job SummaryWe are seeking a highly motivated and detail-oriented individual to join our Warehouse Team as a Warehouse Operations Specialist. As a key member of our distribution team, you will play a critical role in ensuring the efficient and accurate processing of merchandise.Key ResponsibilitiesAccurately select and pack merchandise for shipment to our...

Data Warehouse/Application Architect

3 months ago

Rochester, New York, United States St. John Fisher Full time
Position Details

Posting Summary

Position Title
Data Warehouse/Application Architect

Overview
St.

John Fisher University is an independent, liberal arts institution that provides a transformative education to approximately 3,800 undergraduate, master's, and doctoral students each year.

Across its five Schools, Fisher offers nearly 40 majors in the humanities, social sciences, natural sciences, business, education, and nursing; 11 pre-professional programs; and master's and doctoral programs in business, nursing, education, pharmacy, and public health.

The University's residential campus boasts a robust living and learning community and a successful intercollegiate athletics program. Fisher is a community where all are welcome, regardless of religious or cultural background.

The University continues to honor its founders, the Congregation of St.

Basil, by embracing their motto, "Teach Me Goodness, Discipline, and Knowledge." We are located in Pittsford, N.Y., seven miles outside of the city of Rochester.

The campus is situated on 164 park-like acres-a beautiful setting for a warm, friendly campus community.

Job Responsibilities

The Position of Data Warehouse / Application Architect is responsible for the design, development and management of a data warehouse environment used for analytics and reporting.

The data warehouse team campus stakeholders to develop data models and intelligence delivery systems so the campus can achieve the aggressive goals of a wide range of strategic and tactical initiatives.

This individual is responsible for data warehousing, including requirements discovery, data mining and profiling, data model design, implementation, maintenance, training, and support.

The team operates in an agile mode with extensive collaborations with users across the campus.

Job Responsibilities include:
Engage with stakeholders to gather requirements for reporting and analytic solutions in support of campus initiatives.

Manages and coordinates the completion and change management of multiple projects at a time.

Create High level architecture, specifications to ensure feasibility, functionality, and integration.

Design, develop and communicate appropriate data structures and architectures including data vault, star schema and data mining models; ability to emphasize methodology, modeling, and governance, technologically and politically neutral, articulate, persuasive, and enthusiastic

Develop and test programs using

TSQL
and other

ETL
tools (e.g.,

SQL
Server Integration Services, PowerShell) to support reporting and extract solutions.

Support business and technical staff regarding the content and use of data warehouse objects.

Maintain table structures, programs, scripts, and documentation to ensure alignment with the data warehouse strategy and architecture.

Conceive and portray the big data picture: initiates, evaluates, and influences projects from the perspective of the entire organization.

Complete in-depth data modeling and database design with proficiency across all phases of data modeling, from conceptualization to database optimization with skills that extend from

SQL
development and to database administration.

Education / Experience
Bachelor's degree in computer science, information science or related field.

8-10 years of experience in BI data warehousing or related field with work focused on data modeling and data warehousing.

Advanced degree in related field a plus.

Competencies / Skills

Required Skills:
Extensive architectural design experience for Business Data Warehouse and Analytics.

Architecture and deployment experience with

IBM
BI & Analytical Tools, Oracle's Database, Microsoft's Server, and Information Server products.

Experience implementing data governance principles and utilizing commercial tools for data governance and stewardship.


Experience working independently with customers to determine information technology status, desires, needs and cross-system issues on projects of high sensitivity or complexity.

Project lead cross functional teams using project management techniques and skills.


Proven ability to provide the highest levels of interpersonal communications with sensitivity to and understanding of the demands of a higher education environment.

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


Proven track record of delivering BI projects through software development lifecycle including requirements gathering, design, development, analytics, measurement, implementation, and support.

Experience with Microsoft

SQL
Server BI technology stack, specifically T-
SQL,

SSAS
cubes, Stored Procedures, Self-service BI,

XMLA .

Knowledge of

ROLAP / MOLAP

technologies and dimensional modeling, including their applicability to various reporting problems.

Extensive knowledge of relational database design, logical data modeling, data warehousing, and relational database management systems preferably Oracle 21c or MS

SQL
Server

Experience with contemporary BI tools (
IBM
Cognos 11, Microsoft Reporting Services).

Significant training and experience in dimensional data modeling, data architecture, cube building, and

ETL
tools are required.

Includes experience designing and building type 1 and type 2 dimensions, aggregate tables, and materialized views.

Proficiency in working in Unix and Windows environments.

Proficiency in basic Database design concepts Unix - Solaris, HP/UX, and/or Linux.

Preferred Skills:
Experience in higher education and their associated data landscapes.

Substantive experience with Oracle databases,

SQL.

Experience with Banner Higher Education

ERP
systems preferred.

Strong communication and collaboration skills.

Strong Oracle

SQL
and PL/
SQL
programming.

Strong Microsoft

SQL/
TSQL, and PowerShell.

Unix Shell scripting.

3rd party software install/configuration.

Supervision of Employees
N/A

Work Environment
Well-lighted, well-ventilated, pleasant work area.

Equipment to be Used

Oracle

SQL
Developer

Microsoft

SQL
Server Management Studio and Azure Data Studio

Microsoft Visual Studio Code and Visual Studio 2019

IDERA
ER/Studio- Data Modeling

PowerShell scripting

Subversion Client

MS Office Suite (Excel, Word, Outlook, PowerPoint)

Postman ( REST

API
Investigations)

Work Hours
40-hour work week, 12 months a year

Special Conditions for Eligibility

EEO Statement
It is the policy of St.

John Fisher University to provide Equal Employment Opportunity to all employees and applicants for employment in accordance with the applicable federal, state, and local laws governing non-discrimination in employment in each locality in which the University has employees.


The University does not discriminate against applicants or employees in hiring, promotion, termination or the terms and conditions of employment on the basis of race, color, religion, gender, sex, perceived sex, gender identity, gender expression, the status of being transgender, sexual orientation, national origin, citizenship, age, disability, marital status, military status, veteran status, predisposing genetic, characteristics or genetic information, arrest or conviction record, status as a victim of domestic violence, or any other characteristic protected by law.


The Title IX Coordinator is the designated University official with primary responsibility for coordinating compliance with Title IX and related federal and state laws.

The Title IX Coordinator, Meg Flaherty, Ph.
D., can be reached by phone , email ), in-person in Campus Center 206, or outside of business hours by contacting the Office of Safety and Security

Work Location
3690 East Ave., Rochester, NY 14618

FLSA
Exempt

Salary / Hourly Range
k

Notes

The salary range for this role is set based on a variety of factors, including but not limited to internal equity, qualifications, experience, and education.

The above hiring range is one component of the University's competitive Total Rewards package which can be viewed

here

Posting Detail Information

Posting Number
S00597P

Desired Start Date
06/01/2024

Open Date

Open Until Filled

Special Instructions to Applicant

Supplemental Questions

Required fields are indicated with an asterisk (*).

Documents Needed to Apply

Required Documents

Resume

Cover Letter

Letter of Recommendation 1

Optional Documents

Transcripts

#J-18808-Ljbffr