The developer must have a sound understanding of BI best practices, relational structures, dimensional data modelling, structured query language (SQL) skills, data warehouse and reporting techniques.
Developer is responsible for the successful delivery of business intelligence information to the entire organization and is experienced in BI development and implementations, data architecture and data warehousing. Additional responsibilities include:
Creating star schema data models, performing ETLs and validating results with business representatives
Supporting implemented BI solutions by: monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues.
ad-hoc reporting.
multidimensional data model (cubes)