What are the responsibilities and job description for the Business Intelligence Developer position at Bayone?
Note : The individual will be 80% supporting BI development and 20% DBA critical activities.
Job Description :
We're in search of a BI Developer / Database Administrator to technically design and develop business intelligence database solutions supporting Tableau and Power BI analytics dashboards and reports. The individual will gain a strong understanding of business requirements, functional specification write-ups, prototyping, development, quality testing, user acceptance testing, roll-out and post-launch enhancements implementation. As a Database Administrator, you should have a demonstrated ability to manage and maintain SQL server databases, monitoring and troubleshooting batch jobs, access role management and support overall server management and patches.
Responsibilities :
- Partner closely with upstream application teams and developers to ensure data sources are accurate, available, and timely.
- Efficiently and accurately develop with complex SQL queries (stored procedures, views, and functions).
- Collaborate with front end business intelligence developers and analysts to test, clean, and standardize data to meet the business requirements.
- Responsible for detailed documentation of database structures, configurations, and procedures is essential for maintaining a well-managed database environment through functional specs and document repository.
- Designing the structure of new databases, including tables, relationships, and data integrity constraints, to ensure optimal performance and efficiency, including 3rd Normal Form i.e. normalization\denormalization as appropriate.
- Proactively monitor server, database, query performance.
- Fine tune query, database, server performance as needed.
- Make sure all access is provisioned through database roles and address instances not compliant.
- Regular database backup maintenance and retention according to backup and retention policy.
- Monitor agent jobs and troubleshoot when issues arise.
- Monitor SSIS package runs and first level of troubleshooting when issues arise in SSIS / SQL.
- Manage access through periodic audits and ensure users have correct access on the server.
- Have the confidence to work cross-functionally with various organizations including business stakeholders and technical partners to exchange ideas to meet business requirements.
- Must have excellent verbal communications skills and documentation skills to maintain work flows and query functionality.
- Adhere to Agile SCRUM methodology and processes.
Qualifications :
