Sr. Software Developer (Microstrategy Engineer)

Job description

Barclays Bank Delaware seeks a Sr. Software Developer (Microstrategy Engineer) for its Wilmington, DE location.

Duties: Implement system features and applications for MicroStrategy through development, design, modification, system testing, user interaction, and requirements gathering performed in accordance with Systems Development Life Cycle standards, policies and procedures. Develop, test and maintain computer databases and apply knowledge of database management systems to strategy, architecture, models, principles and standards for data warehouse. Conduct User Acceptance Testing/Quality Center (Testing/Validation), and User Training and Production Support and Maintenance for Business Users. Work with the Data Modeling team to analyze and design data models to satisfy business requirements, and troubleshoot live production issues. Gather Report requirements, and use Filters and Prompts, Templates, and Custom groups to generate reports for business analysis. Migrate Hyperion-Brio reports to MicroStrategy reporting, and design and develop reports (Standard/Ad Hoc), Report Builders, Icube, Data Visualization, Datasets and Interactive Dashboards. Distribute reports using Distribution Services, Narrowcast, and Control-M jobs. Interact with business units to design and build software to exact specifications. Work within agile software development methodology Scrum, working closely with Systems Analysts, Project Managers, and Testers to design and build end to end solutions. Coordinate with application administrators to ensure MicroStrategy application and servers are secure and updated with latest patches. Analyze performance tuning and reporting execution times, using VLDB Settings, Report Data Options, Project Level Settings, DM Pre/Post SQL, Partition Tables, Indexes (Group and BIT Map), and Aggregate tables. Recommend, implement and adhere to industry wide BI best practices and drive for changes to existing processes and/or procedures. Architect MicroStrategy Schema objects and develop/review code including Simple, Compound, Custom Facts and Attributes, Transformation, Table Alias, Logical Tables, Hierarchies; develop Simple, Derived, Compound, Nested, Transformation, Cumulative, Conditional, and Level-based metrics; and design application objects Filters, Base Metrics, Derived Metrics, Templates and Reports. Implement OLAP Functions, such as ApplySimple, ApplyAgg, and Apply Comparison, for filters, attributes, and metrics, and design and develop Transactional Services (POC) based dashboards. Maintain MicroStrategy, Object migration documents, and release notes to migrate changes in environments (DEV, QA, and PROD). Develop unit testes for new code created, modify existing unit tests for altered functionality, and develop system integration test. Design Dimensional and Multidimensional Modeling using Star and Snowflake schema. Recommend and establish governance and control around self-service BI/Analytics.

Requirements: 2 years post-secondary education (U.S. or foreign) in Computer Science, Engineering, Mathematics, or closely related field and five (5) years of experience in the position offered or as a MicroStrategy Architect, Data Analyst, Systems Analyst, or closely related position. Demonstrated experience must include: Utilizing software development at all levels of software delivery lifecycle (requirements gathering, design, testing, development, documentation, user interaction, and code review); Architecting MicroStrategy Schema objects using Simple, Compound, Custom Facts and Attributes, Transformation, Table Alias, Logical Tables, Hierarchies, and designing application objects Filters, Base Metrics, Derived Metrics, Templates and Reports; Reviewing business requirements and translating them into viable technical architectures, database schemas, and designs; Using and Filters and Prompts, Templates, and Custom groups; Utilizing Reporting tools such as Microstrategy to develop business intelligence reports; Distributing reports using Distribution Services, Narrowcast, and Control-M jobs; Performance tuning MicroStrategy reports, using dashboards and ICubes; Utilizing data architecture to collect, store, integrate, and use data in systems; Designing Dimensional and Multidimensional Modeling using Star and Snowflake schema; and Working within agile software development methodology Scrum. 40 hrs/wk. Barclays is an EEO/AA employer.