Senior Developer, Analytics and BI

We believe that service starts inside the organization and embrace a concept called "People First." At RH, do your best work in an inspiring space, enjoy a 50% product discount and receive opportunities for career advancement.
The Senior Informatica ETL Developer is a key, hands on role that will develop and deliver solutions that enable the collection, transformation and management of information from one or more sources. This role will be integral in designing and developing the future Enterprise Data Warehouse and Analytics.
The candidate is expected to be able to handle end-to-end Data Warehouse and Data Integration by taking into consideration the business cases, objectives and requirements. The technical domain of the position includes all aspects of the solution including data integration, data architecture, information delivery, infrastructure, testing, performance tuning for all components of the project.
The ideal candidate is a well-organized team player, and possesses exceptional time management skills to support multiple overlapping initiatives in a fast-paced, ever-changing environment.
Live Our Values: People, Quality, Service and Innovation
Design, develop and maintain Informatica workflows and mappings using the appropriate data load technique, including Push-Down Optimization, for performance optimization
Analyzes the impact of changes on existing ETL/ELT processes and systems. Assesses the compatibility with goals in all areas. Analyzes cost effectiveness and feasibility
Debug and tune data integration processes; analyze data warehouse architecture, normalized/de-normalized, star schemas and snowflakes, slowly changing dimensions, dimensional surrogate key handling, exception data processing, troubleshoot and recommend improvements and alternate methodologies
Participate in code reviews and ensure that all solutions are aligned to pre-defined architectural and requirement specifications
Provide L2 and L3 support of nightly ETL/ELT processes to ensure timely completion and availability of data in data warehouse for reporting use. Analyzes and resolves problems and provides technical assistance as is necessary. Implements corrective actions
May prepare or review product documentation, written instructions or technical literature for accuracy and completeness
Data Quality management
Maintenance of business rules associated with data integration
Participate in the fulfillment of ad-hoc data requests from internal business owners
Participate in design reviews and provide input to the design recommendations; provide input to information/data flow, understand and comply with Project Life Cycle Methodology in all planning steps
5+ years of BI ETL design/development/implementation experience with emphasis on Informatica PowerCenter
Can do attitude, with the ability to drive to success in both independent and group projects
Demonstrated experience with data integration architectures, data analysis and implementation
Demonstrated experience with ETL tools, including Informatica PowerCenter
Demonstrated experience with Enterprise level Data Warehousing
Demonstrated experience with SQL
Able to be agile in thinking and approach to solve the problem at hand.
Full Life Cycle Development
Demonstrated experience and ability to deliver results quickly in a fast-paced environment on multiple projects
Ability to work with other IT groups and business users
Experience with IBM Netezza data warehouse appliance a strong plus
Experience with cloud based data platform a plus
Retail experience a plus
Great benefits package with premier medical, dental and vision partners
Rewarding paid time-off plans, including vacation, sick time, personal days, company holidays and more
Substantial associate discount of 50% off regularly priced RH merchandise and 30% off sale items
Access to all RH Members Program benefits, including complimentary design services
High-value discounts with respected national vendors, partners and retailers
Generous Referral Bonus Program to reward associates for recruiting top talent

Don't Be Fooled

The fraudster will send a check to the victim who has accepted a job. The check can be for multiple reasons such as signing bonus, supplies, etc. The victim will be instructed to deposit the check and use the money for any of these reasons and then instructed to send the remaining funds to the fraudster. The check will bounce and the victim is left responsible.