Company Profile: |
Radiant combines years of experience building and leveraging relationships and partnerships in various industry verticals. We provide intellectual capital and proven methodologies through our business model. In order for our business practices to succeed in industry contexts, we have to be capable of focusing resources to provide efficient and economical systems of the highest quality products and services to our Clients.
Radiant has formed relationships with various clients around the world. We leverage Radiant's global capabilities to support our clients through dedicated, organized and client-focused teams. We deliver customized end-to-end solutions for business, so that the stakeholders benefit from our experience and dedication to maintain fiscal responsibility.
Radiant has sustained an impressive growth rate in both capability and profitability, and is now positioned to be one of the major contributors in various sectors such as Telecom, Pharma & Life Sciences, Transportation, E-Governance, Financial & Insurance, Information Technology, Manufacturing, Retail, Utilities and others. At Radiant, we are continually undergoing a transformation and reorientation in response to the rapidly evolving needs of our clients. Radiant has indepth experience of IT Services complemented with technical excellence and quality, to generate IT solutions for today and tomorrow. |
Job Description:
 |
Job Details:
Title: Data Warehouse (Data cube) Engineer
Position Type: 3 Months contract - Extendable
Location: Burlingame, CA
Must Have: Vertica Experience
Responsibilities:
- Understand data warehouse source data and its unique characteristics including frequency of updates, change data capture approaches, data quality issues, alternate sources, and original sources
- Communicate back to business partners where data sources need to evolve and appropriate work-arounds
- Ability to analyze business needs and translate into approach options with pros and cons of each approach
- Execute analysis through data visualization tools and custom web apps
- Build and deploy cubes using Vertica and Tableau in an efficient, scalable, and repeatable manner checking in code into source control systems
- Communication with non technical team. The person must be comfortable designing data cubes thinking across many dimensions. A business user needs to be able to share their request and the cube developer should work with data architect to get data if not already there and build data cubes. They should be able to communicate to business users how data cube is structured and the pros and cons of building additional dimensions or metrics
- The ability to form a long term data cube strategy from naming conventions, design consistency in metrics and cube structures so that new users can get up to speed quickly
- In depth understanding of the types of cube storage approaches and when to make appropriate trade offs
- Document cube design in an easy to understand manner for other users
- Prioritize correctly, keeping business value at the forefront of the decision making process
- Create production grade ETL scripts to populate datasets needed for cube building
- Build monitoring, QA, and maintenance processes that ensure the ongoing reliability of built end products
Requirements:
- Proven experience in designing and building data cubes from the ground up
- Deep experience in Business Intelligence cube design approaches
- Proven experience building ETL packages via shell scripting or PHP
- Exceptional data quality and triage analytical skills
- Strong conceptual and creative problem-solving skills; ability to work with considerable ambiguity; ability to learn new and complex concepts quickly
- Exceptional attention to detail; ensures deliverables are of high quality
- Demonstrated initiative and ability to work independently
- Ability to build strong, collaborative working relationships with broad cross section of business partners
- Strong oral and written presentation skills
- BS in Computer Science or related field
- 7+ years of total work experience, with at least 5 years in cube design and excellent command of SQL
|
