As a member of the professional services team, the Business Intelligence Developer is responsible for new development, maintenance and optimization, and scalability of our customer SQL Server Data Warehouse and Business Intelligence platforms. We are looking for a Business Intelligence (BI) Developer to create and manage BI and analytics solutions that turn customer data into knowledge. In this role, you should have a background in data and business analysis. You should be analytical and an excellent communicator. If you also have a business acumen and problem-solving aptitude, we’d like to meet you. Ultimately, you will design and enhance client data warehouse and business intelligence systems to help us make better decisions.
Responsibilities
• Consult with client business leaders to develop solid requirements around major initiatives such as CRM, ERP, etc
• Translate acquired business needs to technical specifications
• Design, build and deploy BI solutions
• Maintain and support data analytics platforms
• 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
Requirements
• Proven experience as a BI Developer - specifically using Tableau and related tools
• Development of automated self-service BI reporting solutions and dashboards
• Background in data warehouse design (e.g. dimensional modeling) and data mining
• In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework
• Familiarity with BI technologies (e.g. Microsoft Power BI, Oracle BI, Tableau, Domo)
• Knowledge of SQL queries, SQL Server Analysis Services(SSAS), SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS)
• Proven abilities to take initiative and be innovative
• Analytical mind with a problem-solving aptitude
• Experience with Microsoft SQL Server 2012 or newer
• Ability to use appropriate problem solving, research and analysis tools
• Strong attention to detail
• Excellent communication skills, both written and verbal
• BS/BA in Computer Science, Engineering or relevant field
My background is in creating stored procedures and writing B/I reports. I have worked with star schema data warehouse. I have integrated data from different sources to one target.