Mi-C3 is seeking a skilled, highly analytical Business Intelligence Specialist/ Report writer, who’s passionate about the intersection of technology and Intelligence Analysis (Corporate or Government - Military, Police, or Law Enforcement). The successful Business Intelligence Specialist/ Report writer will be responsible for creating reports for data created in the Mi-Fusion system, our Flagship Intelligence software.
This role provides deep technical and business support for all aspects of data acquisition, data analysis, data interpretation, and interactive data visualizations. The role enables us to assist our clients in extracting greater value from raw datasets that are varied in their composition, that are growing constantly, and tend to get more complex over time. At its core, we help our clients visualize their data in new and more informative ways than ever before.
The candidate will have an advanced understanding of SQL, ETL tools, data ingestion, data discovery & analysis, data cleansing, data transformation, data modelling, and data visualization.
JOB REQUIREMENTS
- Understand ETL concepts of data flow, data enrichment, data consolidation and transformation
- Understand database concepts of referential integrity, indexes and keys and table metadata
- Ability to design and develop Data Warehouse ETL processes and associated reporting
- Architect, design (including data model), develop, implement, and maintain code for ETL Transformation
- Architect and design queries to enable complex report construction - understanding that these are informed by business and other analytical demands..
- Expertise in one or more of these areas: data security, data storage, data ingestion, data streaming, data processing, data analysis & exploration, data quality, data visualization (using reporting & business intelligence), business process management/business rules processing, data exchange, or data modeling.
- Ability to collaborate with Business Analysts/ BPE’s and architects to analyze business requirements, develop data model strategies and develop technical design specifications
- 5 year's experience as a BI Analyst, BI Developer or Data Analyst
TECHNICAL REQUIREMENTS
- Database - Intermediate to advanced skills for doing SQL database queries and associated functions
- Database - Exposure to Time Series Database technologies such as Druid would be advantageous
- Familiarity with alternative data storage and transfer format such as JSON advantageous
- Familiarity with GraphQL advantageous
- Transformation tool - Experience with a transformation tool such as Pentaho Data Integration (kettle, database AND spoon) would be advantageous, but is not a necessity
- Report writer tools - Experience with Reporting tools such as SuperSet, Pentaho, Tableau, or similar.
- Source control: Experience using Git version control software would be advantageous
PERSONAL ATTRIBUTES
- Self-starter with a proactive attitude
- Ability to work independently while contributing effectively as part of a team
- Strong attention to detail
- Excellent communication skills — clear, regular, and accurate
- Naturally inquisitive; asks questions and avoids assumptions
- Confident and willing to engage thoughtfully
- Innovative thinker with the ability to handle situations in real time
- Capable of working well under pressure in a client-facing environment
- Previous experience in private security, police, military, or government agencies is preferred
OTHER REQUIREMENTS
- Eligibility for Top-Level Security Clearance:
- Candidates must be eligible to obtain and maintain security clearance at the highest level, in accordance with applicable national security regulations.
- On-Site Work Requirement:
- This role requires full-time, on-site presence at the client’s premises located in Pretoria. Remote or hybrid work arrangements are not applicable.
Top Skills
What We Do
Mi-C3 International Limited is a Malta based company that was established in 2014 by the CEO and founder, Glen Scott.
The history and the philosophy of Mi-C3 is in its name which is a combination of two acronyms. The genesis of the technology was in supporting Command and Control for organisations that needed technology to improve their situational awareness to manage and secure their facilities. However, our technology enabled Command and Control to be enhanced with Collaboration (C3) as organisations were empowered with multi-directional communications that took command and control to a new level as more decision-making could be automated and information flows organised in a way that reams of data are transformed into meaningful intelligence (Mi).
Generations of the Mi-C3 software started as a project in the early 2000’s as a solution to support a large oil and gas company operating across multiple countries to help manage its complex operation and considerable security risk spread over a wide and poorly accessible geographical area before the Internet of Things (IoT) was widely understood, and has subsequently grown to over 30,000 sites, and monitoring more than 1 million end points.
Over the years, this solution has evolved into our award winning* flagship product, AFFECTLI, and has delivered significant value to clients through the use of a combination of cutting-edge technologies in the fields of Digital Process Transformation, smart workspaces, AI, machine learning, data management and analytics.
AFFECTLI is an established, flagship product of Mi-C3 that won the Malta MCA eBusiness Award for Best B2B Application 2018, was shortlisted for a nomination in the World Summit Awards 2018 under the Business & Commerce category, is ISO 9001:2015; ISO/IEC 20000:2011 and SOC 2 Type II compliant.
