Saviance is hiring a DWH / EDW / BI / ETL Modeler / Architect / Developer / Analyst

Data Modeler - 2 positions at Des Moines / Charlotte • Should have 9 - 11 years of total experience with 6-7 years of full time Data modeling experience • Should have knowledge of 3NF and Dimensional modeling and deal with their challenges • Sound knowledge in EDW, design experience of complex model in EDW in banking domain. • Teradata and MS SQL Server implementation knowledge for modeling • Experience in Metadata in context to data modeling and Data architecture • Hands on experience in Teradata physical implementation for large environments and analyzing performance issues to suggest alternative paths to achieve required throughput BI Solution Architect - 1 position at Des Moines / Charlotte • Should have 10+ years of total experience with 6-7 years of full time Data and BI architecture experience • Expertise in BI product stacks such as Teradata, SQL Server, BI Reporting , AbInitio and underlying architecture • Able to understand current architecture and recommend end-to-end BI and EDW architecture • Overall responsibility for architecture and design, development, integration testing and implementation of data warehousing solution • Conduct BI Blueprint study, assess readiness and recommend BI road map • Implement strong BI processes, architecture standards and industry best practices • Monitor industry trends and identify emerging technologies for adoption Data Analyst - 4 positions at Des Moines / Charlotte • Should have 8+ years’ experience with 5 years of experience as Data Analyst for Data Warehouse projects. • Should have hands on experience in Data Mapping, Data Analysis, and Data flow analysis in a complex data Warehouse project. • Hands on experience in Teradata SQL, and query analysis. • Be able to identify relevant data sources, design and implement software / procedures to extract and process data for EDW project. • Ability to interpret results and find insights in data. Review and analyze data from multiple internal and external sources • Analyze complex data systems and document data elements, data flow, relationships and dependencies for data • Partners with Business Analysts, Business users and other stakeholders to define, capture, discuss and communicate requirements in a structured form (e.g. User Stories, Test Cases, Data Flow Diagrams, and Acceptance Criteria etc.). Semantic Developer - 2 positions at Des Moines / Charlotte • 10+ years overall experience working on software development projects preferably with an emphasis on data warehouse / business intelligence projects • 5+ Year Strong Technical Skills in Teradata. Must have working knowledge of Oracle and MS SQL Server. • Extensively worked on development and implementation of data marts, data structures, functions, data warehouse fact & dimension tables, views, and indexes • Demonstrated skills in working with multiple groups to create data warehouse designs based on business and data requirements and conducting reviews • Demonstrated skills working with multiple groups to define key reporting metrics, identify current database sources, assess the status of existing reporting capabilities and work with teams on go forward solution • Demonstrated ability to lead meetings and effectively interact with Business Analysts, Project Managers, ETL developers, Quality Assurance and other end users regarding data needs • Excellent at writing complex SQL queries with Inner and Outer Joins, Aggregate Functions, Set Operators, Sub queries, System Calendar, Ranking Functions, Stored Procedures, Data Types, Logical and Conditional Expressions, Macros, Derived Tables, CASE expressions, Views, String Functions and Relational Concepts. • Demonstrated experience with SQL performance tuning