We are looking for both a Senior and Intermediate BI ETL Developer with a flair for creating robust ETL processes and a passion for data transformation. Join our clients team to play a pivotal role in converting data into actionable business insights using advanced ETL tools and TransactSQ
Your Impact:
- Develop & Optimize ETL Processes: Build data pipelines to populate star schemas aligning with dynamic business needs.
- Analysis of new requirements and adjusting the design of existing star schemas or designing new star schemas to meet query / reporting requirements
- Ensure Data Integrity: Test and reconcile warehouse data ensuring accuracy and consistency
- Methodology Mastery: Utilize the Ralph Kimball methodology to underpin your design and development work.
Requirements
Who You Are:
- Experienced Professional: With 5 years in BI development wielding SQL and SSIS like a pro.
- Qualifications: A tertiary degree in IT or related fields with a solid grasp of the Microsoft BI Stack.
- Analytical Thinker: Strong problemsolving skills and an analytical mindset are part of your DNA.
- Kimball Methodology: Youre wellversed in the Ralph Kimball approach to data warehousing.
- Competencies:
Strong analytical problem solving and conceptual thinking skills essential - Attention to detail and commitment to delivery is important
- Must 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
Benefits
Why Our Client
- CuttingEdge Environment: Thrive in a place where Active Batch Visual Studio Cognos and Tableau are part of the daily toolkit.
- Strategic Impact: Your work will directly influence strategic decisions in Financial Services or Retail industries.
- Collaborative Culture: Join a team that values innovation flexibility and a cando attitude.
Essential technology experience: SQL, SSIS. SSAS, MDX, Tabular experience (advantageous) Working Understanding of Ralph Kimball methodology Experience in Business Intelligence environment in Financial Services or Retail industry desirable Other technologies: Active Batch Visio / Erwin modelling tools Visual Studio Cognos / Tableau