OLAP SSIS SSRS Power BI Architect (Jobs in San Jose, CA)   Requirement id 86595 Job title Architect Job location in San Jose, CA Skills required Microsoft SQL, Data Modeling, OLAP, SSIS SSRS Power BI Open Date 18-Dec-2018 Close Date Job type Contract Duration 3 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Architect: Microsoft SQL, Data Modeling, OLAP, SSIS SSRS Power BI Job Description : Project Specific Tasks/Deliverables: Design high performing, scalable, Enterprise Data Warehouse, using both Kimball & Inmon methodologies in conjunction with utilization of a multi-platform, modern architecture approach. Collaborate with the stakeholders and build solutions that support their reporting, analytics, data exploration and data science needs. Participate in process improvement initiatives and in setting the best practice standards around Data Architecture, Metadata, Data Governance and Master Data Management. Architect data driven solutions that focus on fulfilling stakeholders needs: Translation of business needs into feasible and acceptable data-centric semantic layer designs Document and present relationships between business entities using Kimball, Inmon and other modern frameworks Participate in discussions to prioritize and balance technical and business needs of the conceptual and logical data Warehouse Architect logical data models, transforming the logical data models to physical models, then implementing/deploying the physical models in the respective systems: Architect and document 3NF integration layer (normalized) of the data warehouse Architect and document dimensional presentation layer (de-normalized) of the data warehouse Architect and document multi-dimensional cube structures and tabular structures Enhance and optimize existing models to ensure compliancy with best practices around master data management and a 3 layer architecture across technology platforms Design, develop, document and articulate architecture of the solutions and the enterprise data warehouse Evaluate reusability of current solutions for additional analysis, while maintaining integrity and confidentiality of information in accordance with a minimum viable product Provide guidance in the creation and refinement of Agile technical stories for data architecture and development. Load data models into systems and maintain / update the data models Participate in discussions to document database standards and procedures for the definition of reference architecture Train and provide knowledge transfers to developers on the team Required Deliverables: A complete solution-level and systems-level diagrams showing both the Public Safety and Justice (PSJ) design and non-PSJ design including all security considerations. A set of complete architectural blueprints of the PSJ and non-PSJ dimensional model showing dimension and fact tables and granularity down to the field-level. This model needs to apply highly scalable design so that nth number of data sources can be added into the design at any later stages with minor changes to the design or insignificant effects. A set of full documentation using the Kimball templates showing all the data mappings (for ETL) from the current source systems and future source systems (Tyler Odyssey Courts, Tri-Bridge Custody, SSA, ORS-RTS, Office of Supportive Housing) to the future data warehouse(s). A completed set of documentation detailing migration strategies from the current data warehouse to the future state. A completed physical model of the logical architectural designs in the previous list; all designs previously described deployed into the systems of a DEVELOPMENT environment. Outcomes of Deliverables: The deliverables expected from this contract are prerequisites for the implementation of a new Business Intelligence Solution and a planned migration route from the current to the new Business Intelligence Solution. The following are the business impact or outcome of these deliverables: Regulatory Compliance – provide a platform to continue delivery of mandatory reports for local, state, and fe   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 86595 while calling.   Other jobs in CA: Anaheim (4), Brea (3), Brisbane (2), Carlsbad (3), Concord (1), Culver City (1), Cupertino (5), Downtown Los Angeles (3), El Monte (3), El Segundo (1), Foothill Ranch (2), Irvine (1), La Jolla (2), Lake Forest (1), Larkspur Landing (1), Long Island (1), Los Angeles (27), Newport (1), Newport Beach (3), Orange (2), Orange County (7), Pasadena (1), Poway (5), Rancho Cordova (1), Redwood City (3), Sacrament (1), Sacramento (19), San Diego (87), San Francisco (24), San Jose (4), Simi Valley (1), South San Francisco (1), Westlake Village (2),    Microsoft SQL job openings in other states Jobs List Programmer Analyst 6 -132195 Create date: 28-Jun-2024 No of Submissions : 1 Start date : 07/29/2024 End Date : 1 Years from projected start date Submission deadline : 7/9 at 10am EST. Client Info : ORS Note: * Interview Process: Onsite interviews will be requested for all candidates. Candidates must be willing to come to the Lansing o.... (This job is for - Frameworks Jobs in MI Lansing Analyst - (in Lansing, MI)) AGE - Integration Engineer (737151) Create date: 16-May-2024 No of Submissions : 3 start date : 05/27/2024 End date : 06/30/2024 submission deadline : 05/20/2024 client info : AGE Description : All contractor roles at ODA are hybrid and require 2 days inthe office (Downtown Columbus Oh.... (This job is for - job Jobs in OH Columbus Engineer - (in Columbus, OH)) System Specialist - Level 3 - 57117 Create date: 13-May-2022 start date:5/24/2022 End date:05/24/2023 submission deadline:06/30/2022 client info : CT DCF Description: The Department of Children and Families depends on the core mission-critical Federally-reimbursed SACWIS (Statewide Automated Child Welfare Inform.... (This job is for - job Jobs in CT Hartford Specialist - (in Hartford, CT)) NJDOH ASAPM Back End/DB Developer (670612) Create date: 17-Jan-2022 Start Date :01/24/2022 End Date :09/30/2022 Submission Deadline: :01/20/2022 Client Info: DOH Note : * Agency Interview Type: Either iLinc Web Cam or In Person interview Description : The SQL Database Developer will be responsible for develo.... (This job is for - T SQL Views Jobs in NJ Trenton Developer - (in Trenton, NJ)) DOE Azure Database Developer (673573) Create date: 06-Jan-2022 start date:1/24/2022 End date:001/31/2023 submission deadline:01/14/2022 client info : DOE/TS/FN Note : * Agency Interview Type: Either Web Cam or In Person Description : Collaborate with internal customers, prospects, and stakeholders, understand, and translates bu.... (This job is for - Business IntelligenceT SQL Jobs in GA Atlanta Developer - (in Atlanta, GA))     (Architect: Microsoft SQL, Data Modeling, OLAP, SSIS SSRS Power BI in San Jose, CA)

Featured Jobs Budgeting Office Consultant (Jobs in Harrisburg, Pennsylvania) PMP Manager (Jobs in Atlanta, Georgia) Javascript Developer (Jobs in Tucker, Georgia) Architecture - - Specialist (Jobs in Raleigh, North Carolina) Typography Power Consultant (Jobs in Nashville, Tennessee) - Consultant (Jobs in Bismarck, North Dakota) SSIS JAVA Analyst (Jobs in Richmond, Virginia) TSOISPF Specialist (Jobs in Columbus, Ohio) Integration IT Specialist (Jobs in Columbus, Ohio) API CI Developer (Jobs in Richmond, Virginia)