Established in 1999, Swan iT Recruitment is a well established, independent recruitment consultancy, providing contract, permanent and executive search and selection solutions throughout the UK, Europe and South Africa in the SAP and IT market sectors. To find the best candidates, you need to operate in their territory – to be where they are. At Swan iT Recruitment, we focus purely on doing just that – targeting, attracting and retaining the best applicants. Our mission is to create valuable long-term partnerships by investing time to understand your business model, culture, values and goals, as well as vacancy requirements in order to source the best candidate, not the first candidate, for your role. This approach is mirrored to our candidates. We believe that as a candidate, you have a unique offering, and it is our challenge and responsibility to find you the role that will allow you to grow and meet your career aspirations. We're not interested in just matching your skills to a job role – we commit to providing you with objective market intelligence to help you to make an informed decision about the organisation in which your personality, attitude, and ability will be most highly valued. Purpose To play a crucial role in bridging the gap between business needs and technical solutions within the realm of data warehousing. This role involves understanding business requirements, analysing data sources, and collaborating with stakeholders to ensure the effective design, development, and maintenance of data warehouses. To serve as a liaison between business users and technical teams to ensure that data warehouse solutions align with organizational objectives. Responsibilities Requirement Analysis Collaborate with business stakeholders to gather and document detailed requirements for data warehouse projects. Understand and analyse business processes to identify data-related needs and opportunities for improvement. Work closely with end-users to define data requirements, ensuring they align with business goals. Data Modelling Assist in the design and development of data models that support business requirements. Collaborate with data architects and data engineers to create logical and physical data models for the data warehouse. Ensure data models adhere to best practices and align with organizational standards. Data Profiling and Analysis Conduct data profiling and analysis on source systems to understand data quality, integrity, and relationships. Identify and document data anomalies, discrepancies, and patterns that may impact the effectiveness of the data warehouse. Documentation Create and maintain comprehensive documentation for data warehouse requirements, data models, and processes. Ensure documentation is kept up-to-date and readily available for reference by both technical and non-technical stakeholders. Communication and Collaboration Facilitate communication between business users and technical teams, translating business requirements into technical specifications. Collaborate with data engineers, ETL developers, and other stakeholders to ensure the successful implementation of data warehouse solutions. Quality Assurance Participate in the testing and validation of data warehouse solutions to ensure they meet business requirements and adhere to data quality standards. Identify and address issues related to data accuracy, completeness, and timeliness. Training and Support Provide training and support to end-users on accessing and utilizing data warehouse solutions. Assist in the development of user documentation and training materials. Continuous Improvement Stay informed about industry best practices, emerging technologies, and trends related to data warehousing. Proactively identify opportunities for process improvement and optimization of data warehouse solutions. Minimum Formal Qualifications and Training Bachelor's degree in Computer Science, Information Technology, Business, or a related field. Minimum Work Experience 3 Years experience in a business analyst role, preferably in a formal data, data warehousing, or business intelligence environment Technical/Business Competence Proven experience as a business analyst in data warehousing projects. Strong understanding of data modelling concepts and techniques. Proficiency in SQL and knowledge of database systems will be advantageous. Excellent communication and interpersonal skills. Analytical mindset with a keen attention to detail. Familiarity with business intelligence tools and reporting concepts. Ability to work collaboratively in a cross-functional team environment. Apply Now

Share this job with someone you think should apply!

Facebook

Data Warehouse Business Analyst Cape Town - Cape Town Region

Related Jobs

Data Business Analyst (FinTech) - Cape Town City Centre

Business Analyst Cape Town - Cape Town Region

Data Analyst Cape Town - Cape Town Region

Business Systems Analyst Cape Town - Cape Town City Centre

Systems Analyst Cape Town - Cape Town City Centre

Want to do another search?