Sorry, this listing is no longer accepting applications. Don’t worry, we have more awesome opportunities and internships for you.

Sr Programmer Analyst, BI

PacSun

Sr Programmer Analyst, BI

Anaheim, CA
Full Time
Paid
  • Responsibilities

    The applications Senior Programmer Analyst BI should possess an in-depth knowledge of a variety of retail business applications, as well as an extensive background and expertise in analysis and design. Working with management, development teams, and/or business users; developing and maintaining business system applications using the MicroStrategy platform. In addition to being self-motivated, a Senior Programmer Analyst communicates and works well with team members and users alike, and is supportive of their needs. As a team member/leader, will also train and mentor others to help establish a group of strong Developers. ResponsibilitiesDevelops and maintains reusable objects, advanced reports, dashboards, and KPI scorecards using MicroStrategy. This includes all architectural and administration duties.Develops and maintains an ETL environment based on extensive SQL processes, for use across multiple systems and platforms.Development knowledge of Cognos as a part of Manhattan’s Active Omni SCI environment, a strong desirableUses programming and analytical skills to resolve user queries. Creates reports based on project work or business needs. Adheres to company standards and programming in a structured manner so reports are easily maintained.Develops high-level and detailed design specifications. Analyzes business and user needs and decides upon the best course of action. Documents strategies/approaches to solutions based upon a thorough review of the desired goal(s) and departmental objectives. Documents tasks, modifications and application flows.Performs unit and integration testing. Performs rigorous testing of all fixes, changes, additions and enhancements to any application system. Notifies any related personnel of any changes to the system.Mentors and trains existing Developers. Provides information to other developers by dispersing programming, analytical and application knowledge.Tracks and documents time requirements. Communicates project status to team members, users and management. Creates project plans and task lists when managing a project. Assists with large group/departmental project. Attends project meetings and other functions as requested by Management.May be required to perform supportive functions, with the percentage of time performing each function to be solely determined by the supervisor based on the particular requirements of the operation.QualificationsMust possess 4-5 years development experience with MicroStrategy, certification desirableStrong development and maintenance experience with SQL, cloud database experience desirablePreferred to have working knowledge of Cognos development environment, as an embedded application in Manhattan’s Active Omni productPreferred to have working knowledge of Manhattan Active Omni [MAO] Order Management System[OMS]Preferred to have working knowledge of Manhattan Warehouse Management System [WM]Working knowledge of dimensional data warehouse designExperience in performance tuning reports and documentsUnderstanding of data warehousing concepts and methodologiesExperience extracting and manipulating data from relational databases with advanced SQL, stored procedures. Experience with ETL tools is beneficialExperience with Automate is a plusExperience with Netezza is a plusBackground in developing retail and/or order management systems preferredBachelor’s Degree in Computer Science, degree or certificate from a computer trade school, or equivalent work experienceExperience with CRM tools is a plusOracle RMS experience is a plusExcellent oral and written communication skillsExperience with other BI tools such as MicroStrategy or Tableau is a plusAbility to work as a team memberAbility to resolve problems; resourcefulnessAbility to be flexible to the rapidly changing needs of the department and CompanyAbility to train fellow Programmer AnalystsTask and time management skillsExcellent problem determination skillsMust be a self-starter with quick ramp up timeMust be very dependable and require minimum supervision