Business Intelligence Developer Job Description
Business intelligence developer
provides direct support to the ESSCA Group Task Order Management System and other business systems using SQL Server Reporting Services (SSRS).
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:
Develop software code, in appropriate languages/systems, such as SQL, Scribe, Microsoft SSIS, and Microsoft SSRS, and other software languages, as required to meet requirements
Experience with BI tools such as report builders, ad-hoc queries with SQL application development environments, OLAP, dashboards, BAM (business activity monitoring), data mining and predictive modeling
Documentation of current and future metadata and reporting applications
Testing the Business Intelligence applications and troubleshooting
Design solutions for projects which are compliant with BI, Enterprise Data Warehouse (EDW) and Enterprise architectural standards
Work with Enterprise Architect team to ensure proper integration with EDW platforms and standards
Convert ad-hoc and Excel reports into scalable reporting solution
Design and develop modern Business Intelligence (BI) solutions including Performance Management Dashboards, Business Analytics Models and Visualizations, OLAP and Reporting
Provide modern information architecture technical designs and specifications for data integration and data storage to support new BI solutions
Provide full lifecycle support from implementation to maturity of BI solutions
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:
SQL
Mutual of Omaha practices
Assigned business areas
Insurance industry
SQL queries
SQL Server Reporting Services
Finance
Technical environment in the functional business areas
Current tools
Marketing
Desired experience for business intelligence developer includes:
Strong interest in working with data
Advanced hands-on experience with SSIS and SSRS
Mainframe Host knowledge an asset
Advanced/Expert level of experience in Excel
Ability to understand, build and explain logical entity relationship diagram
Extensive experience in SSIS and SSRS
Business Intelligence Developer Examples
1
Business Intelligence Developer Job Description
Job Description Example
Our innovative and growing company is looking for a business intelligence developer. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for business intelligence developer
- 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
Qualifications for business intelligence developer
- 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
2
Business Intelligence Developer Job Description
Job Description Example
Our company is growing rapidly and is looking to fill the role of business intelligence developer. To join our growing team, please review the list of responsibilities and qualifications.
Responsibilities for business intelligence developer
- 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
Qualifications for business intelligence developer
- 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
3
Business Intelligence Developer Job Description
Job Description Example
Our company is growing rapidly and is searching for experienced candidates for the position of business intelligence developer. If you are looking for an exciting place to work, please take a look at the list of qualifications below.
Responsibilities for business intelligence developer
- 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
Qualifications for business intelligence developer
- 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
4
Business Intelligence Developer Job Description
Job Description Example
Our company is growing rapidly and is searching for experienced candidates for the position of business intelligence developer. Thank you in advance for taking a look at the list of responsibilities and qualifications. We look forward to reviewing your resume.
Responsibilities for business intelligence developer
- 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
Qualifications for business intelligence developer
- 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
5
Business Intelligence Developer Job Description
Job Description Example
Our growing company is looking to fill the role of business intelligence developer. We appreciate you taking the time to review the list of qualifications and to apply for the position. If you don’t fill all of the qualifications, you may still be considered depending on your level of experience.
Responsibilities for business intelligence developer
- 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
Qualifications for business intelligence developer
- 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