Business Intelligence Solutions/Data Warehouse Architect

Business Intelligence Solutions/Data Warehouse Architect

Position : Business Intelligence Solutions/Data Warehouse Architect

Location : Long Island City, Queens, NY

Duration : Long term

The primary responsibility of the Business Intelligence Solutions/Data Warehouse Architect will be to provide thought leadership, and end-to-end solution architecture & design of large scale business Intelligence / data warehouse solution for the Office of School Support Services (OSSS).

• Participate in proposing, designing, and implementing solutions following the best practices of business intelligence / data warehouse solution architecture, standards, methodology and tools used.
• Develop standards for data governance programs.
• Work with database support team to build an inventory of data needed to implement the architecture.
• Ensure architectural requirements like scalability, security, performance, reliability, backup, disaster recovery, and business continuity and archiving strategy are implemented within solutions.
• Liaise with senior client executives, provide in-depth technical needs analysis and advise solution teams on database configuration/design and utilization.
• Present and implement solutions and recommendations, which are seen as leading edge in the industry.

Responsibilities include:

• Experience with agile development methodologies and ability to find the right balance between doing it now and doing it right.
• Expertise in developing and delivering working documents that communicate and corroborate complex ideas to both technical and non-technical teams.
• Identify technical and operational risks early and provide mitigation plans and strategies to address the risks.

Mandatory Experience / Skills :

• 8+ years experience with SQL Server based Business Intelligence solutions.
• 8+ years of Data Warehousing solution architecting Experience.
• 4+ years experience in a solution architect or development lead role in a data warehousing environment.
• 4+ years of experience with enterprise application integration software.
• 4+ years of Business Intelligence Solution developer and ETL developer experience.
• 4+ years of working on Data governance initiatives.

Preferred skills :

• Understand DW Implementation services and ability to assist the Application Development and Infrastructure teams in defining the scope of work and effort estimates to implement the solution.
• Ability to translate business requirements and conceptual model into technical requirements and communicate these to the Application Development and Infrastructure teams.
• Understanding of Logical and Physical database design including source to target data mapping and ETL processes.
• Ability to partner with Business Intelligence Team to conduct workshops and co-lead teams to conduct POCs.
• Ability to articulate clearly the benefits of the Data Warehouse and partner with BI team to communicate externally and internally across the organization.

All your information will be kept confidential according to EEO guidelines.