Assoc Financial Information Systems Analyst jobs in Pune at BMC

Assoc Financial Information Systems Analyst

State: Maharashtra

City: IND Pune - Business Bay

Job ID: 25542

BMC Software – The Multi Cloud Management Company

BU Description/Position Description:

Load and reconcile several SQL server and MS Access data sources.
Provide reconciliation and database status updates.
Recommend and implement process improvements using technical solutions.
Provide database administration functions for the assigned databases.
o Database optimization (indexes, partitions, schemas, etc.)
oImplement database best practices (3rd normal form, naming conventions, field definitions, etc.)
oSecurity administration (create database roles and manage the users that have access to the specific roles with management approval)
oEnsure data/metadata integrity through testing processes
Create and maintain process documentation.
Cross train team members.
Assist with ad-hoc analysis and data mining efforts when required.
Assist with standardization of reporting and analysis processes which are dependent on the databases managed.

Primary Roles and Responsibilities:

SQL Server and MS Access
oDatabase Administration
oData Mining (including ETL processes to automate and standardize population of data sources)
MS Excel – Advanced
MS Power Point – Intermediate
Business Objects report development
Hyperion (Essbase, Planning, HFM) a plus
MicroStrategy experience a plus
Tableau/Tableau Server experience a plus

Experience/ Qualifications:

Ability to understand functional (financial) requirements and translate them into technical specifications.
Good communication skills (written and verbal).
Sets high self-standards of performance.
Willing to perform tasks outside of own area of responsibility when needed.
Uses logic and work experience to solve complex problems in an effective way.
Ability to work directly with business user and IT counter-parties.
Be innovative and question the "status quo" by adding value to existing and new processes.

BMC has unmatched experience in IT management, supporting 92 of the Forbes Global 100, and earning recognition as an ITSM Gartner Magic Quadrant Leader for five years running. Our solutions offer speed, agility, and efficiency to tackle business challenges in the areas of service management, automation, operations, and the mainframe.