BI DEVELOPER SKILLS, EXPERIENCE, AND JOB REQUIREMENTS
Updated: Sep 20, 2024 - The (BI) Business Intelligence Developer specialized in data warehousing and BI solutions, with a deep understanding of architectural approaches such as the Kimball model and a strong grasp of Microsoft technology stacks and data engineering principles. Proficient in cloud technologies, particularly Azure, and skilled in utilizing Microsoft ETL tools, SQL Server, and BI technologies like Power BI, Spotfire, and Reporting Services. Additionally, holds industry-specific experience in oil and gas, with expertise in related accounting and ERP systems, and is knowledgeable in programming languages including C#, Java, and Python.
Summary of BI Developer Knowledge and Qualifications on Resume
1. BS in Computer Science with 3 years of Experience
- Experience working in Business Analytics or relevant field
- Experience working with databases and complex SQL procedures
- Data architecture and modeling skills
- Outstanding analytical & technical skills
- Experience with integration techniques and tools for cloud and on-premise applications
- Strong understanding of Business Processes and Integrations in global software companies
- Strong understanding of Sales, Marketing and Financial processes and metrics
- Exceptional organizational and presentation skills
- Highly organized and able to prioritize tasks
- Outstanding written, verbal, and interpersonal skills
- Strong problem-solving skills and an analytical mind
- Experience with additional information systems and technologies
- Experience with coding in a variety of languages
2. BS in Information Systems with 5 years of Experience
- Experience in data warehousing, modeling, end-to-end BI solutions
- Strong understanding of BI Solution Architectural approaches and data models, e.g., Kimball
- Strong understanding of BI Technology Stacks (Microsoft), Data Engineering Solutions, Data modeling, and Software Engineering principles and best practices
- Experience with cloud technology stacks (preferably Azure)
- Advanced experience with Microsoft ETL tools (Azure Data Factory and SSIS), the SQL Server
- platform, and the Microsoft BI Stack (Analysis Services, Reporting Services, Power BI)
- Advanced knowledge of SQL and query optimization techniques and approaches
- Advanced experience in the development and implementation of end-to-end BI and Data Engineering solutions
- Good understanding of Reporting, Analytics, and Data Visualization Solutions and reporting and BI Analytics Technologies (Power BI, Spotfire, Reporting Services)
- Exposure to one or more Object Oriented or Procedural Programming languages (C#, Java, Python)
- Experience in the oil and gas industry
- Knowledge of oil and gas Accounting and Land ERP
3. BS in Statistics with 2 years of Experience
- Database and application development experience using formal software development life cycle
- Experience in designing, developing and implementing an enterprise DW/BI system using Oracle Business Intelligence Enterprise Edition (OBIEE) and Oracle Data Integrator (ODI).
- Ability to work with professionalism and confidentiality, and is able to work independently and adapt to change in a very dynamic environment
- Experience with Oracle Business Intelligence Application (OBIA) architecture and pre-built data models
- Experience with at least one OBIA Analytics module (Finance, Projects, HR)
- Experience with extracting Oracle HCM Cloud data and loading into on-premise OBIA is an advantage
- Experience with Oracle Analytics Server (OAS) or Oracle Analytics Cloud (OAC) is an advantage
- Knowledge of EBS application modules (Oracle Projects, HRMS, GL, FA, AP, AR, PO, etc.) and integration into the overall Oracle suite
- Advanced SQL Server skills, including database design, stored procedure development and database optimization.
- Strong Microsoft Excel skills
- Solid ETL experience, including extraction of data from SQL databases, ERP systems and Microsoft Excel.
- Proficient in creating Microsoft Power BI and SSRS packages.
4. BS in Data Science with 4 years of Experience
- Demonstrable experience as a BI Developer creating engaging visualizations using leading BI tools (Power BI, Tableau, Qlik or similar)..
- Familiar with working within the MS Azure Cloud data platform environment (ADF, Azure SQL, DevOps, Azure Data Catalogue).
- Excellent communication and influencing skills with a passion for data storytelling.
- Proven ability to build strong stakeholder relationships whilst managing multiple priorities.
- Positively challenge stakeholders to ensure data capabilities facilitate the university outcomes.
- Proactive approach to problem-solving using strong Analytical skills and keen eye for detail.
- Ability to work independently and cross-functionally within a team to tight timescales.
- Experience using visualisation tools including Power BI and Tableau
- Design, develop and deploy data cleansing and migration solutions to support ongoing implementations.
- Experience working with external client stakeholders.
- Efficient working in Microsoft’s SQL Server Management Studio (SSMS) and Visual Studio
- Work in agile team environment