Job # 14-01393 029392 IT - Data Analytics Consultant - Senior Loc: HORSHAM, PA
8+ months contract C2C $55/hr ETL Architect/Developer with advanced ETL Architecture and data modeling skills to work as part of the Enterprise Data Management team and will be involved in ETL Architecture for Insurance Solutions. • 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 Analyze, design and implement User Interface (reports and dashboards) • 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* -- You received this message because you are subscribed to the Google Groups "java-core" group. To unsubscribe from this group and stop receiving emails from it, send an email to java-core+unsubscr...@googlegroups.com. To post to this group, send an email to java-core@googlegroups.com. Visit this group at http://groups.google.com/group/java-core. For more options, visit https://groups.google.com/d/optout.
