Job Description

Function:   IT

Job Purpose

The Programmer Analyst is responsible for the design, implementation, and maintenance of Advancements reporting efforts and reporting environment. Programmer analysts combine the jobs of both a systems analyst and a computer programmer. The position works with the various departments that relate to reporting, including divisions of IS and software vendors, as well as all units of Advancement, to meet data needs accurately and efficiently. Needs are to be met through ad hoc reporting, creating reports that are scheduled and delivered electronically or via a portal, developing a self-service environment, and providing training and on-point documentation for accessing all these options

Job Description


  • Contributes to team effort by accomplishing related results as needed.
  • Develops and maintains applications and databases by evaluating client needs.
  • Analysing requirements; developing software systems.
  • Protects operations by keeping information confidential.
  • Contributes in the integration of various systems


  • Arranges project requirements in programming sequence by analysing requirements, preparing a workflow chart and diagram using knowledge of computer capabilities, subject matter, programming language, and logic.
  • Programs the computer by encoding project requirements in computer language; entering coded information into the computer.
  • Confirms program operation by conducting tests, modifying program sequence and/or codes.
  • Provides reference for use of prime and personal computers by writing and maintaining user documentation, maintaining a help desk.
  • Maintains computer systems and programming guidelines by writing and updating policies and procedures.
  • Identifies requirements by establishing personal rapport with potential and actual clients and with other persons in a position to understand service requirements.
  • Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; participating in professional societies.


 - Analyzing Information, Problem Solving, Attention to Detail, Software Design, Software Debugging, Software Development Fundamentals, Software Documentation, Software Testing, Software Requirements, Software Development Process

- Fluent in Programming Languages and must be able to demonstrate expertise and experience in below all:

Experience as Power BI developer & Online Share point Development in Microsoft Technologies.

Power BI

  • creating compelling reports and dashboard using advanced DAX. Looking to work with an esteemed organization that gives me an opportunity to utilize my existing analytical skills and help make better business decisions. Integrated custom visuals based on business requirement using power BI desktop.
  • Converting all operational excel report, SAP, Salesforce, HRMS and other independent systems into Power BI Reports.3+ years of IT experience as Microsoft SQL Server developer implementing SSIS and SSRS using Microsoft Business Intelligence development studio (MSBI), SQL Server data tools (SSDT) and Power BI.
  • Developed SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from SQL Server.
  • Extensive hands-on experience in several Data Flow transformations including Derived-Column, Script, Slowly Changing Dimension, Look up, Data Conversion, Conditional-Split techniques, Merge, Multicast, Union All.
  • Experience in Requirement Analysis, Design and Development of Web applications using ASP.NET, VB.NET.
  • Expertise in enhancing and deploying the SSIS Packages from development server to production server
  • Strong Knowledge in dimensional Star Schema and Snowflakes Schema.
  • Hands on experience in Performance Tuning, Query Optimization
  • Strong Knowledge on Power BI to import data from various sources such as SQL Server, Azure SQL DB, SQL Server Analysis Services (Tabular Model), MS Excel etc.,
  • Environment: MS SQL Server 2016, SSIS/SSAS/SSRS, ETL, T-SQL, Visual Studio 2016, SQL Server Profiler, Erwin Data Modeler 7.2, Dashboard, SQL Server Management Studio, SQL Server Data Tools (SSDT), Power BI, Power BI Desktop

Share point Online

  • Development of Workflows
  • Development of Applications
  • Integrating with SQL database and SAP, Salesforce, HRMS, Manage engine ticketing system, Bot’s development/maintenance
  • Maintenance of DMS, KM Portal, Intranet, Finance helpdesk (developed on online/on prem SharePoint)

Additional Skills

Programming Languages ? C#/C++ Java/JavaScript ASP.NET HTML5, Python, PHPSwift 

Database Programming - Microsoft SQL Server, Access, Oracle, PostgreSQL, MongoDB

Platforms/Frameworks/APIs - Conceptually well-grounded in:

o Data Structures and algorithms

o Structured Programming

o Object Oriented Programming

o Relational Databases

o Web Services

Other Skills and Personal Qualities Required:

  • Very Good Written and Verbal expression and communication, particularly with users and external stakeholders in both demanding business situations and normal interpersonal communications
  • Time Management, Self-Organization and Personal Effectiveness
  • Analytical and Conceptual Skills
  • Critical Thinking o Problem Solving orientation
  • Demonstrates ownership of problems, issues

Personable Education

  • A Graduate Bachelor’s Degree in Science / Engineering is a must.
  • A B.Tech/Engineering Degree is preferred. A B.Tech with Computer Science or a follow-on major certification/additional degree in Computer Science (eg. NCST) is highly desirable Experience
  • ? 3 to 5 years’ experience in software development and Power BI
  • Demonstrable Programmer/Systems Analyst Experience in an International Customer Context is a plus
  • ? Excellent organizational and communication skill