DWH / EDW / BI / ETL Modeler / Architect / Developer / Analyst

Posted 7 Hours Ago
Be an Early Applicant
Des Moines, IA, USA
In-Office
Expert/Leader
Information Technology • Software
The Role
Develop and architect enterprise data warehouse and business intelligence solutions using Teradata, SQL Server, Oracle, and Ab Initio. Responsibilities include data modeling, dimensional and 3NF design, data mapping, data flow analysis, data mart development, BI architecture, SQL development and performance tuning, metadata management, requirements gathering, testing, implementation, and stakeholder collaboration. Banking-domain experience and complex EDW environment expertise are required.
Summary Generated by Built In
Company Description

We are looking for FTE candidates for a premier IT Consulting company, TATA Consultancy Services (www.tcs.com).

Job Description

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

Qualifications

#DWH / #EDW / #BI / #ETL #Modeler / #Architect / #Developer / #Analyst

Additional Information

Saviance Technologies is an EEO employer, employing over 500 professionals across more than 5 offices and 3 global delivery centers in the U.S, UK and India. We offer a very attractive benefits package which includes Medical, dental and vision insurance and compares well with the best in the industry. We deliver a full portfolio of services that includes Application Development & Management, Mobile Testing Services, Enterprise Software Solutions, Engineering Services, Full Spectrum of Microsoft Technology Solutions, Business Intelligence & Data Warehousing, Global Infrastructure as well as Professional Services. Our mission is to ‘To provide world class Staff Augmentation Services to our clients to enable them to win and grow by using our talent and experience in technological services, intuitive strategies and focused execution'.

For immediate consideration please send a Microsoft word copy of your resume to [email protected]. Please include the job title, authorization to work, interview/project availability and contact information. Call us now - we guarantee an interview, provided you have the right set of skills and attitude.

Skills Required

  • 9–11 years of total experience for Data Modeler roles
  • 10+ years of total experience for BI Solution Architect and Semantic Developer roles
  • 8+ years of experience for Data Analyst roles
  • 6–7 years of full-time data modeling experience
  • 6–7 years of data and BI architecture experience
  • 5 years of data analysis experience on data warehouse projects
  • 5+ years of strong Teradata technical experience
  • Expertise in 3NF and dimensional data modeling
  • Enterprise data warehouse design experience, preferably in banking
  • Teradata and Microsoft SQL Server implementation experience
  • Experience with data modeling metadata and data architecture
  • Hands-on Teradata physical implementation in large environments
  • Experience analyzing and tuning Teradata and SQL query performance
  • Experience with BI product stacks, BI reporting, and Ab Initio
  • Ability to design, integrate, test, and implement data warehousing solutions
  • Experience conducting BI blueprint studies and developing BI roadmaps
  • Experience with data mapping, data analysis, and data flow analysis
  • Ability to identify data sources and develop extraction and processing procedures
  • Experience documenting data elements, relationships, dependencies, and data flows
  • Experience developing data marts, fact and dimension tables, views, indexes, functions, and data structures
  • Working knowledge of Oracle and Microsoft SQL Server
  • Advanced SQL skills including joins, aggregations, subqueries, ranking functions, stored procedures, macros, views, and conditional expressions
  • Ability to collaborate with business analysts, project managers, ETL developers, QA, business users, and stakeholders
  • Experience defining reporting metrics and evaluating reporting capabilities
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: East Rutherford, NJ
149 Employees
Year Founded: 1999

What We Do

Saviance is a US Healthcare IT Service provider focusing on Patient Engagement with Innovative Products and Solutions like Patient Intake Tablet, iHealthConnect Wellness Portal, Mobile Applications, Actionable Analytics and ICD-10 Testing Services. Incorporated in 1999 in New Jersey, with over 15 years of excellent industry track record, Saviance offers services & solutions that enable enterprises to achieve critical objectives. Saviance is a Gold Category Corporate Member with Healthcare Information Management Systems Society (HIMSS), member of mHealth Alliance and Corporate member of NJ-HITEC. We are awarded by INC. 5000 as one of the fastest growing privately held companies in North America. Saviance is also ranked among the Fast 50 Asian American Businesses in the United States by USPAACC (US Pan Asian American Chamber of Commerce) and selected as a 2014 "Top Business"​ recipient by https://www.linkedin.com/redir/general-malware-page?url=DiversityBusiness%2ecom%2e A certified Minority Business Enterprise recognized by NMSDC, Saviance is also partner with leading global brands such as Microsoft, Amazon Web Services, Apple, Samsung and Red Hat.

Similar Jobs

John Deere Logo John Deere

Consultant

Artificial Intelligence • Cloud • Internet of Things • Machine Learning • Analytics • Industrial
Hybrid
Davenport, IA, USA
69000 Employees
78K-116K Annually

John Deere Logo John Deere

Engineer, Motor Grader Engine Application / Drivetrain

Artificial Intelligence • Cloud • Internet of Things • Machine Learning • Analytics • Industrial
Hybrid
Davenport, IA, USA
69000 Employees
68K-102K Annually

Lowe’s Logo Lowe’s

Full Time - Sales Associate - Tools - Opening

Consumer Web • eCommerce • Information Technology • Retail • Software • Analytics • App development
Hybrid
Coralville, IA, USA
300000 Employees

Lowe’s Logo Lowe’s

Full Time - Cashier - Day

Consumer Web • eCommerce • Information Technology • Retail • Software • Analytics • App development
Hybrid
Burlington, IA, USA
300000 Employees

Similar Companies Hiring

Revel Thumbnail
Aerospace • Hardware • Robotics • Software
Marina Del Rey, California
70 Employees
Blee Thumbnail
Artificial Intelligence • Marketing Tech • Software
New York, New York
33 Employees
RapidScale Thumbnail
Cloud • Information Technology • Consulting
Raleigh, NC
600 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account