Taguig, PH January 6, 2020 Role Overview The BI developer will work with his agile team to plan, design and develop BI dashboards and reports. They will analyze the needs of the business for BI. They will strategize and design a plan to meet the specified needs. They will execute the plan as part of the team to provide the BI solution. The work will revolve around mostly the newest SQL server working with the Dundas BI solution.
Key Accountabilities / Duties:
Develop and manage effective working relationships with other departments, groups and personnel with whom work must be coordinated or interfaced
Gather and document functional and technical requirements, and translate requirements into reporting solutions, analytic tools, and dashboards that in turn delivers actionable data to end users
Develop in-depth understanding of underlying data, data structures, and business uses of data
Develop expertise in the business operations and how data supports those operations in order to provide the most effective business intelligence solutions possible
Identify gaps in data collection, the data model, and meta data for future enhancements
Create simple to complex data, reporting, and business intelligence solutions by utilizing existing reporting, analytics and business intelligence platforms
Comply with standards, best practices, and policies defined for the team
Provide support as required to ensure the availability and optimized performance of developed business intelligence applications and reports
Write high quality code to retrieve, analyze and present the data
Work with testing organization to write and execute comprehensive test plans that validate the accuracy of information and functionality to ensure delivery of high quality business intelligence applications.
Requirements:
Atleast 5 years direct work experience developing business focused automated reports using tools such as SSRS, as well as building necessary SQL data objects used by reports.
5 years direct work experience with Data Warehouse and related technologies such Microsoft SSIS, SQL, ETL, and OLAP data structures.
5 years direct work experience with Dundas, Tableau, SpotFire or Microsoft PowerBI.
Demonstrated experience creating, debugging, and modifying complex stored procedures and views, as well as querying and updating data using SQL.
Experience with production support and troubleshooting common report / data process issues.
Familiar with fact / dimension data modeling, and validating results of data transformation processes.
Exposure to extracting data from enterprise level system, such as CRMs, HR IS, or ERP a plus.
Understands software development methodologies and best practices as it pertains to database and report development, to include reviewing and testing deliverables.
Ability to document technical requirements for business processes and development needs.
Ability to create presentation-ready visuals, mock-ups, charts, graphs and summary reports in tight timeframes.
Ability to organize time to meet project timelines and effectively find solutions to common business intelligence problems with minimal guidance.
Ability to build strong relationships with team members and decision makers across the business.
Ability to develop and explain analytics needed by the business for decision making.
Willingness to tackle complex projects to successful completion and to learn new technologies.
Knowledge of Microsoft productivity tools such as Excel, PowerPoint and Visio, as well as willingness to learn approved third party solutions.
Experience at working both independently and in a team-oriented, collaborative environment is essential, as well as having strong interpersonal skills
Other desirable skills:
Strong knowledge of data migration between databases
Experience with NoSql databases and Map Reduce
Experience with PL/SQL in the Oracle 11g/12c environment
C# .NET programming experience
Good communication skills
Experience in collaborating with a global team
Ability to work independently, with a sense of accountability in delivering work on time and with quality
Continuous improvement mindset – has focus on efficiency and effectiveness and recommends process improvements
Equal Opportunity Employer
