Report Developer

  • Commensurate with experience
  • Los Angeles, CA, USA
  • Permanent, Full time
  • TCW
  • 18 Feb 19

The Report Developer will work as part of the IT Corporate and Data Services team focusing on building and deploying reports using Microsoft SQL Server Reporting Services (SSRS). The incumbent must have strong reporting background, able to gather requirements from business users, and leverage all aspects of BI technologies and architecture such as delivery mechanisms, data model, data integration/ETL and reporting tools.

Overview

The Report Developer will work as part of the IT Corporate and Data Services team focusing on building and deploying reports using Microsoft SQL Server Reporting Services (SSRS).  The incumbent must have strong reporting background, able to gather requirements from business users, and leverage all aspects of BI technologies and architecture such as delivery mechanisms, data model, data integration/ETL and reporting tools.

Responsibilities

  • Accountable for the performance, reliability, availability, and scalability of reports as assigned.
  • Communicate effectively with direct manager and/or project lead to provide progress updates, roadblocks, and offer suggestions & solutions.
  • Code and design reports based upon detail specifications of business and/or user requirements.
  • Create complex reports (ex. Drill down reports) using multi-dimensional objects.
  • Develop complex SQL queries (ex: using various joins and sub-queries) and stored procedures.

Minimum Qualifications

  • Bachelor’s Degree in Computer Science, Information Technology or equivalent
  • 4+ years of experience in developing SSRS reports in SQL Server 2008/2012
  • Expertise in relational and dimensional data modeling techniques in a financial services environment
  • Demonstrated ability to write complex SQL for purposes of analyzing data and translation into back end database structures.
  • Mastery of SSIS, SSRS and SQL Server technologies
  • Strong communication and collaboration skills
  • Excellent problem-solving and organizational skills
  • Solid experience migrating reports using SQL Server SSRS
  • Solid stored procs and T-SQL programming
  • Experience with T-SQL query performance optimization
  • Must be detailed oriented, quality driven, fast paced, and well organized
  • Proven knowledge of data extraction

Desired Qualifications

  • Familiarity with Microsoft Master Data and Data Quality Services
  • Experience with SQL Server Analysis Services including cube design, development, implementation, and support
  • Experience with object oriented programing like Java or C#
  • Experience with SSRS 2016, Microsoft Power BI, Data Analysis Expressions (DAX), Multidimensional Expressions (MDX)
  • Prior asset management/financial services industry experience with an emphasis in Fixed Income preferred