To focus on building, testing, and maintaining BI solutions, using various technologies, IT infrastructure and systems that support business intelligence initiatives within the organisation. Works closely with data analysts and data engineers, to ensure that data is collected, stored, and transformed into actionable insights for Business Specific solutions.
Job Responsibilities
Develop and maintain simple to medium BI solutions across multiple data source using the standard enterprise technology infrastructure.
Provides input into the design of the data models, data flow and data integration requirements.
Create and manage Extract, Transform, Load (ETL) workflows using various sources, ensuring the data is cleansed and loaded accurately.
Use database query tools and data scheduling tools (e.g., Informatica, Microsoft SSIS), and scripting languages to build and optimize data pipelines.
Maintain data warehouse structures that efficiently store and organize large volumes of data.
Manage data quality, integrity, and security within the data warehouse for accurate reporting .
Conduct Data provisioning using database tools or using Data Virtualization Technology.
Test and verify for data inconsistencies, data types and data quality that may impact ingestion and provisioning.
Deliver multiple BI Use Case solutions, on an ongoing long term basis within a squad to meet business requirements.
Learn to interpret reports and Dashboards based on business needs.
Design the schema, define tables, and establish relationships between data entities.
Provide insights through Reports and Dashboards for business value.
Create visualizations, virtual marts and report to business stakeholders.
People Specification
Required Skills and Qualifications
Education: Bachelor's degree/ Diploma in Computer Science, Data Science, Information Systems, or a related field.
SQL Knowledge: Strong command of SQL to pull and change data.
BI Tools: Hands-on experience with tools like Power BI, Tableau, or QlikSense.
Data Modeling: Understanding of data design like star schemas and snowflake schemas.
Soft Skills: Good communication skills to explain data to people who are not technical