Senior BI/SQL Developer LegalZoom
The Sr. BI/SQL developer will be responsible for defining, designing and implementing business intelligence (BI) technologies and services to enable the analysis of data to support strategic initiatives and ongoing business requirements. This position requires the skills to perform analysis, design, configuration and implementation of data warehouses, business intelligence applications, and underlying relational databases, while maintaining existing systems. This role will develop data warehouse and business intelligence solutions using Microsoft Business Intelligence tools and underlying technologies.
This role will require very strong SQL development skills and ability to digest and understand existing SQL code. Experience with revenue recognition and working with finance is a big plus.
What you?ll do:
Maintain and support the existing Revenue and Accounting reporting systems
Support strategic initiatives and ongoing business requirements in a fast-paced environment
Design and implement reporting applications including (but not limited to) BI dashboards, reporting cubes, emails, and static reports
Deploy and validate reports.
Work with project lead and business users to gather requirements, conduct analysis and prepare specifications
Translate project requirements into functional and non-functional specifications for BI reports and applications
Contribute to and support the organization?s Business Intelligence strategy
Development and implementation of tactical and strategic data warehousing solutions including corporate Data Warehouse
Develop, implement and maintain test strategies and plans
Design and implement multi-dimensional models, including the construction of Data View, Dimensions, and Cubes while adhering to enforced development methodologies.
Design and implement reporting applications including (but not limited to) BI dashboards, reporting cubes and static reports
Convert existing reporting tools to a standardized reporting infrastructure using SQL and Microsoft products
Design and implement required interfaces for the data warehouse including to BI tools and other applications used by the business
Design and implement the data loading (ETL) and publishing processes within the DW/BI environment
5+ years of experience in T-SQL
5+ years of experience in SSRS (or other reporting platform)
5+ years in gathering report requirements.
3-5 years of experience in integrating reports with sharepoint.
3-5 years of experience in building reports using OLAP systems like SSAS
3+ years of developing Business Intelligence solutions (reports, dashboards, scorecards) using Microsoft SSRS, SSAS, and MDX in a data warehousing environment
Experience in report performance tuning
Responsible for understanding user requirements and clearly communicating to other reporting team members.
Experience in validating reports built by other teams
Experience in software development lifecycle
Experience with Ecommerce
Experience with Financial/Accounting reporting
Experience in T-SQL
Experience with ETL
Experience with Cube experience is a plus
Experience with Sharepoint Excel Services is a plus.
Experience with SSRS is a plus.
||Glendale, CA |