Position: BI Solution Architect (Onshore)
Location: Sunnyvale, CA
Duration: Contract
Experience: 10+ Years
Job Description:
Responsibilities:
- Responsible for architecting and implementing the conceptual, logical and physical data models to support the enterprise information strategies of the finance organization, the business intelligence agenda as well as our self-service analytics approach.
- Responsible for the integrity and quality of data and information stored and flowing between business applications, the enterprise data warehouse, data marts and business intelligence applications.
- 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.
- Responsible to ensure that the business intelligence team and technology team is managing and maintaining the data catalog, definitions, standards, governance and regulations surrounding data in the environment.
- Work with business leaders to gather and translate business requirements into data and information requirements for custom development efforts and business intelligence efforts.
- Work with the BI Team to design and implement efficient and accurate Extract, Transform, and Load (ETL) activities.
- Work with the Business and BSA to ensure that data provided in Reports, Dashboards and other analytical applications is used appropriately and governance rules are adhered to.
- Decompose, prioritize and provide workable solutions to solve complex business problems using data and analytics
Basic Qualifications:
- BS/BA in Computer Science, Business, Math or related field. Masters preferred.
- At least 10 years of experience in information technology.
- At least 5 years of data architecture experience.
- At least 5 years of experience with Microsoft SQL, SSIS, SSRS, SSAS and related technologies.
- Experience with Microsoft Azure BI and Analytics Stack including Azure SQL and related technologies.
- Practical experience in participating and running data management programs.
- Experience with enterprise data management technologies including data warehouses, ETL tools, SQL, and master data management solutions.
- Experience with visualization and reporting technologies.
- Experience in gathering and interpreting business requirements and translating them into insightful reporting solutions
- Strong communication and presentation skills – both written and oral.
- Strong organizational skills – must be able to design, lead and manage teams composed of stakeholders across diverse teams/domains.
Preferred Qualifications:
- Experience in Big data components/Frameworks such as Hadoop, HDFS, etc.
- Strong understanding of scalable cloud architecture
- Deep understanding of Finance data, application, server, and network security
- Experience designing and building dashboards, visualizations, and analytics using OBI
