Data Warehouse Architecture ETL Development ETL Design And Documentation GUI OLAP   Requirement id 20637 Job title Developer Job location in Horsham, PA Skills required Gap Analysis, Data Structures, SQL Server DataBase, Data Warehouse Architecture ETL Developm Open Date 11-Sep-2014 Close Date Job type Contract Duration 6 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Developer: Gap Analysis, Data Structures, SQL Server DataBase, Data Warehouse Architecture ETL Developm Development and maintenance of various data subject area data models (e.g. Provider, Customer, Individual, Clinical, Claims) Defining relationships and touch points between data subject areas Requirements gathering sessions Requirements mapping and gap analysis Analyzing complex data structures Semantic transformation specifications Composition of accurate and complete definitions for entities and attributes Build, develop, and manage a SQL Server relational database using data warehousing best practices. Provide onsite development including responsibility for the day-to-day performance, maintenance, and monitoring of the Data Warehouse system and its technical interfaces. Design architecture, map business rules and processes into technical solutions. Designing and leading the development of production SQL and database changes as well as assistance with the design of efficient database and storage structures. Perform analysis, development, and evaluation of data mining in a data warehouse environment that includes data design, database architecture, metadata, and repository creation. Hands-on ETL development and Review ETL load jobs for consistency and quality. Provide ETL design, development and testing estimations based business requirements and research into data that is currently sourced. Design of views, data mart solutions , and cubes. Implement Data Management strategies which include validation of source data and the use of data in management reporting. Develop design specifications, unit test plans, and troubleshoot client issues. Work with a diverse project team with an emphasis on repeatable processes and technical documentation Perform hands-on design, development and testing within the ETL tool environment using a mixture of GUI driven tools and hands-on SQL Analyse, design and implement User Interface (reports and dashboards) Educate client management and business users on business value and capabilities of data warehousing and business intelligence Provide advice and guidance on data warehousing approaches and solutions, and use of data warehousing methodology Assist in identifying and prioritizing business information needs, and defining business benefit of data warehousing Assist in evaluating and selecting data warehousing tools for business intelligence, data population, data management, metadata management, and warehouse administration Responsible for supporting the architecture and design of the data warehouse, data marts and BI reports which will support various data initiatives Performs table and interface design, development of logical and physical data model/database, ETL processes, BI reporting/OLAP cubes/OLAP reporting, and population and tuning of databases/ETL processes/BI reports/queries while meeting business/user requirements   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 20637 while calling.   Other jobs in PA: Dauphin (1), Dauphin County (3), Downingtown (2), Glen Milla (1), Harribsurg (1), Harrisburg (47), Horsham (6), Malvern (2), Pennsylvania (13), Phila (2), Philadelphia (16), Pittsburgh (1), Radnor (2), Reading (1), Sharon (3), WAYNE (1), West Cheste (1), West Chester (33),    Gap Analysis job openings in other states Jobs List Child Support Modernization Readiness -325-24-420-027-NSP Create date: 03-Sep-2024 Start date : 1/1/2025 Submission deadline :10/18/2024 12:00 PM CT Client Info : Human Services, Department of Short Description: To assist ND in planning & managing a child support modernization project, to include: readiness activities, preparation of the fed. feasibility study, and writing the SOW for DDI of the n.... (This job is for - job Jobs in ND Bismarck Consultant - (in Bismarck, ND)) COM-IT Consultant 3 (ITC3) (706255) Create date: 13-Mar-2023 Start date :04/03/2023 End Date :06/30/2023 Submission deadline :03/15/2023 Client Info :COM Description : Requirement Description: The Ohio Department of Commerce Division is searching for a candidate for a highly experienced Senior Systems Architect. The qualified candidate will be tasked wi.... (This job is for - job Jobs in OH Columbus Consultant - (in Columbus, OH)) Bed Management System - 325-22-905-047 Create date: 23-Nov-2022 start date:6/19/2023 submission deadline:01/12/2023 12:00 PM, C.T. client info : Management & Budget, Office of Description: The STATE is soliciting proposals for a commercial-off-the-shelf (COTS) or Software-as-a-Service (SaaS) bed registry solution that c.... (This job is for - Reports Jobs in ND Bismarck Consultant - (in Bismarck, ND)) NJ OPD Project/Program Manager 3 (690169) Create date: 27-Oct-2022 Start date :10/03/2022 End Date :03/31/2023 Submission deadline :10/31/2022 Client Info :Office Of The Public Defender Description : Individuals with a mastery of project management skills, qualifications and experience with technologies, digitization, processes and workflows automation, optimi.... (This job is for - job Jobs in NJ Trenton Manager - (in Trenton, NJ)) IA-DHS-EP2-ERP Project Manager (693515) Create date: 20-Sep-2022 Start date :10/10/2022 End Date :06/30/2023 Submission deadline :9/23/2022 Client Info :DHS-IMHI: Department of Human Services Description : The Division of Information Technology (DOIT) provides adaptable, secure, and cost-effective technology services and solutions across the Department of He.... (This job is for - Planning Jobs in IA Ames Manager - (in Ames, IA))    Gap Analysis job openings in PA Jobs List Tableau Developer - 3241 Create date: 06-Dec-2017 **This is a replacement request. The person they chose was not the right fit. Not strong enough in Tableau or SQL with attendance issues. Would consider previous candidates but most be very strong in Tableau and SQL In Short: Design, build and run Tableau Dashboards. Develop documentation as required. Interpret business plans for automat.... (This job is for - Tableau Jobs in PA Radnor Developer - (in Radnor, PA)) BCHS SME1-368857 Create date: 29-Sep-2014 Description: Resource will perform business process analysis for the Bureau of Community Health Systems Required Skills: * Experience working as a Senior Business Analyst * Experience assessing current business processes and developing recommendations * Experience performing gap analysis * Experience .... (This job is for - job Jobs in PA Harrisburg Analyst - (in Harrisburg, PA)) Data Analyst - J-10-670-684 Create date: 09-May-2012 [Note: Start Date : 05/14/2012 End Date : 08/31/2012] Description: Required Skills: Bachelors Degree in Business or Management Information Systems 3-5 years of experience in a related field data analysis (including Data Collection & Analysis,mapping, gap analysis) activities. Must be able to in.... (This job is for - MS Office Jobs in PA PITTSBURGH Analyst - (in Pittsburgh, PA)) (Developer: Gap Analysis, Data Structures, SQL Server DataBase, Data Warehouse Architecture ETL Developm in Horsham, PA)

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)