Data Warehouse/Business Intelligence Developer

Posted: Monday, May 03, 2021
Location: New York

Department: Information Technology
Direct report(s): No

General purpose of position

Assured Guaranty is looking for a highly collaborative, experienced agile Data Warehouse (DW)/Business Intelligence (BI) Developer to work closely with Business, BA/QA, and other DW Developers to deliver prioritized user stories in our Enterprise Data Warehouse.

Primary duties/responsibilities

  • Build SSRS/Power BI reports against MOLAP cube/dimensional star schema.
  • Ensure database optimization/tuning, integrity, consistency,
  • Design and develop optimized ETL packages in SSIS.
  • Assist with schema design, code review and SQL query tuning.
  • Build and manage MOLAP cubes.
  • Implement user stories.
  • Review code and fix defects
  • Follow and propose technology standards.
  • Work with team leads/managers to achieve milestones and delivery.
  • May be responsible for managing offshore team.

Specific skills, competencies, resources and/or software/technology used on the job

  • Strong written and verbal communication skills.
  • Experience in data warehouse design and dimensional modeling.
  • Knowledge and know-how to troubleshoot potential issues, and experience with best practices around database operations.
  • Application Lifecycle Management using Visual Studio, SSDT, TFS, and Git.
  • Highly organized and self-motivated with the ability to prioritize projects, meet deadlines, and make room for emergencies, as needed.
  • Knowledge of.NET: C#, WebAPI, ADO.NET/Entity Framework a plus.
  • Knowledge of NoSQL database such as MongoDB a plus.
  • Knowledge of fixed income and insurance would be an asset.

Education, certifications and/or experience requirements

  •  Bachelor’s degree or higher in Computer Science, Computer Engineering, or equivalent.
  • 5-7 years of experience as database/BI developer.


Please apply with the link below

Apply for the position

Return to list