Senior Business Intelligence Developer DriveCam
THIS JOB HAS EXPIRED Position Overview
The Senior BI Developer will research, design, implement and maintain advanced Business intelligence applications, including, but not limited to queries, dashboards and formatted reports as well as developing required data sources. This position is responsible for working with business users to understand their needs and then translates them into solutions which deliver business value. This position supports DriveCam?s flagship SaaS product, DriveCam On-Line (DOL).
Responsible for design, development and maintenance of queries, dashboards and formatted reports as well as developing required data sources.
Use of expert knowledge in SQL , SSIS, SSRS, SSAS to refactor, recreate and build new reports, cubes, dashboards.
Develop reports, widgets and dashboards for key performance indicators, business metrics and operational data.
Design, code, test and document reporting and BI solutions.
May develop ad-hoc reporting and BI solutions.
Evaluate and recommend reporting tools (management dashboards, formatted reporting, interactive analysis and data exploration).
Provides hands-on development, unit testing, system testing and support for ETL processes, included bug fixes.
Develop and maintain SQL Server Reporting Services and Reports.
Design Extract, Transform, and Load (ETL) processes of obtaining data from source systems, transforming/cleansing/enhancing data, and providing data to consumer systems
Delivers post-implementation production support .
Contribute to the team 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. Trouble shoot issues with reporting. May include support activities to deliver ad hoc reporting to support evolving business reporting needs
Work with Director of BI, BI Architect, Vendors, business and technical teams to understand Business intelligence needs and translate into capability and platform roadmaps.
Project management for high-visibility projects.
Bachelor's degree in Business, Computer Science or equivalent
10+ Years overall IT background with significant portion in data
7+ years of development experience with Data Warehousing and Business Intelligence solutions
?5+ years of RDBMS experience primarily with SQL Server.
Demonstrated proficiency in BI/analytics reporting and data warehouse principles/concepts (slowly changing dimensions, normalized vs. denormalized models, dimensional vs. relational modeling, star vs. snowflake schemas, metadata, etc.).
Strong with stored procedures, triggers and queries.
Hands-on experience with BI tools in an enterprise environment
Experience with Data Modeling and Data Modeling techniques and tools.
Expert knowledge of relational databases (MS SQL Server, Oracle)
Experience building OLAP cubes and frameworks
Strong knowledge of ETL and ETL tools
Knowledge of .net, C# a plus
Start-up experience a plus
||8911 Balboa Avenue |
San Diego, CA 92123
THIS JOB HAS EXPIRED