BI Developer

Company: Spectrum
Location: Maryland Heights
Posted on: November 22, 2021

Job Description:

JOB 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 user's needsTranslate business requirements and end user's 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 constructive feedbackAssist Project Managers and BI delivery team leaders in estimating effort and resources for new projects and enhancement requestsEngage with IT teams such as Data Management, DBAs, Security, Storage and Networking when their involvement is required to meet the project needsParticipate in capacity planning for all layers in the BI technology stackHelp solve complex production issues spanning multiple tiers in the BI/DW technology stackStay current in new BI /DW technologies, evaluate them and make adoption recommendationsParticipate in developing and documenting technical standards and best practices for the BI organizationPerform other duties as requestedREQUIRED QUALIFICATIONSExpertise in all areas of data warehousing (architecture, data sourcing/acquisition, integration, transformation, presentation)Experience in logical and physical database design for data warehousing (3NF/Star Schemas) including SQL writing/tuning on MPP platforms such as Teradata and/or NetezzaProven ability to quickly grasp business requirements and translate them into optimized solution blueprintsStrong problem solving, collaboration and communication skills Passion for leveraging data to improve business outcomesExperience in developing roadmaps for BI Architecture disciplineExperience in developing and implementing complex data warehouse and BI solutionsPREFERRED QUALIFICATIONSCertification on Teradata and/or MicroStrategy is a plusFamiliarity with predictive modeling tools like SAS and/or RFamiliarity with Big Data technologies such as Hadoop and Spark is a plus but not requiredExperience in cable or another telecommunications service provider is a plusFamiliarity with Agile development methodologies such as Scrum, Kanban and SAFeEducationBachelor's degree or foreign equivalent in Economics, Mathematics, Computer Science; or equivalent training, education and experienceMaster's degree preferredRelated Work Experience Number of YearsArchitect in large-scale, complex BI/DW environments, withnumerous data sources 8+Erwin Data Modeler, ER/Studio or similar data modeling tools 3+ELT/SQL Development on Teradata or similar MPP database platform 2+ETL platforms such as Informatica, Ab-initio or Data Stage 2+BI reporting/OLAP platforms such asMicroStrategy (preferred), Cognos, Business Objects 2+WORKING CONDITIONSOffice environmentTravel - 10%.BBL602 296285 296285BR

Keywords: Spectrum, Springfield , BI Developer, IT / Software / Systems , Maryland Heights, Illinois