Business Intelligence Analyst Lead

OverviewDevelops reports using data-warehouse and data-access tools; provides user support and training for data structure and use of Data Warehouse; creates mapping specifications from source systems to new and expanded business-intelligence systems, and designs, tests and implements new business intelligence systems.Location: Phoenix, AZ, 85021 (Hybrid – onsite 1 days a week)Responsibilities: AnalysisTrack and resolve processing problems, coordinating with all areasTrack and resolve programming problemsDevelop and document business objectives, processing requirements, and specificationsDevelop and document system and data diagrams, program flowsDevelop test plans, scripts and test basesAnalyze files and map data from one system to anotherDraft or modify internal procedures; implement new procedures including workflows, manuals and trainingUtilize corporate data tools to ensure quality and documentation standards are achieved.Provide backup support to SME’s in two or more of areas as assigned:BI Project ManagementBI Production ReportingApplication ArchitectureApplication Architecture and SupportTrainingProvide backup support to SME’s in one or more datamarts Technical/ProgrammingLearn process and data flow; and how it affects surrounding systems and operational areas.Map logical data models to physical data models.Maintain existing programs/routine changes and major enhancements.Document programs, systems, manuals, etc.Review code for proper design, standards, content and functionality.Design and code complex programs.Responsible for production cycles, solving abends and notification of problems.Responsible for production support documentation in accordance with department standards and industry best practices.Review code for proper design, standards, content and functionality.Program in multiple programming languages (SQL, VB.net, 3GL/4GL).Translate business needs into technical solutions with knowledge of Bl Tools (SQL, ETL, and OLAP).Implement and maintain operational and disaster-recovery procedures.Manage MetadataConduct capacity planningWrite or modify procedures for internal use, user operational areas, and computer operations, as applicable.Utilize ODBC and OLE DB methodology. Business Intelligence / DatabaseEducate users on data warehouse capabilities; gain consensus among users on common data definitionsUnderstand business opportunities for information usageSchedule data updates and report generationDevelop business intelligence and EIS applicationsConvert existing reporting applications to use the data warehouse and datamartsDevelop periodic reporting systemsDevelop monitoring systems to ensure data has been updated as expectedMonitor data qualityImplement data access toolsDevelop metadata management processes and/or systems Project ManagementDevelop programs, time estimates and project schedules based on prioritization and business requirements.Use sound project management methodology and demonstrate solid time management skills.Creates and delivers presentations.Monitor and create priority list(s) that are agreed to by user management User SupportAssist users with data requests and end-user supportCreate basic ad-hoc reports for internal usage and external usagePerforms job functions with general supervisionTrain data warehouse usersEnsure the department leverages internal tools and applications effectivelyBuild, support, and maintain moderately complex processes, programs, and dataParticipate or lead small to medium scoped projectsCreate moderately complex ad-hoc reports for internal usage and external usageResearch and become proficient in two or more of areas as assigned:BI Project ManagementBI Production ReportingApplication ArchitectureApplication Architecture and SupportTrainingResearch and become proficient in one or more data martsRequirements:Bachelor’s Degree in Computer Science, Information Systems, Business, or related field (Preferred)2 – 5 years of experience in data management and report analysis, design, or development2 years of experience working in healthcare-related systems as a business analyst or programmerStrong SQL (write queries to extract data from MSFT SQL data warehouses)Strong experience in Power BIAbility to build out Power BI DashboardsExperience in SnowflakeAbility to build out agents in SnowflakeCompensation$50.55/hr. - $58.55/hr. (W2/Non-Exempt)Req# 235012