Senior BI/SQL Developer - LZ009
Talent Merchants - Glendale, CA

This job posting is no longer available on Talent Merchants. Find similar jobs: Senior Bi SQL Developer jobs - Talent Merchants jobs

Consumer Internet client of mine that has been around for about 10 years, profitable and cash flow positive for 5+ years, is an industry leader it's niche.

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 youll 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 organizations 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
  • CS degree

Preferred qualifications:
  • 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.