Defy Limits Banner



Location: Mabalacat, Region III

Date Posted: 2023-08-17

Hiring Organization: KMC Solutions | XTN-4A56504

Career Category: Application And Software Development

Functional overview

The Reporting Developer is responsible for providing comprehensive reporting solutions and data analytics to highlight useful information and turn data into knowledge for internal and external customers.

In this role, you should have a background in technical analysis. You should be analytical and an excellent communicator. Having business acumen and problem-solving aptitude is highly desirable.

Duties and responsibilities

  • Identification and resolution of anomalies in various data sources
    • Bug fixing
    • Unit Testing
    • Troubleshooting
  • Maintenance and support in Azure Analysis Service
  • Creation, maintenance and support tools in Azure to store and process data i.e. Data Factory, MS Azure Blob Storage, AAS models and servers
  • Maintenance and support of legacy reporting tools (e.g. Excel, Crystal)
  • Incorporation of data analysis into designated ongoing reports
  • Use analysed data to create reports identifying process improvement opportunities
  • Development and maintenance of technical and support documentation
  • Creation of visualizations and reports for requested projects
  • Maintenance and support of data from primary or secondary data sources and maintenance of data governance processes
  • Application of SQL skills
    • Interpret data, and analyse results using statistical techniques
    • Identify, analyse, and interpret trends or patterns in complex data sets
    • Filter and “clean” data
  • Translation of business needs to technical specifications
  • Evaluation and improvement existing BI systems
  • Collaboration with teams to integrate systems
  • Maintenance and support of wordpress sites

Requirements and Skills

  • Proven experience in data modelling, data analysis and report development
  • Industry experience is preferred
  • In-depth understanding of database management systems (e.g. Oracle, SQL Server, MySQL), online analytical processing (OLAP) and ETL (Extract, transform, load) framework
  • Familiarity Microsoft Power BI and DAX
  • Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
  • Proven abilities to take initiative and be innovative
  • Analytical mind with a problem-solving aptitude
  • BSc in Computer Science or relevant field
  • 3+ years of related experience