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.

Interested applicants can apply by completing the application through the link below:


Apply for the position

Return to list
This website uses cookies. By using this website, you agree to our use of cookies. Click OK to agree and remove this banner, or visit our Privacy Policy to learn how we use cookies and to opt out.