Business Intelligence Developer Job Description
Business Intelligence Developer Duties & Responsibilities
To write an effective business intelligence developer job description, begin by listing detailed duties, responsibilities and expectations. We have included business intelligence developer job description templates that you can modify and use.
Sample responsibilities for this position include:
Business Intelligence Developer Qualifications
Qualifications for a job description may include education, certification, and experience.
Licensing or Certifications for Business Intelligence Developer
List any licenses or certifications required by the position: BI, MCSE, SQL, AWS, ITIL, CE, MOS, MS, BW4HANA, SSRS
Education for Business Intelligence Developer
Typically a job would require a certain level of education.
Employers hiring for the business intelligence developer job most commonly would prefer for their future employee to have a relevant degree such as Bachelor's and Master's Degree in Computer Science, Education, Engineering, Business, Information Technology, Mathematics, Information Systems, Technical, Statistics, Intelligence
Skills for Business Intelligence Developer
Desired skills for business intelligence developer include:
Desired experience for business intelligence developer includes:
Business Intelligence Developer Examples
Business Intelligence Developer Job Description
- Partner with business systems analysts to understand and analyze business requirements
- Help refine business requirements and demonstrate feasibility of solutions by implementing prototypes
- Prepare functional design documents
- Design, develop, test, and implement dashboards and reports
- Perform IT validation of dashboards/reports and the data in EDW and help with business validation
- Prepare implementation plan and operational run book
- Work on resolution of support tickets
- Develop methods to measure and improve customer satisfaction
- Continually test and validate data repositories
- Model our big data / data warehouse
- Business Intelligence Developer certification is preferred
- 2-year college degree or equivalent IT industry experience
- A computer science degree working with object oriented languages or equivalent experience with the Microsoft Dev
- A strong customer service driven mentality
- Ability to work under the supervision of a team lead, to work independently, and as part of multiple teams on overlapping projects
- Experience with all aspects of the Software Development Life Cycle in both waterfall & Agile work environments
Business Intelligence Developer Job Description
- Design and develop Canned Reports, Analytics packages (OLAP), Dashboards, , using Report Studio, Cognos Workspace Advanced and Transformer
- Conduct data analysis thru various database techniques, SQLs, , and compile results appropriately for senior/executive management/legal
- Assist in the Design, build and management of a dimensionally-modelled data warehouse for a rapidly evolving and growing company
- Work with the Data Architect to create/Maintain reliable best-practice warehouse loading routines
- Leveraging the company’s BI solutions (Microsoft BI and Tableau) to deliver automated segmentation and analysis capability
- Create & Manage cleansing, de-duplication and data consistency activities to allow single business views of data (using a combination of custom developed and automation generated packages)
- Manage internal views of imported data to ensure consistent usage by all departments
- Report creation using Tableau and Excel
- Act as a point of reference for team colleagues, providing advice and direction regarding the appropriate course of action to take in relation to complex reporting, technical, analytical and data manipulation issues
- Lead projects with the department, working with colleagues within Business Analytics and IT to develop and continuously improve the reporting infrastructure, including data housing, data modeling, report performance, and report design and delivery tools
- Ability to work with minimal direction from management
- Ability to work with both business and technical teams
- Ability to take initiative demonstrate independence and self-motivation
- Expert-level experience writing Queries
- Business Intelligence Developer certified
- Demonstrates the ability to move from one assignment to the next
Business Intelligence Developer Job Description
- Use specialist/technical knowledge to deal with more complex reporting issues, including knowledge of appropriate reporting tools and specific insurance/processing expertise to obtain relevant accurate data from the systems
- Manipulate and format data to meet customer needs using appropriate tools and presentation styles
- Personally promote, maintain and develop a wide network of effective relationships with key contacts both internal and external
- Demonstrate a high level of adaptability to meet changing business requirements
- Plan, run, and manage meetings with internal and external clients (onsite and offshore) run with and complete important project initiatives
- Develop reporting software and business intelligence applications to support various lines of business and functional areas of the organization based on the overall information strategy and needs provided
- Design and document software architecture, software system interfaces, and overall software solution design and provide detailed technical specifications
- Perform standalone software unit testing and integrated system testing on implemented software
- Support the deployment and debugging and bug fixes of any deployed software components
- Management of interactions and expectations regarding development effort
- SSRS automated report development
- 3 to 5 years experience in design, development, and administration of BI tools such as SSAS, Business Objects, Crystal, required
- Building and managing agile BI applications in SAP Business objects, SQL server, Tableau & Power BI
- Experience in ETL & Business intelligence Development
- Recent experience in designing, developing and troubleshooting SSIS packages that implement ETL and/or QA processes
- Good experience in utilising the aspects of the Microsoft BI Stack to deliver effective BI to end users
Business Intelligence Developer Job Description
- Develop and automate ETL processes that involve data cleansing, error, reconciliation handling and process monitoring utilizing Microsoft SQL Server Integration Services (SSIS)
- Document software requirements and technical design specifications in support of business intelligence software applications
- Effectively communicate relevant project planning and status information to superiors, as needed
- Deliver engaging, informative, well-organized presentations that are effectively tailored to the intended audience to convey system design
- Bachelor’s Degree in Engineering, Technology or related field required
- Minimum 4-6 years of software application development experience, with focus in the database and BI space
- Understanding of Business Intelligence and data warehouse technologies, methodologies and solutions
- Strong technical capabilities with knowledge of Microsoft software development technologies (SSIS, SSRS, SSAS) and software development practices
- Experience in Dimensional data modeling principles (star and snowflake schemas, de-normalized data structures, slowly changing dimensions, ) over several data warehouse technologies
- Must have good analytical and communication skills
- Develop SQL Agent jobs
- The ability to demonstrate solid SQL skills with recent experience in developing stored procedures and views
- The ability to adhere to development coding standards and working against best practices
- Experience of working in Agile SCRUM teams would be advantageous
- The confidence and drive to become the 'go-to' data and BI expert – with the hunger to learn new skills and adopt new technologies and train other team members
- Knowledge of NoSQL technologies would be advantageous – Hadoop, MongoDB etc
Business Intelligence Developer Job Description
- Assists with the development of the data model(s) for the data warehouse
- Performs analysis and design mapping data between source systems and the Enterprise Data Warehouse
- Work in a technology agnostic environment
- Full-life cycle experience with large scale Business Intelligence programs
- Designs, develops and supports reporting tools that utilize advanced features in MS Excel and MS Access, VBA, macros
- Codes components based upon the assigned technical design
- Specializes in a specific development platform
- Performs production support activities
- Produces required system documentation for all assignments
- Complies with departmental quality assurance, audit, design and code review standards – CMMI
- Relational Database development Oracle, SQL Server, Teradata
- Superior relational database experience on multiple environments (Oracle, DB2, SQL Server 2008, OLAP databases, etc)
- Experience working with SQL Server and aspects of the MS BI Stack
- Related Degree or equivalent, Computer Science/IT or Data
- Fluent in English + any other European or Asian language
- An interest in or knowledge of Consumer Technology Products would be desirable