Principal Business Intelligence Architect DriveCam
The Principal BI Architect will be responsible for overall BI solution architecture, including ETL and Data Warehouse solutions.
Responsible for delivering overall BI Solution architecture; may be responsible for contractor management
Design Extract, Transform, and Load (ETL) processes of obtaining data from source systems, transforming/cleansing/enhancing data, and providing data to consumer systems
Designs and documents Data Warehouse and Data Mart Solutions
Use of expert knowledge in SQL , SSIS, SSRS, SSAS to refactor, recreate and build new reports.
Designs Dimensional Data Models (Star Schemas), develops sourcing specifications, documents business rules for data transformation.
Responsible for the ETL process.
Provide guidance on how to leverage specific technologies to create the most effective solutions (Hadoop, WEBfocus, QlikView, SSAS, etc.)
Work with the BI team, Rally and TFS systems to coordinate assignment of issues and resolution plan. Troubleshoot issues with reporting. May include support activities to deliver ad hoc reporting to support evolving business reporting needs
Work with Director of BI, Architects, Vendors, business and technical teams to understand Business intelligence needs and translate into capability and platform roadmaps.
Project management for high-visibility projects.
Task other BI team members and provide regular status reporting
Bachelor's degree in Business, Computer Science or equivalent
Superb understanding of communications: elevation, statusing
Strong communication, influencing and presentation skills.
10+ years of BI/IT experience.
5+ years in a software designer or architect role.
7+ years designing and developing Data Warehouse solutions, from data modeling to implementation.
Demonstrated proficiency in delivering BI/analytics reporting and data warehouse solutions. Hands-on expertise in all data warehouse facets (slowly changing dimensions, normalized vs. denormalized models, dimensional vs. relational modeling, star vs. snowflake schemas, metadata, etc.).
Strong working experience in a range of BI Tools and knowledge of the BI market.
Extensive hands-on experience with BI tools in an enterprise environment
Experience with Data Modeling and Data Modeling techniques and tools.
Familiarity with 'Big Data' principles.
Expert knowledge and use of relational databases (MS SQL Server, Oracle)
Experience building OLAP cubes and frameworks
Strong knowledge of ETL and ETL tools.
Experience completing ETL procedures with a variety of data sources
DriveCam, Inc. is proud to be an equal opportunity/affirmative action employer. We are committed to attracting, retaining and maximizing the performance of a diverse and inclusive workforce.
||8911 Balboa Avenue |
San Diego, CA 92123