Data Warehouse Architect
5 days ago
Description: Needs to be able to be onsite 3 days a week. 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. • 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 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 Skills: Sql, Data, Data modeling, Data warehouse, Data analysis, Data architecture, Modeling, Etl, Data modelers, Data model, Tableau Top Skills Details: Sql,Data,Data modeling,Data warehouse,Data analysis,Data architecture,Modeling Additional Skills & Qualifications: 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 2019+ • 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 co Experience Level: Intermediate Level About TEKsystems: We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company. The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
-
Data Architect
4 weeks ago
Rochester, United States Novocure Full timeDescription:JOB SUMMARY: The Data Architect will be a member of Novocure's corporate analytics & data strategy team, participating in designing, architecting, and building the foundation for Business Intelligence activities for broad corporate initiatives. This role will provide the technical and analytical capabilities necessary to support Novocure's...
-
Data Warehouse/Application Architect
2 weeks ago
Rochester, New York, United States St. John Fisher Full timePosition Details Posting Summary Position TitleData Warehouse/Application Architect OverviewSt. 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,...
-
Lead Data Architect
1 month ago
Rochester, New York, United States Randstad USA Full timejob summary: General Purpose Architects, designs, develops, implements, and supports various components for the enterprise data warehouse and associated data sources. Leads efforts to build and maintain enterprise data systems, ensure high quality and integrity of data, and drive data initiatives that enable business objectives. Mentors staff, demonstrates...
-
Rochester, United States Tanson Corp Full timeJob DescriptionJob DescriptionDuties: This is a contract to hire posting with a max contract time of six months. We are looking for a Data Architect to work with the Cancer Center unit's data warehouse migration to GCP. We, also, have a research section need for Data Architect skills to assist on section level projects. This person will work in a team...
-
Data Integration Architect
4 weeks ago
Rochester, United States Talent Software Services Full timeData Integration ArchitectJob Summary: Talent Software Services is in search of a Data Integration Architect for a contract-to-hire position that can be worked 100% remotely. Position Summary: The client is seeking a Senior Data Solutions Architect to collaborate with business partners, transforming requirements and trends into effective data solutions and...
-
Data Integration Architect
4 weeks ago
Rochester, United States TALENT Software Services Full timeData Integration ArchitectJob Summary: Talent Software Services is in search of a Data Integration Architect for a contract-to-hire position that can be worked 100% remotely. Position Summary: The client is seeking a Senior Data Solutions Architect to collaborate with business partners, transforming requirements and trends into effective data solutions and...
-
Data Integration Architect
4 weeks ago
Rochester, United States TALENT Software Services Full timeData Integration ArchitectJob Summary: Talent Software Services is in search of a Data Integration Architect for a contract-to-hire position that can be worked 100% remotely. Position Summary: The client is seeking a Senior Data Solutions Architect to collaborate with business partners, transforming requirements and trends into effective data solutions and...
-
Data Integration Architect 2
1 month ago
Rochester, United States ICONMA Full timeOur Insurance client is looking for Data Integration Architect in Rochester, NY who will be able to designs the way to link data files, stores and repositories together to deliver data as a strategic enterprise asset. Description: As such, they are responsible for the Data Integration Architecture across master, transactional, operational, reference,...
-
Lead Data Architect
2 months ago
Rochester, United States Damco Solutions Full timeLooking for a very solid communicator wanting to take a leadership role Mid-level experience level of 7+ years experience Knowledge of multiple areas within healthcare systems required Responsibilities GENERAL PURPOSE: rchitects, designs, develops, implements, and supports various components for the enterprise data warehouse and associated data sources....
-
Lead Data Architect
2 weeks ago
Rochester, United States Damco Solutions Full timeLooking for a very solid communicator wanting to take a leadership role Mid-level experience level of 7+ years experience Knowledge of multiple areas within healthcare systems required Responsibilities GENERAL PURPOSE: rchitects, designs, develops, implements, and supports various components for the enterprise data warehouse and associated data sources....
-
Data Solutions Architect
1 month ago
Rochester, United States TEKsystems Full timeDescription: Excellus is looking for a Data Solution Architect to join their team on a long term basis. Within their IT and Data organizations, Excellus is going through a significant data transformation and there are multiple projects that they need support on. At a high level, there are some very high priority projects where data is acquired from a...
-
Data Solutions Architect I/II/III
3 weeks ago
Rochester, New York, United States Univera Healthcare Full timeJob Description: Summary:The Data Solution Architect provides leadership, direction, and planning in support of the goals and objectives of the division, with a primary focus on data design and implementation of analytic solutions across the entire analytics and data ecosystem. The Architect is at the forefront of strategic projects, key initiatives, and has...
-
GIS Architect
1 week ago
Rochester, United States Converge Technology Solutions Corp. Full timeGIS Database ArchitectStates 5 months for yearly budget purposes. Will extend well into 2025.Preferred Hybrid (1-2 days a week at office) Telework is possible for the right candidateResponsibilities: We are seeking a skilled GIS Database Architect to join our team. As a GIS Database Architect, you will be responsible for designing, implementing, and...
-
Data Engineer
2 weeks ago
Rochester, Michigan, United States OneStream Software Full timeData Engineer Remote, USA OneStream Software LLCBenefits Offered Vision, Medical, Life, Dental, 401K Compensation Range $97, $125, Range applies to US candidates only) + Benefits/Variable Comp/Equity - Range may vary based on experience Employment Type Full-TimeABOUT THE JOBAs a Data Engineer, you will be responsible for designing, developing, documenting,...
-
Network Architect
3 weeks ago
Rochester, United States Select Source International Pvt Ltd Full timeJob Title: Network Architect Location : Rochester hills,MI 48309 Duration :6 + Months Pay :$65/hr on w2 Job Description: Interpret business requirements into technical network solutions framework. Provide technology roadmaps governed by strategic direction, business requirements as well as resourcing and financial constraints. Liaise with enterprise,...
-
Network Architect
2 weeks ago
Rochester, United States InfiCare Technologies Full timeJob DescriptionJob DescriptionJob Title: Network Architect Assignment Length: X MonthsLocation: Rochester hills, MI XXXXX Shift: X AM X PM ESTPay rate - XXXXX/hr. on WXGeneral summary: Interpret business requirements into technical network solutions framework. Provide technology roadmaps governed by strategic direction, business requirements as well as...
-
Network Architect
2 weeks ago
Rochester, United States InfiCare Technologies Full timeJob DescriptionJob DescriptionJob Title: Network Architect Assignment Length: 6 MonthsLocation: Rochester hills, MI 48309 Shift: 7 AM 4 PM ESTPay rate - $64/hr. on W2General summary: Interpret business requirements into technical network solutions framework. Provide technology roadmaps governed by strategic direction, business requirements as well as...
-
Network Architect
2 weeks ago
Rochester, United States InfiCare Technologies Full timeJob DescriptionJob DescriptionJob Title: Network Architect Assignment Length: X MonthsLocation: Rochester hills, MI XXXXX Shift: X AM X PM ESTPay rate - XXXXX/hr. on WXGeneral summary: Interpret business requirements into technical network solutions framework. Provide technology roadmaps governed by strategic direction, business requirements as well as...
-
118 Warehouse
1 month ago
Rochester, United States FIFCO USA Full timeJOB SUMMARY As a Forklift Operator on our warehouse team, you will be responsible for the safe movement of materials and products in multiple onsite warehouses and one offsite warehouse. To track inventory movements throughout your shift, you will use a handheld scanner and work directly with warehouse leadership to ensure accuracy and that customers’...
-
Network Architect
3 weeks ago
Rochester Hills, United States A-Line Staffing Solutions Full timeTitle: Network Architect Location: Rochester Hills, MI Schedule: Mon – Fri, 7:00 AM – 4:00 PM EST Note: This role is NOT open to C2C or 3rd party candidates The Network Architect will be responsible for interpreting business requirements into technical network solution frameworks. They will provide technology roadmaps governed by strategic direction...
