Spectrum
SQL Developer-SpectrumJOB SUMMARYThis position is responsible for creating solution blueprints, high-level design and implementation strategies, logical and physical data models for end-to-end business intelligence and data warehousing solutions.
MAJOR DUTIES AND RESPONSIBILITIESWork in collaboration with BI delivery team leaders, business analysts and business leaders to understand business requirements and end users needsTranslate business requirements and end users needs into architecture blueprints that deliver cost effective & high performing, high quality BI solutions in compliance with Charter standards, policies and long-term technical strategiesDesign, develop, manage and update logical and physical data models) for the BI data martsWork with IT partners to review the upstream data warehouse data models and assess/mitigate the impact on BI sideCommunicate database designs to business and technical audiences, including business users, program sponsors, database administrators, ETL developers and BI developersWork with DBAs to migrate schema changes between development, QA and production environmentsProvide architectural expertise, thought leadership, direction, and assistance across entire BI organizationPresent proposed solution blueprints to the Architecture Review Board.
Communicate solution blueprints to other project team members, business users and program sponsorsParticipate in Architecture Review Board meetings.
Review solutions presented by other BI architects and provide construc