Assoc Financial Information Systems Analyst

Basic Information

Country:

India

State:

Maharashtra

City:

IND Pune - Business Bay

Date published:

09-May-2019

Job ID:

25542

Description and Requirements

BMC Software – The Multi Cloud Management Company

BMC helps customers run and reinvent their businesses in the digital age by tackling their IT management challenges, championing their innovation, and celebrating their success.

Every BMC employee has the potential to have a tremendous impact on customer success—and when customers thrive, we all do.

BMC offers bold and fearless career-seekers like you the opportunity to expand your skills, your network, and your horizons as you work to enable customer growth and innovation every day. You will be surrounded by peers who inspire you, drive you, support you, and make you laugh out loud, in an environment that fosters individuality, respect, and personal ambition.


Primary Roles and Responsibilities:

  • 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. 
  • Database optimization (indexes, partitions, schemas, etc.) 
  • Implement database best practices (3rd normal form, naming conventions, field definitions, etc.) 
  • Security administration (create database roles and manage the users that have access to the specific roles with management approval) 
  • Ensure 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. 
  • 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.


Experience/ Qualifications:

  • SQL Server and MS Access
  • Database Administration 
  • Data 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 

It is the policy of BMC Software to afford equal opportunity for employment to all individuals regardless of race, color, age, national origin, physical or mental disability, history of disability, ancestry, citizenship status, political affiliation, religion, gender, transgender, gender identity, gender expression, marital status, status as a parent, sexual orientation, veteran status, genetic information or other factors prohibited by law, and to prohibit harassment or retaliation based on any of these factors.