This job board retrieves part of its jobs from: Toronto Jobs | Emplois Montréal | IT Jobs Canada

The New York State wants YOU to start a career here!

To post a job, login or create an account |  Post a Job

BI Lead Architect


This is a Full-time position in New York, NY posted January 10, 2022.

BI/SQL Developer

Full Time Permanent Role – Candidate need to be US Based. Out of US Candidates please do not apply


Job Description

Reporting into the Enterprise Business Intelligence team, we are looking for a Business Intelligence professional with strong background in data integration, ETL design and development, BI architecture, data modeling, and business and data analysis. This position will collaborate with IT, business leadership and business teams in the design and development of analytic solutions to drive differentiated service, operational efficiency, and a positive client experience. The role will work to realize these solutions through data acquisition across a wide portfolio of source systems, data preparation, and data visualization, providing information that is both relevant and actionable. In addition, the position will support existing reports and tools, answer ad hoc inquiries as needed, as well as mentoring BI team members.


  • Help define Enterprise level application and service architecture
  • Design and develop data ETL routines to integrate data from disparate source systems into an integrated business intelligence environment including defining source-to-target mappings, business rules and other required data transformations
  • Develop dashboards and reports using Microsoft Power BI, SSRS and other open source technologies.
  • Conduct business analysis to define the required data to fulfill on business requirements
  • Meet with Customers to understand business problems and questions, exploring options to model data driven platforms used for analyzing answers
  • Become a trusted partner for Customers who translates business problems into analysis; then helps interpret the analysis into actionable steps
  • Actively participate in the design, development, and maintenance of complex BI Dashboards, Reports, Queries, and integrated applications
  • Manage other resources to complete the development work needed to deliver the required product to the client
  • Analyze and share results with users to ensure content meets business requirements; and train users to facilitate adoption and understanding of BI reports and tools
  • Proactively initiate projects and analysis targeting opportunities for revenue growth, risk mitigation, and operational efficiency
  • Communicate with senior management and enterprise staff regarding resources for facilitating a culture of data-driven decision making
  • Provide technical support of the Microsoft Platform Software
  • Support the SSAS environment and provide support of existing Cubes
  • Comprehensive data analysis and design experience, with full knowledge of data warehouse & data mart methodologies as well analysis modeling
  • Lead solution and design sessions for end to end ecommerce, 3rd party and legacy integrated systems.
  • Deliver technical innovations in support of business growth; progressing ideas from concepts to full scale implementation with focus on flexibility, reuse, and overarching extensibility.

Basic qualifications for the opportunity

  • 5 + years of experience in the Microsoft business intelligence platform, including SQL Server databases, SQL Server Integration Services, Power BI/SSRS & SSAS
  • Experience with the PowerBI Cloud Services
  • Significant experience in the architecture, design and development of data integration solutions and data analysis
  • Expert in automating data integration routines
  • Expert in optimization of data integration processing and database design
  • Expertise in designing and developing dashboards, reports, analytics and data visualization solutions.
  • Experience setting up and managing Power BI Report server is a plus.
  • Experience in creating dimensional data models across multiple subject areas is a plus
  • Strong command of MS Excel
  • Experience and familiarity with processes, platforms, and stakeholders
  • Excellent technical documentation skills
  • Experience with one or more BI reporting tools like QlikView/QlikSense, Tableau, Micro Strategy, Open Source reporting is a plus
  • Ability to work independently in a fast paced environment with minimum over sight. You would own building a future proof integration architecture to solve integration needs across projects.
  • Balances a variety of competing goals in a design, including project time, scope and budget constraints, and system performance, message verbosity, and loose coupling.