Business Intelligence Manager

Visa Hunt; Singapore; On-site; SGD 120,000 - 180,000; Full time

Job summary

AMC, licensed by the Singapore Police Force, seeks a skilled BI/Analytics professional to design, develop, and maintain enterprise BI solutions and dashboards. You will build data models, automate ETL, and deliver executive reporting across CRM, ERP, HRMS, and other cloud systems.

You will develop predictive analytics, ML models, and AI-powered BI solutions using Python/R and NLP. Experience with Azure/AWS/GCP and data governance is essential.

Qualifications

• :Bachelor's degree or higher in IT, Engineering, or related field.
• :Proven experience delivering enterprise BI and analytics solutions.
• :Strong expertise in Power BI, Tableau, Qlik Sense, or equivalent BI platforms.
• :Advanced SQL, DAX, Power Query, data modelling and Excel proficiency.
• :Proficient in Python or R for data science and analytics.
• :Experience with cloud platforms (Azure/AWS/GCP) and AI/ML integration.
• :Familiarity with NLP, Generative AI, and large language models is desirable.

Responsibilities

• :Design, develop, and maintain enterprise BI solutions and dashboards.
• :Build data models using Power Query, Power Pivot, DAX, and SQL.
• :Develop automated ETL to consolidate data from multiple systems.
• :Create executive dashboards, KPI scorecards, and forecasting models.
• :Ensure data cleansing, validation, and governance.
• :Develop predictive analytics and ML models using Python/R.
• :Implement AI-powered BI solutions and NLP features.
• :Design interactive visuals with slicers, drill-through, and advanced DAX.
• :Automate reporting with VBA, Power Automate, and Power Platform.
• :Architect scalable reporting with data warehousing and star schemas.
• :Collaborate with stakeholders to translate requirements into solutions.
• :Lead discovery workshops and present proposals and roadmaps.

Skills

Power BI

Tableau

Qlik Sense

SQL

Python

R

NLP

Azure

AWS

GCP

Education

Bachelor's degree in IT, Engineering, or related

Tools

Power BI

Tableau

Qlik Sense

SQL Server

Excel/Power Pivot

Job description

AMC Founded in 2006, licensed by the Singapore Police Force, Police Licensing and Regulatory Department. offers custom security solutions suited to your demands. We work towards meeting the unique needs of every client, be it an enhancement to your current security set up or a complete overhaul that includes:

• Virtual patrolling


• Facial recognition access control


• Remote vehicular access control


• License plate recognition technology


• Visitor Management System

Responsibilities

• Design, develop, and maintain enterprise Business Intelligence (BI) solutions, interactive dashboards, and executive reporting using Microsoft Power BI, Tableau, or Qlik Sense.


• Design and optimize data models using Power Query, Power Pivot, DAX, SQL, and advanced Excel to support enterprise reporting and analytics.


• Develop automated ETL (Extract, Transform, Load) workflows to consolidate data from multiple enterprise systems, including CRM, ERP, HRMS, ClickUp, ActiveCampaign, Microsoft Dynamics, Salesforce, and other cloud platforms.


• Build executive dashboards, KPI scorecards, forecasting models, and self-service analytics solutions that enable data-driven decision-making.


• Perform data cleansing, transformation, validation, and quality assurance to ensure data integrity and governance.


• Develop predictive analytics, statistical models, and business forecasting solutions using Python, R, SQL, and machine learning frameworks.


• Implement AI-powered business intelligence solutions using Natural Language Processing (NLP), Generative AI, and predictive analytics to improve operational efficiency and business performance.


• Create interactive visualizations using slicers, drill-through, drill-down, conditional formatting, custom visuals, and advanced DAX calculations.


• Automate repetitive reporting and business processes using VBA, Power Automate, Python scripting, and Microsoft Power Platform.


• Design scalable reporting architectures following data warehousing, dimensional modelling, and star schema best practices.


• Conduct business process analysis, business requirements gathering, gap analysis, and operational assessments to identify transformation opportunities.


• Translate business requirements into technical specifications, solution architectures, reporting frameworks, and implementation roadmaps.


• Collaborate with business stakeholders, consultants, project managers, and technology teams to develop enterprise analytics and digital transformation solutions.


• Lead business discovery workshops, stakeholder interviews, solution demonstrations, and consulting presentations.


• Prepare technical proposals, Statements of Work (SOW), capability statements, consulting proposals, and business cases.


• Develop and execute strategic business development plans to achieve annual revenue, profitability, and growth objectives.


• Identify and pursue opportunities in Business Intelligence, Data Analytics, Artificial Intelligence, Digital Transformation, Business Consulting, Organizational Development, and Enterprise Solutions.


• Lead responses to RFPs, RFIs, RFQs, government tenders, and enterprise procurement opportunities.


• Develop strategic account plans to drive client retention, account expansion, and long-term consulting engagements.


• Evaluate emerging technologies in Artificial Intelligence, Machine Learning, Data Analytics, Cloud Computing, and Business Intelligence.


• Recommend enterprise technology solutions aligned with business strategy and digital transformation initiatives.


• Work with cloud-based analytics platforms, including Microsoft Azure, AWS, and Google Cloud Platform (GCP), to support enterprise analytics and AI initiatives.


• Establish data governance standards, security controls, and compliance frameworks to ensure regulatory compliance and data quality.


• Maintain CRM systems, pipeline reports, project dashboards, and business intelligence reporting.


• Monitor business performance using KPIs, forecasting models, and executive scorecards.


• Support continuous improvement through process automation, analytics maturity assessments, and operational optimization.

Requirements

• Bachelor's degree in information technology, Engineering, Business Administration, or a related discipline.


• Proven experience delivering enterprise Business Intelligence and analytics solutions.


• Strong expertise in Microsoft Power BI, Tableau, Qlik Sense, or equivalent BI platforms.


• Advanced proficiency in SQL, DAX, Power Query (M Language), Power Pivot, and data modelling.


• Strong programming skills in Python or R, with experience using Pandas, NumPy, Scikit-learn, TensorFlow, PyTorch, or similar machine learning libraries.


• Experience developing AI and Machine Learning models, including regression, classification, clustering, forecasting, recommendation systems, and predictive analytics.


• Working knowledge of Natural Language Processing (NLP), Generative AI, and Large Language Models (LLMs) is highly desirable.


• Experience with cloud platforms such as Microsoft Azure, AWS, or Google Cloud Platform, including their AI and analytics services.


• Strong understanding of data warehousing, ETL pipelines, dimensional modelling, data lakes, and enterprise data architecture.


• Experience with Microsoft Fabric, Azure Synapse Analytics, Snowflake, Databricks, or similar enterprise analytics platforms is an advantage.


• Proficiency in Microsoft Excel, including advanced formulas, PivotTables, Power Query, Power Pivot, VBA, and automation techniques.


• Experience preparingtechnical proposals, consulting presentations, RFPs, RFIs, RFQs, and government tender submissions.


• Strong consultative sellingand enterprise solution development capabilities.


• Experience engaging senior executives, technical stakeholders, and business leaders.


• Familiarity with CRM platforms such as Salesforce, Microsoft Dynamics 365, HubSpot, or equivalent.


• Knowledge of Agile, Scrum, ITIL, Business Analysis, and Project Management methodologies.


• Strong analytical thinking, problem-solving, communication, and stakeholder management skills.


• Experience working with government agencies, multinational corporations, SMEs, or public sector organisations is an advantage.