Job Title: Senior BI ETL Developer
Company:Datafin
Job description: Job SummarySenior BI ETL Developer IT – Software Development
Cape Town – Western CapeENVIRONMENT:THE technical expertise of a highly analytical & solutions-driven Senior BI ETL Developer is sought by a dynamic Financial Services Group where you will take charge of creating ETL processes for transforming data residing in various source systems into actionable information using ETL tools and coding primarily in Transact-SQL. You will also be expected to interpret user requirements, building data pipelines to populate data structures that are easily accessible while providing accurate information which supports consistent and informed operational, tactical, and strategic business decisions. To be successful in this role you will need to possess a suitable IT-related tertiary qualification or similar, have 8+ years experience working with the Microsoft BI Stack and be well versed in SQL, SSIS, T-SQL and the Ralph Kimball methodology.DUTIES:
- Analysis of new requirements and adjusting the design of existing star schemas or designing new star schemas to meet query / reporting requirements.
- Adjust existing ETL processes, or design and build new ETL processes to accommodate new requirements.
- Testing and reconciliation of warehouse data to source data to ensure data integrity.
- Adhere to the companys internal BI SDLC and development methodologies.
- Provide a high-level of customer service.
REQUIREMENTS:Qualifications
- Relevant tertiary qualification in Information Technology or similar.
Experience/Skills
- 8+ Years commercial Business Intelligence (Microsoft Stacks) development
- Essential technology experience: SQL, SSIS.
- Working understanding of the Ralph Kimball methodology.
Other technologies utilised in the BI Department:
- Active Batch
- Visio / Vertabello Modelling tools
- Visual Studio
- Cognos / Tableau / Python
- Power BI
Advantageous
- SSAS, MDX, Tabular experience.
- Experience in the Business Intelligence environment in Financial Services or Retail industry.
ATTRIBUTES:
- Strong analytical, problem solving and conceptual thinking skills essential.
- Attention to detail and commitment to delivery is important.
- Be a team player with a positive attitude.
- Must be able to work to and manage deadlines.
- Flexible, able to change focus when required.
Presentable with excellent communication skills.Apply for this JobDatafinRecruiter
Expected salary: R11000 – 16000 per month
Location: Cape Town, Western Cape
Job date: Fri, 22 Nov 2024 00:34:04 GMT
Tips on What To Include In CV
Creating a professional CV is crucial for making a positive impression on potential employers. Start by keeping it clear and concise—aim for one to two pages. Use a clean, easy-to-read font like Arial or Calibri, and organize information with headings for sections such as Contact Information, Personal Statement, Work Experience, Education, Skills, and Certifications. Tailor your CV to each job by highlighting relevant experience and skills that align with the role’s requirements. Use bullet points to describe your achievements with specific metrics where possible, as numbers provide concrete evidence of your contributions. Finally, proofread carefully to avoid any spelling or grammar errors, as these can detract from a polished presentation.
