Job Description
POSITION : Business/Data Analyst
LOCATION : Remote
Job Type : Contract
Need to live in one of these states:
Remote, TX
Remote, GA
Remote, ID
Remote, OR
Remote, SC
Remote, WA
REQUIRED SKILLS
Candidates must have experience in the following areas:
- Business Requirements: Gathering and documentation
- Data Requirements: Gathering and documentation
- Source to target mapping process and documentation
- Strong SQL knowledge and experience need to be able to write queries from scratch
- Fundamental knowledge of Data Modeling and Design
- Fundamentals of Data Architecture - Data Warehouse and Data Lakes
- Experience working with agile teams in a matrix org
- Preferred: Experience with Snowflake in any capacity (user, developer, config, etc.)
Role and Responsibilities:
- Responsible for identifying opportunities for improving Business Intelligence Solutions at the enterprise level through the use of technology, exhibiting a broad knowledge base of multiple source systems and BECU business units in a highly collaborative environment
- Works on complex projects/teams and acts as a mentor and lead to other Analysts
- This role acts as a liaison between business units and IT departments to translate business needs and objectives into Business Information solutions
- Collect, elicit, document business and functional requirements as per BECU standards
- 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
- Participate in design and architecture of solution
- Develop source to target mapping documentation
- Establish and document application configurations from a business and technical perspective
- Deliver Business Requirements for the "consumption layer" (Datamart, Visualizations, 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)
- Identify, document and manage risks and issues
- 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
- Identify, update and integrate Data Cataloging and business glossary
- Lead and participate in user acceptance testing (UAT)
- Ensure BECU Security, Governance, Enterprise Architecture guidance and protocols are adhered to
- Facilitate testing of Security models and Role-based Access Control instantiated for the various environments (BECU to provide procedures and protocols)
- Transition application knowledge and project work to designated BECU resources
- Communicate progress, risks, and issues to the project team
- Work with BECU team and vendors to execute project work, as needed
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 BECU Data & BI leadership
Key Tools/Technologies:
- SQL and other relational database concepts and languages required
- Alteryx
- Tableau
- PowerBI
- Python
- SQL Server Management Studio
- Azure Synapse
- Advanced Excel, Word and PowerPoint
- Data Modeling tools such as ErWin, Embarcadero, etc.
- Data quality, governance and cataloging tools such as Purview, Collibra, Ataccama, Alation, etc.
- 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
Avinash Kumar Sr. IT Recruiter
Email- avinashk@stellentit.com
Phone Number : +1 321 7856 062
STELLENT IT A Nationally Recognized Minority Certified Enterprise
" Happiness can be found, even in the darkest of times, if one only remembers to turn on the light ."
- JK Rowling
Job Tags
Contract work, Remote job,