• TIAA
  • $76,860.00 -114,210.00/year*
  • Arlington , VT
  • Information Technology
  • Full-Time
  • 1366 Berwal Rd

Nuveen, the investment manager of TIAA, offers a comprehensive range of outcome-focused investment solutions designed to secure the long-term financial goals of institutional and individual investors. Its affiliates offer deep expertise across a comprehensive range of traditional and alternative investments through a wide array of vehicles and customized strategies.

Lead Data Warehouse Architect
United States, North Carolina, Charlotte

Technology

Nuveen

Apr 25, 2019 Post Date
Share this Job
Join our Talent Network
COMPANY OVERVIEW:
Nuveen, the investment manager of TIAA, offers a comprehensive range of outcome-focused investment solutions designed to secure the long-term financial goals of institutional and individual investors. Its affiliates offer deep expertise across a comprehensive range of traditional and alternative investments through a wide array of vehicles and customized strategies.
POSITION SUMMARY:
The Senior Data Warehouse Architect is responsible for the successful delivery of business intelligence information to the entire organization and is experienced in BI report development and implementations, database design, data architecture and data warehousing. The ideal candidate will also have exposure to cloud computing data warehousing tools and other large scale data constructs.
KEY RESPONSIBILITIES AND DUTIES:
Responsibilities:
* Translate business requirements into an appropriate data model, develop ETLs, and validate results with business representatives.
* Support implemented BI solutions by: monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues.
* Oversee the Creation, maintenance and execution of detailed test cases and plans for all developed work product.
* Author and maintain detailed technical design and specification documentation.
* Provide input to refine business and functional requirements.
* Collaborate with both technical and non-technical professionals to develop standards and implement best practices across the team and be able to work in an agile environment
* Assist with hybrid cloud deployment and contribute to best practices across the team
QUALIFICATIONS:
Required Skills:
* Minimum of a Bachelor's degree.
* 3 or more years of experience with Oracle V12.
* 3 or more years of ETL development experience.
* 3 or more years of experience with creating star schema data models.
* 3 or more years of experience in a complex data warehouse environment.
* 3 or more years of experience in relational and multi-dimensional data modeling, and the use of data modeling tools.
Desired Skills:
* Experience with Datastage or SSIS
* Performing ETLs and validating results with business representatives
* Ability to collaborate on a team with infrastructure, BI report development and business analyst resources, and clearly communicate solutions to both technical and non-technical team members
* Solid report development experience including Crystal Reports and SQL Server Reporting Services (SSRS).
* Previous experience with Tableau data loads, dashboard development and visualization techniques.
* Previous experience with Amazon Web Services cloud computing tools and data warehousing services.
* Excellent oral and written communication skills
* Strong analytical and troubleshooting abilities.
* Must be detail oriented and extremely organized and have the ability to manage multiple assignments simultaneously.
* Knowledge of Real Estate Investment Management and / or fund accounting concepts, practices and procedures a plus.
Equal Employment Opportunity is not just the law, it's our commitment. Read more about the Equal Employment Opportunity Law.
If you need assistance applying due to being visually or hearing impaired, please email Careers Help.
We are an Equal Opportunity/Affirmative Action Employer. We will consider all qualified applicants for employment regardless of age, race, color, national origin, sex, religion, veteran status, disability, sexual orientation, gender identity, or any other legally protected status.
Additional Information
* Requisition ID: 1719014

* Minimum of a Bachelor's degree. * 3 or more years of experience with Oracle V12. * 3 or more years of ETL development experience. * 3 or more years of experience with creating star schema data models. * 3 or more years of experience in a complex data warehouse environment. * 3 or more years of experience in relational and multi-dimensional data modeling, and the use of data modeling tools. Desired Skills: * Experience with Datastage or SSIS * Performing ETLs and validating results with business representatives * Ability to collaborate on a team with infrastructure, BI report development and business analyst resources, and clearly communicate solutions to both technical and non-technical team members * Solid report development experience including Crystal Reports and SQL Server Reporting Services (SSRS). * Previous experience with Tableau data loads, dashboard development and visualization techniques. * Previous experience with Amazon Web Services cloud computing tools and data warehousing services. * Excellent oral and written communication skills * Strong analytical and troubleshooting abilities. * Must be detail oriented and extremely organized and have the ability to manage multiple assignments simultaneously. * Knowledge of Real Estate Investment Management and / or fund accounting concepts, practices and procedures a plus.


Associated topics: data analyst, data architect, data center, data engineer, data warehousing, hbase, mongo database, sql, sybase, teradata

* The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.

Launch your career - Upload your resume now!


Loading some great jobs for you...