BI OLTP OLAP Problem Solving Skills SQL Scripts Tableau Methodologies And Designs Str   Requirement id 87643 Job title Architect Job location in Roanoke, VA Skills required BI, OLTP, OLAP, Problem Solving Skills SQL Scripts Table Open Date 23-Jan-2019 Close Date Job type Contract Duration 6 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Architect: BI, OLTP, OLAP, Problem Solving Skills SQL Scripts Table Job Description : You will be responsible for ensuring availability of comprehensive, clean, and consumable data to meet ever-changing business needs around reporting and analytics. You would design and develop data models that aggregate disparate data sets so that data reporting and analytics can efficiently take place. Specifically, you will: Understand and translate business needs into analytical data models supporting long-term solutions Work with the BI Analysts & Data Architects to develop conceptual data models Create logical and physical data models using best practices to ensure high data quality and reduced redundancy Optimize and update logical and physical data models to support new and existing projects Maintain conceptual, logical and physical data models along with corresponding metadata Recommend opportunities for reuse of data models in new use cases Develop best practices for standard naming conventions and coding practices to ensure consistency of data models Lead and provide technical guidance for design and implementation of data warehouse and governance systems Ensure data usage is in line with privacy and security policies Perform reverse engineering of physical data models from databases and SQL scripts. Evaluate data models and physical databases for variances and discrepancies. Validate business data objects for accuracy and completeness. Establish standards and guidelines for developing data models Guide BI Analysts and Self-Developed BI community on platform limitations and capabilities Qualification: Bachelors Degree in related field or equivalent experience 10+ years of experience delivering business intelligence solutions involving in large complex data warehouse design, development and testing 10+ years of experience with OLTP and OLAP database models Experience in structuring the data in the most effective and efficient format for analytics and reporting Experience in designing data models that best represent the underlying business context Experience with data analytics providing actionable data driven decision making. Ability to create new or leverage existing analysis models and apply them to aligned program using business knowledge. Experience with Cloud Data Warehouses such as Snowflake Familiarity with business intelligence platforms such as Tableau or other BI tools Has strong presentation and collaboration skills and can communicate all aspects of the job requirements, including the creation of formal documentation Independent. Strong critical thinking, decision making, troubleshooting and problem-solving skills. Go-Getter. Possesses strong, planning, execution and multitasking skills and demonstrated ability to reprioritize accordingly. Must be able to manage quickly changing priorities while meeting deadlines. Must be knowledgeable in agile software development methodologies Able to express complex concepts effectively, both verbally and in writing to business partners. Comfortable interacting with stakeholders at all levels throughout the business.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 87643 while calling.   Other jobs in VA: Alexandria (1), Ashburn (3), Cardinal (1), Charllottesville (1), Charlottesville (6), Chesapeake (2), Chester (2), Dulles (3), Fredericksburg (1), Fremont (1), Glen Allen (2), Reston (4), Richmond (45), Roanoke (14), Virginia Beach (14),    BI job openings in other states Jobs List Certified Project Manager IV/Sr. -136881(REBID) Create date: 31-Oct-2024 No of Submissions : 1 Start date : 11/18/2024 End Date : 06/30/2025 Submission deadline : 11/4/2024 4:00:00 PM Client Info : ETF Note: * Interview Process: MS Teams * Duration of Contract: 6/30/2025, with potential for extension * Onsite or Remote: Candida.... (This job is for - BI Jobs in WI Madison Manager - (in Madison, WI)) NJDOE App Systems Analysis/Programming Mgr 3 (676882 ) Create date: 10-Mar-2022 Start Date :02/25/2022 End Date :06/30/2022 Submission Deadline: :03/15/2022 Client Info: DOE Note : * Agency Interview Type: iLinc Web Cam Interview Only Description: Note: Currently this position will be required to work ON_SITE. This.... (This job is for - BI Jobs in NJ Trenton Manager - (in Trenton, NJ)) Senior Manager, Marketing Analytics Create date: 20-Jan-2022 start date:2/28/2022 End date:01/27/2023 submission deadline:1/26/2022 4:00:00 PM Note: it is a Remote position. client info : DHS Description: • Builds analytic plans that heighten the visibility of omni channel opportunities that will.... (This job is for - BI Jobs in NY Albany Manager - (in Albany, NY)) BI Analyst - 4665 Create date: 24-Feb-2021 On-site/Remote: On-site Description: Responsibilities Are you Tech Terrific, an innovative thinker, and have great interpersonal skills? We have an 18-month project with our client in Albany, NY that requires a BI Analyst, Expert Day-to-Day Tasks include, but not limited to: Gather.... (This job is for - SSRS BI Reporting Jobs in NY Albany Analyst - (in Albany, NY)) PowerBI Developer - 69115 Create date: 04-Nov-2020 Note :Eventually they are looking for someone to relocate to Peachtree City, GA. It will be remote until further notice! Will be required to be onsite eventually. Job Description : Acts as a/an primary owner for written business requirements, design and technical specifications, from initial creation, through change management.... (This job is for - EDI BI Jobs in GA PEACHTREECITY Developer - (in Peachtree City, GA))    BI job openings in VA Jobs List VDOT Oracle HCM Technical/Functional REMOTE -703997 Create date: 15-Feb-2023 Start Date : 2/27/2023 End Date : 06/30/2023 Submission Deadline : 2/20/2023 Client Info : VDOT Note: * Remote Description : *local candidates strongly preferred *Candidates must be able to work the first two weeks, or more, ONSITE in Richmond.... (This job is for - BIHCM Jobs in VA Richmond TechLead - (in Richmond, VA)) ETL/BI Systems Analyst Create date: 10-Dec-2019 Responsibilities The Systems Analyst is responsible for the analysis of multiple, complex process flows and the design and development of multiple, complex application systems. The incumbent actively supports and complies with all Company corporate policies and procedures. Responsibilities Provides guidance to Systems Anal.... (This job is for - ETL BI SSIS Jobs in VA Manassasvi Analyst - (in Manassasvi, VA)) Test Engineer - Consultant - J-10-879-740 Create date: 26-Mar-2014 Job Description: Test engineer who has experience in building/testing a large scale data warehouse that aggregates data from a large number of data sources, strong data analysis skill and BI Report testing capability. This person should be dependable individual with a proven track record of strong results. The candidate should be able to devel.... (This job is for - BI Jobs in VA HERNDON Engineer - (in Herndon, VA)) Senior Data Architect - ITR Analytics - J-10-876-536 Create date: 13-Mar-2014 REQUIRED SKILLS: -BS degree in Computer Science or related field/equivalent experience -12+ years of IT experience including development of large scale, complex data reporting architectures -Demonstrated ability to architect and model mission critical BI, OLTP, OLAP, ETL, solutions leveraging multiple DBMS technologies (Relational, B.... (This job is for - BI OLTP Jobs in VA HERNDON Architect - (in Herndon, VA)) (Architect: BI, OLTP, OLAP, Problem Solving Skills SQL Scripts Table in Roanoke, VA)

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)