Job Description
AI Talent is looking for a full-time Business Intelligence Developer to join the fast-growing BI and analytics practice.
Requirements
Mandatory requirements :
•
Be willing to live in or travel to Southern region NSW / Canberra.
• Expertise in Full Microsoft BI Stack,
(SSAS, SSIS, SSRS, MSSQL)
T-SQL, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and Analysis Services Tabular (SSAS) and DAX.
• Experience in business analytics solutions tools
Microsoft Power BI.
• Understanding of PowerShell and C#.
• Experience with data cleansing and data migration of very large datasets.
• Experience in designing process maps, data flows, and technical solutions.
• Experience in
data warehouse design and dimensional modelling (Kimball Methodology)
.
Must have/Be able to:
• Generate data insights using BI tools (Power BI)
• Strong technical knowledge of modern cloud technologies and Infrastructure including Azure, Office 365 (Teams, SharePoint, OneDrive, Exchange, Power Automate, etc.)
• Experience in scripting languages, such as PowerShell, to build automation and process data.
• Background in data warehouse design (e.g. dimensional modelling) and data mining.
• In-depth understanding of database management systems, online analytical processing (OLAP), and Extract, Transform, Load framework (ETL).
• Hands-on SharePoint Online experience and JavaScript
• Prior experience in managing IT Projects.
• Knowledge in self-learning predictive models with machine-learning algorithms
• Test, Debug, and Fix errors in different applications.
• Document business requirements for BI and App solutions.
• Create technical documentation.
• Develop functional specifications for use by BI and System developers.
• Support our Business Analysts to translate user interview results into user stories, acceptance criteria, and simple wireframes.
• Good verbal and written communication skills to effectively collaborate with team members and stakeholders.
• Proven business acumen and problem-solving aptitude
• Proven abilities to take initiative and be innovative
• Work with SCRUM methodology.
• Knowledge of CRM software
• 8+ years working with relational databases SQL Server and proficient with structured and unstructured data
• 7+ years of consulting experience
• A strong passion for learning and adapting to new technologies.
Visa can be provided for a suitable candidate.
Benefits
Your actual pay will be based on your skills and experience.
Base pay range
A$70,000/yr - A$120,000/yr