AltadenaRecruiter Since 2001
the smart solution for Altadena jobs

Business Intelligence Data Architect

Company: City National Bank
Location: Altadena
Posted on: February 12, 2020

Job Description:

As a part of the Business Intelligence team, the BI Data Architect will be responsible for translating requirements into a complete data warehouse and business intelligence solution as well as managing testing data to be consumed in automated, and manual, testing. The desired candidate will be responsible for the data model design and defining the ETL and metadata repository approach for EDW (Enterprise Data Warehouse), ODS (Operational Data Store) and any DMs (Data Marts). The candidate will work closely with the application Architects, DBA, Testers, and ETL Developers to analyze data requirements, design logical and physical models, evolve models to meet new and changing business requirements and develop processes for capturing and maintaining metadata from all data warehousing components.ResponsibilitiesWork as part of the larger Architecture teamResponsible for the architecture of the BI/Reporting environment, its design, performance, availability, and successDevelop, document and maintain data model related standardsEnsure quality, consistency and security of database design,Ensure that the BI implementations follow industry defined best practices, common standards and procedures Determine conceptual designs, logical databases, external data interface specifications, data loading plans, data maintenance plans and data security policiesTranslate business and data requirements into technical terms, propose and recommend technical solutionsParticipate in data sourcing analysis, data mapping, documenting requirements, setting up recurring data loads and testingProvide oversight on the design, development and implementation of new subject areas and reportsReview and approve database change requests to safeguard the databases and data integrityWork independently with minimum management supervision Understand the corporate business and appropriately prioritize activities to best serve business needs. Maintain, with others, testing data to a standard appropriate for realistic automated tests, for feature level testing, as well as performance testing.Basic QualificationsBachelors' degree in Computer ScienceMinimum 3 years of working experience as an architect in a complex data warehouse environment requiredMinimum of 4 year of experience working with SQL Server requiredJob Skills and KnowledgeMinimum 3-5 years of working experience as an architect in a complex data warehouse environment requiredB.S. in Computer Science or 4 year degree. MS in Computer Science preferredIn-depth understanding and working experience of Data Warehousing/Data modeling methodologies requiredHands-on experience using Erwin Working experience with SQL Server ETL development experience Working knowledge of Power BI, or similar, an advantage.Capable of clear communication with colleagues as well as external third partiesWilling to work both as a team member, as well as independently*Represents basic qualifications for the position. To be considered for this position you must at least meet the basic qualifications.City National Bank is an Equal Opportunity/Affirmative Action Employer, Minorities/Females/Individuals with Disabilities/VeteransNote: This preceding job description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities, and qualifications required of employees assigned to this job.Note: Candidates should be advised that City National Bank does not pay interviewee travel expenses or relocation expenses for candidates who are hired unless previously agreed. Equal Opportunity Employer Minorities/Women/Protected Veterans/Disabled

Keywords: City National Bank, Altadena , Business Intelligence Data Architect, Other , Altadena, California

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other Other Jobs


Pharma, Life Sciences & Med. Device - QMS Sr. Associate
Description: A career in our Supply Chain Management practice, within Operations Consulting services, will provide you with the opportunity to help our clients optimise all elements of their operations to move beyond (more...)
Company: PwC
Location: Lake Elsinore
Posted on: 02/28/2020

Registered Nurse Seasonal Assignments - HealthCare Travelers (Redlands)
Description: Registered Nurse. Travel
Company: HealthCare Traveler Jobs
Location: Redlands
Posted on: 02/28/2020

DevOps/SRE
Description: Join Hired and find your dream job as a DevOps Engineer/SRE at one of 10,000 companies looking for candidates just like you.Companies on Hired apply to you, not the other way around. You'll receive salary (more...)
Company: Hired
Location: Yucaipa
Posted on: 02/28/2020


Electrician
Description: br br Picture yourself spending your days in Disneyland, knowing you help keep attractions like Splash Mountain and The Matterhorn up and running. Wouldn't it be cool to put your skills to work on (more...)
Company: Disney Parks And Resorts
Location: Placentia
Posted on: 02/28/2020

DevOps/SRE
Description: Join Hired and find your dream job as a DevOps Engineer/SRE at one of 10,000 companies looking for candidates just like you.Companies on Hired apply to you, not the other way around. You'll receive salary (more...)
Company: Hired
Location: Altadena
Posted on: 02/28/2020

Chief Engineer C4I Systems
Description: Chief Engineer C4I SystemsOne global team creating trusted, innovative solutions to make the world a safer place---..Integrated Defense Systems IDS offers an innovative and inclusive culture welcoming (more...)
Company: Raytheon
Location: Altadena
Posted on: 02/28/2020

Produce Clerk- Text to Apply
Description: Job Introduction br br APPLY NOW: Text careers to 480-800-8056 br br Does collaborating with a team to deliver the finest produce presentation sound exciting Does working in the most popular (more...)
Company: Sprouts Farmers Market
Location: San Clemente
Posted on: 02/28/2020

DevOps/SRE
Description: Join Hired and find your dream job as a DevOps Engineer/SRE at one of 10,000 companies looking for candidates just like you.Companies on Hired apply to you, not the other way around. You'll receive salary (more...)
Company: Hired
Location: Apple Valley
Posted on: 02/28/2020

Grocery Clerk- Text to Apply
Description: Job Introduction br br APPLY NOW: Text careers to 480-800-8056 br br Do you like to work in different areas with different products Do you enjoy learning about different aspects of a grocery (more...)
Company: Sprouts Farmers Market
Location: San Clemente
Posted on: 02/28/2020

Dairy Clerk- Text to Apply
Description: Job Introduction br br APPLY NOW: Text careers to 480-800-8056 br br The Dairy Clerk is responsible for keeping all store dairy and frozen cases stocked and clean during business hours. They (more...)
Company: Sprouts Farmers Market
Location: San Clemente
Posted on: 02/28/2020

Log In or Create An Account

Get the latest California jobs by following @recnetCA on Twitter!

Altadena RSS job feeds