Business Intelligence Analyst Lead at Cypress HCM Business Intelligence Analyst Lead at Cypress HCM in Phoenix, Arizona Posted in 22 minutes ago.

Type:

full-time

Job Description:

Overview Develops 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:

Analysis Track and resolve processing problems, coordinating with all areas Track and resolve programming problems Develop and document business objectives, processing requirements, and specifications Develop and document system and data diagrams, program flows Develop test plans, scripts and test bases Analyze files and map data from one system to another Draft or modify internal procedures; implement new procedures including workflows, manuals and training Utilize 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 Management BI Production Reporting Application Architecture Application Architecture and Support Training Provide backup support to SME's in one or more datamarts Technical/Programming Learn 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 Metadata Conduct capacity planning Write or modify procedures for internal use, user operational areas, and computer operations, as applicable. Utilize ODBC and OLE DB methodology. Business Intelligence / Database Educate users on data warehouse capabilities; gain consensus among users on common data definitions Understand business opportunities for information usage Schedule data updates and report generation Develop business intelligence and EIS applications Convert existing reporting applications to use the data warehouse and datamarts Develop periodic reporting systems Develop monitoring systems to ensure data has been updated as expected Monitor data quality Implement data access tools Develop metadata management processes and/or systems Project Management Develop 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 Support Assist users with data requests and end-user support Create basic ad-hoc reports for internal usage and external usage Performs job functions with general supervision Train data warehouse users Ensure the department leverages internal tools and applications effectively Build, support, and maintain moderately complex processes, programs, and data Participate or lead small to medium scoped projects Create moderately complex ad-hoc reports for internal usage and external usage Research and become proficient in two or more of areas as assigned: BI Project Management BI Production Reporting Application Architecture Application Architecture and Support Training Research and become proficient in one or more data marts

Requirements:

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 development 2 years of experience working in healthcare-related systems as a business analyst or programmer Strong SQL (write queries to extract data from

MSFT SQL

data warehouses) Strong experience in Power BI Ability to build out Power BI Dashboards Experience in Snowflake Ability to build out agents in Snowflake Compensation $50.55/hr. - $58.55/hr. (W2/Non-Exempt) Req# 235012