Role: Sr. Business Intelligence Analyst

Location: Seattle, WA/Onsite

Employment Type: Longterm Contract 

Key Tools/Technologies:

• SQL and other relational database concepts and languages required
• Alteryx
• Python
• Tableau
• PowerBI
• SQL Server Management Studio
• Azure 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

QUALIFICATIONS

• Bachelor’s degree in Computer Science, Math, IT, Business or equivalent work or educational experience required.
• Minimum 7 years of experience in a related position working with data management solutions.
• Experience as Data/Business Intelligence Power User and Data Consumer required.
• Strong demonstrated experience acting as a business liaison and delivering both strategic and operational solutions to technical teams required.
• Experience owning, supporting and delivering the full data life cycle development and its various phases required. 
• Advanced level knowledge of SQL and Data Modeling for SQL and NoSQL Repositories required.
• Advanced level knowledge of data manipulation languages and tools such as Python, Alteryx etc. preferred.
• Advanced knowledge of multiple business intelligence and data discovery tool such as Tableau, Alteryx or Power BI required.
• Understanding of Cloud Computing required.
• Conversant with Machine Learning, Artificial Intelligence concepts, tools and technologies.
• Understanding of data engineering vocabulary and data architecture.  Includes experience working with Azure, DataOps, JIRA or other Agile development team tools required.
• Ability to plan, organize, schedule, and implement projects in accordance with established project management methodologies required.

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 departments 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.) and Artificial Intelligence capability build out initiatives
•       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 Architecture 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 architecture, 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 Data & BI leadership

Posted By