Essential Functions:
• Translate business needs to technical specifications
• Design, build and deploy BI solutions (e.g. reporting tools)
• Maintain and support data analytics platforms (e.g. MicroStrategy)
• Create tools to store data (e.g. OLAP cubes)
• Conduct unit testing and troubleshooting
• Evaluate and improve existing BI systems
• Collaborate with teams to integrate systems
• Develop and execute database queries and conduct analyses
• Create visualizations and reports for requested projects
• Develop and update technical documentation
Job Requirements:
• Experience delivering business intelligence solutions
• Experience with OLTP and OLAP database models
• Good analytical and problem-solving skills
• Fluent in relational database concepts and flat file processing concepts
• Must be knowledgeable in software development lifecycles/methodologies i.e. agile as strong presentation and collaboration skills and can communicate all aspects of the job requirements including the creation of formal documentation
• Database Technology: SQL Server, Netezza, Hadoop, Cloudera
• Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
• ETL Technology: SSIS, DataStage, Talend, CRON scripting, Perl
• BI Technology: SSRS, SSAS, Tableau, MicroStrategy
• Proficient Intime series analysis, clustering, decision trees and neural networks
• Strong problem solving, time management and organizational skills
Any Graduate