ERwin SQL Oracle Database PostgreSQL Server Database Administration Reporting Servic   Requirement id 97535 Job title Developer Job location in Washington, DC Skills required Relational Database, ERwin, SQL Server, Oracle Database PostgreSQL Server Databa Open Date 10-Sep-2019 Close Date Job type Contract Duration 4 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Developer: Relational Database, ERwin, SQL Server, Oracle Database PostgreSQL Server Databa Description: The positions essential duties include the following: Serves as Subject Matter Expert in data warehouse concepts (Kimball, Inmon, star schema, snowflake schemas, and normalized and de-normalized data models) Leads the integration of the data warehouse with a modern, leading business intelligence platform Leads in designing and revising data model for data warehouse, and meta data and data dictionaries across the enterprise Develops and maintains a thorough knowledge of business processes supported by software systems/products Analyzes and documents as-is and to-be scenarios (processes, models, use cases, plans and solutions) Performed Source system analysis (SSA) to identify the source data that needs to be moved into the target tables Perform Data Analysis and Data validation by writing SQL queries Innovating new ways to standardize existing data processes and optimizing current workflows Creating custom data sets for use within our Analytics teams Create Data Mapping documents, data dictionaries and Interface Control Documents (ICDs) Works as part of Scrum Development Team and effectively participates in sprint planning, task estimates, task sequencing, task assignments, sprint reviews and retrospectives Meets and collaborates with business users on requirements and objectives Leads in reviewing and revising database designs and scripts on an ongoing basis Leads in documenting meta-data about Data Warehouse System according to computer industry standards and knowledge of database management systems Manages data loads, and security, storage and performance strategies and implementations Serves as technical team member in the development of business intelligence reports and analysis, providing mentoring, guidance and troubleshooting to analysis team members in solving complex reporting and analytical problems Meets and collaborates with business users on requirements and objectives Conducts complex analyses of strategic issues based on analysis of trends and interrelationships of key performance drivers documented in the data warehouse, especially the identification of test and control groups and comparison and evaluation of their relative performance Synthesizes research results and develops actionable strategic recommendations Communicates research results and strategic recommendations to nationwide and division strategy managers. Devises ER diagrams and identifies unique foreign keys, entities, attributes, relationships and business rules for data warehouse TYPE OF EXPERIENCE/YEARS OF EXPERIENCE: Knowledge of Relational Databases (8 years) Knowledge of Dimensional Model (Erwin, ER Studio) (8 years) SQL Server ,Oracle, PostgreSQL (10 years) SQL Server Analysis Services, Reporting Services and Integration Services (8 years) Requirements Gathering (8 years) SQL Programming (8 years) Business intelligence technologies and solutions (5 years) Data Profiling (5 years) Strong knowledge in Pentaho Data Integration Tool (5 years) Desired experience: Development experience working with MDM application like MDS. Tableau Reporting Server Vertica Database Experience with high performance big data concepts, such as Hadoop architectures and columnar databases such as Vertica Experience with solution delivery frameworks and tools such as Agile, Scrum, Kanban, JIRA   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 97535 while calling.   Other jobs in DC: Washington (6),    Relational Database job openings in other states Jobs List Database Architect - 61094 Create date: 11-Jul-2023 start date : 08/01/2023 End date : 12/31/2023 submission deadline : 08/22/2023 client info : Fulton County Note : * Position Location : On Site Description : Design strategies for Microsoft SQL Server and Oracle enterpris.... (This job is for - Architecture Jobs in GA Atlanta Architect - (in Atlanta, GA)) Data Warehouse Developer III - 115960 - SP Create date: 06-Apr-2023 start date : 05/08/2023 End date : 06/23/2023 submission deadline : 4/13/2023 at 4:00PM CST. client info : ETF Note : * Interview Process: 1-2 rounds via Microsoft Teams. Camera and audio required. * Duration: 6/30/2023, likely to extend. * Onsite or Remote? Open to 10.... (This job is for - Tableau Jobs in WI Madison Developer - (in Madison, WI)) ELECT - Data Analyst 2 (708020) Create date: 31-Mar-2023 start date : 04/17/2023 End date : 12/31/2023 submission deadline : 4/5/2023 client info : ELECT Note : * Hybrid Description : Virginia Department of Elections (ELECT) is seeking a Data Analyst. We are looking for people who .... (This job is for - job Jobs in VA Richmond Analyst - (in Richmond, VA)) ELECT - Data Analyst 2 (703660) Create date: 17-Feb-2023 start date : 02/15/2023 End date : 12/31/2023 submission deadline : 2/22/2023 client info : ELECT Note : * HYBRID - Must be willing to work AT LEAST 3 days/week ON-SITE. LOCAL CANDIDATES ONLY * Web Cam Interview Only Descripti.... (This job is for - Jobs in VA Richmond Analyst - (in Richmond, VA)) ELECT - Data Analyst 2 (703682) Create date: 17-Feb-2023 start date : 02/15/2023 End date : 12/31/2023 submission deadline : 2/22/2023 client info : ELECT Note : * HYBRID - Must be willing to work AT LEAST 3 days/week ON-SITE. LOCAL CANDIDATES ONLY * Web Cam Interview Only Descript.... (This job is for - Jobs in VA Richmond Analyst - (in Richmond, VA))    Relational Database job openings in DC Jobs List Data Architect/Data Modeler - J-10-925-895 Create date: 18-Aug-2014 Data Architect/Data Modeler 6+ months Contract Washington, DC Description: Responsibilities: * Determination of Project Discovery approaches and estimations in the data realm * Participation in the technical solution planning process * Reviewing/providing input into project schedules as they evolve. * Review.... (This job is for - job Jobs in DC BLUECROSSGROUPHOSP Modeler - (in BLUECROSS GROUP HOSP, DC)) (Developer: Relational Database, ERwin, SQL Server, Oracle Database PostgreSQL Server Databa in Washington, DC)

Featured Jobs QoS Analyst (Jobs in Dauphin County, Pennsylvania) Team Work Written Consultant (Jobs in Nashville, Tennessee) ASP.Net&C# Typescript MS SQL Server Specialist (Jobs in Raleigh, North Caro Project Manager Interpersonal Expert (Jobs in Raleigh, North Carolina) ASP.Net Typescript Web Specialist (Jobs in Raleigh, North Carolina) Tableau Consultant (Jobs in Dauphin County, Pennsylvania) Middleware C++ Expert (Jobs in Raleigh, North Carolina) BRD RTM SCRUM Analyst (Jobs in Richmond, Virginia) Documentation TechLead (Jobs in Madison, Wisconsin) ITSM Interpersonal Consultant (Jobs in Madison, Wisconsin)