Data Architect, Business Intelligence (Data Reporting) for Financial company in San Jose, CA
Vacancy expired!
Summary This role will be responsible for creating/defining data warehouse architecture with enterprise BI tools. This role will require collaboration with the BI team and Business Units to optimize the daily Data Warehouse load process, report creation and delivery processes. The Architect will also enhance the data integration and ETL process, as well as create a new ETL process. Responsibility
Lead the architecture, strategy, and design of enterprise Data Warehouse and BI applications, Building Data Lake/Big data platforms while providing technical leadership for Data Warehouse implementations, with design and coding standards.
Experience with the Data Warehouse lifecycle components including Source data analysis, ETL, Data Marts, Reporting, Dashboards, Analytics.
Work with business leaders to gather and translate business requirements into data and information requirements for custom development efforts and business intelligence efforts.
Strong leadership, influencing, verbal and written communication skills are a must, as well as the ability to work effectively across internal and external organizations and virtual teams.
Work directly with project teams and solution owners to ensure that new and existing solutions adhere to the architecture standards and that they have controls in place to maintain a high level of data quality.
Ability to decompose, prioritize and provide workable solutions to solve complex business problems using data and analytics.
Define policies and establish standards for modeling, structuring, naming, describing, securing, and formatting data.
Design and implement a data lake, data warehouses, marts, cubes and universes to support predictive & reactive analytics strategies.
Must Have Skillset:
Minimum 5+ years of experience working as Data Warehouse Architect.
Extensive experience with writing and optimizing complex SQL queries.
Extensive experience with data modeling using a relational database.
Excellent written and verbal communication skills.
Mastered on one or more data visualization tools.
Excellent multi-tasking and organizational skills.
Excellent communication and interpersonal skills.
Development of Multi-dimensional data warehouses
Excellent problem solving and analytical thinking skills.
Extensive experience in ETL design and development required.
Experience in relational and NoSQL databases i.e. Oracle, MySQL, MSSQL, MongoDB, etc.
Desired Skillset:
Experience with other BI tools such as Power BI, QlikView, Tableau, Cognos, etc. is a plus.
Exceptional analytical, conceptual and problem-solving abilities.
Experience with any backend technologies like PHP, REST API, etc is a plus.
Submit resumes to
Type: Contract Duration: 6-12 Months Location: San Jose, CA