Bring your career aspirations to life with AIA! As the Business Intelligence (BI) Analyst, he/she will be responsible for designing and building data and analytics reports across the organization. You will be a catalyst for growing the business intelligence capabilities, working closely with user departments to understand complex business problems and their analytical needs. You will develop, enhance, and maintain reports, dashboards and analytics using but not limited to Tableau, Microsoft Power BI and build a data pipeline across a wide range of disciplines to identify and capitalize on key opportunities for data analysis and reporting enhancements. You will be an advocate of BI throughout the organization and provide BI training and support to staff.
Roles and Responsibilities:
Responsible for building, implementing, and supporting Tableau and Microsoft Power BI solutions
Assist in the creation of a framework for how data, reports, and dashboards are managed and delivered
Create data visualizations, dashboards, and reports to present data using Tableau and Microsoft Power BI
Convert existing datasets/reports into SQL Server/Analysis Services/Power BI/Tableau Solutions
Contribute reporting and business intelligence expertise to special projects as required
Create and maintain business intelligence tools and reports, including physical data models and dimensional analysis
Build a data pipeline to automate the extraction, transformation and loading (ETL) of data into SQL
Write programs to automate business processes and synchronize data between applications
Assist stakeholders to determine business needs and requirements for BI, including the development of performance metrics and KPIs
Design, code, test and aggregate results from SQL queries to provide information to stakeholders
Analyze data to provide recommendations for future actions to business stakeholders
Foster a data-driven culture through the adoption and proliferation of data management best practices
Seek key points of integration with design, engineering and construction teams to gain cost and schedule efficiencies
Support and give advice for all levels of users in order to deliver high quality IT services and ensures the smooth production run of application systems
Ensures deliverables and systems comply with all applicable standards and guidelines
You are required to obtain relevant license if your job involves in regulated activities
Minimum Job Requirements:
University / College graduate in Computer Science or MIS related degree
Minimum 3 years of relevant experience
Knowledge of different phases of the System Development Life Cycle
Relational Database experience on at least one of Azure SQL, Sybase, MSSQL, Oracle, Cosmo and/or MongoDB.
Proficient with at least one of the platform : Azure Cloud, AWS, UNIX, Application Server (Websphere, JBOSS)
Hands-on experience using Tableau, Microsoft Power BI, Qlik, etc
Knowledge of API, microservices
Microsoft Azure Certification is a plus
Build a career with us as we help our customers and the community live healthier, longer, better lives.
You must provide all requested information, including Personal Data, to be considered for this career opportunity. Failure to provide such information may influence the processing and outcome of your application. You are responsible for ensuring that the information you submit is accurate and up-to-date.