icrunchdata Network
Huntington Beach, CA, USA
Jan 28, 2020
Full-time
Under the general leadership of the AVP DBA, Application Development and Integration, the Business Intelligence Developer will play a key role in the implementation and maintenance of Enterprise BI solution and work with business units to create Enterprise reports and dashboards. The Business Intelligence Developer will develop ETL (Extract, Transform and Load) processes to automate data flow, report delivery and error handling. This role will be responsible for data validation and root cause analysis on data anomalies. Additional responsibilities that will fall under the BI Developer include: Day-to-day oversight of sharePoint site. Workign with business units to insure content is current and relevant. Administer and develop SharePoint pages and content. Create and edit existing electronic forms. Mapping required data into online forms. Manage and deploy electronic documents through Docusign, DNA Core System and map inot Nautilus system for archiving purposes. Responsibilities: Manage Enterprise Business Intelligence solution; Creating reports and dashboards to support business units; Develop ETL processes to automate data flow, report delivery and error handling. Write SQL queries to generate data subsets for reports and dashboards. Manage data integrity on data warehouse and BI solutions by data validation and root cause analysis and make findings available in a clear and concise manner. SharePoint administration; Create pages and content, user permissions, Integrate Business Intelligence dashboards. Manage the ongoing maintenance, and development, of electronic documents. Work with third party vendors on support and to report issues for the Enterprise BI solutions. Be a contributing member of project teams with the possibility of multiple team projects overlapping. Manage your time and productivity to insure projects stay on task in time, cost, and scope. Effectively work with project manager and stakeholders, maintaining communications. Supports and participates in continuous improvement activities. Represents the Credit Union in a positive and professional manner. Maintains member, team members and other sensitive information with confidentiality. Treats co-workers and members with respect. Supports member relations and events that promotes member centric experiences. Other related duties as assigned. Qualifications: 3 years of experience writing SQL queries 3 years of experience creating enterprise reports and dashboards 3 years of experience creating, testing and deploying ETL (Extract, Transform and Load) processes Strong background in relational databases, data warehouses, business intelligence solutions and reporting Report Writing Data validation Automation/scripting SQL and Query Building MTA, MCP 2 year associates degree in Information Technology, or Analytics or equivalent related experience