Sr Business Intelligence Analyst (remote work)

---

Job description

Sr Business Intelligence Analyst

Location: Remote

Contract

Role and Responsibilities:

Responsible for identifying opportunities for improving Business Intelligence Solutions

Works on complex projects/teams and acts as a mentor and lead to other Analysts

Lead liaison between business units and IT Clients to translate business needs and objectives into Business Information solutions

Create user stories and write acceptance criteria

Identify Data Sources, calculated measures, and other transformations (lookups)

Establish processes and automation for the enterprise-grade Data & BI platform

Develop source to target mapping documentation

Deliver Business Requirements for the consumption layer (Datamart, etc.)

Serve as a lead for Data Q&A liaison between business, developers, and other technical teams

Provide data and analytics support (i.e., SQL queries, Alteryx workflows, Tableau, PowerBI reports and dashboards)

Perform functional testing and data validation

Develop and execute testing plans, scenarios and validate data accuracy

Test data services (data pipelines, APIs) that feed downstream requirements (Dashboards, Models, etc.) to ensure that the data transferred correctly to the client application tools

Liaison with Data Governance team regarding the data catalog

Lead and participate in user acceptance testing (UAT)

Ensure BECU Security, Governance, Enterprise Clienthitecture guidance and protocols are adhered

Communicate progress, risks, and issues to the project team

Outcomes:

Following are some of the key deliverables expected from this role:

Functional requirements documents (BRD) with business requirements, dashboards and views, calculated measures, algorithmic inputs, SLAs, etc.

Source to Target mapping documents

Technical specifications documents (TSD) with Clienthitecture, data dictionary definitions, data model specifications, wireframes, computations/formulae for calculated measures, etc.

Test strategy, test plan and test cases for testing and data validation

Create data testing/validation scripts/Alteryx workflows

Produce operational support documentation (and runbooks with dev team s help)

Produce release notes/documentation

Create documentation for change control.

Provide end-user adoption support

Other project documentation and artifacts as defined and assigned by Project Manager or BECU Data & BI leadership

Key Tools/Technologies:

SQL and other relational database concepts and languages required

Alteryx

Tableau

PowerBI

Python

SQL Server Management Studio

Clienture Synapse

Advanced Excel, Word and PowerPoint

Data ingestion/ETL tools such as Informatica, SSIS, Matillion, Talend, etc.

Data warehouses, Data Lakes, and other data products such as Snowflake, Databricks, etc.

Finance/Fintech applications, systems, processes and best practices

<!– job description page –>