Business System Analyst
DWH Business Systems Analyst
Hybrid Job - 3 Days in Office in Philadelphia Downtown
Open for W2, 1099
JD :
This BSA sits on the Data Warehousing team. Requires experience creating Business Requirement Documents and Mapping documents for the development of ETL applications.
This role requires extensive SQL experience in writing complex queries across multiple tables, data analysis and profiling skills for the creation of the mapping documents, and further discussion with data modelers for the necessary table designs.
Top Skills Details
Extensive SQL experience in writing complex queries across multiple tables from scratch.
Source to target mapping within a Data Warehousing / ETL environment.
Data Profiling experience - Understanding the relationships of data sources and producing business requirements from that data.
Business analysis background, and ability to use SQL as far as writing queries.
For analysis background- they deal with text files and making that data and landing it into the warehouse.
Working with data coming from multiple sources. When they bring the data in they have a standard model. They have to conform data from various sources into this one data model.
Additional Skills & Qualifications : Strong communication skills. Needs to have strong understand of business requirements.
Ability to write business samples / rules and transformation documents. Ability to take on more than one project at once.
Good understanding and knowledge of healthcare industry is preferred, but not required.
Environment :
Teradata & SQL Server Database
- Data Stage ETL w / Homegrown SQL / ETL tools
- SSIS & Tableau for reporting
Business System Analyst EIM Data Warehouse
Our client is seeking a Business System Analyst - EIM / Data Warehouse who creates Business Requirement Documents, Functional Requirement Documents and Mapping documents for the development of ETL applications. Title: Business System Analyst EIM Data Warehouse. Work with various stakeholders, ...
Sr. Business System Analyst
Business System Analyst role supports the Business by working with Business Management, Subject Matter Experts, Product Owners, Project Managers, Technical Leads and Developers to provide Business Needs Analysis, Requirements elicitation, Requirements elaboration and Use Case/Story developmentWhat y...
Sales Enablement Business Systems Analyst
The Sales Enablement Business Systems Analyst (BSA) supports the organization by gaining expert knowledge of NewLane’s critical business processes and aiding in the design, development, and daily operation of the origination and servicing ecosystem. Through the understanding of business goals and le...
Business Systems Analyst
With your blend of business knowledge, technical capabilities, and business analytical skills, you will successfully partner with business units, software developers and management to successfully integrate business process, business rules & business data with technology to meet business requirement...
Business Systems Analyst (Pennsylvania)
Uses regular judgement and discretion to collaborate with customers in order to: Understand capability needs; Gather project specifications; Create business cases and cost sheet analysis; Translate high-level business needs into detailed requirements for new capabilities (and change request/enhancem...
Sr. Inter-Plan Business Systems Analyst
Work with business partners to identify business systems requirements and develop business solutions working closely with internal IT and/or external vendors. Ability to work with multiple business system platforms and have an extensive understanding of business process and system design. Inter-Plan...
Business System Analyst
Business process modeling, data modeling and database design, Documentation and report writingMicrosoft Office Suite, SQL, Visio, Power BI, Python, JIRA, SharepointSecondary Skills- SSiS, SSRS, Tableau-This is a Technical BA role driven by datawarehousing and SQL WITH BA Business Systems Analyst rol...
Business Systems Analyst
Title: Business Systems Analyst. This position requires - years' experience in creating Business Requirement Documents, Functional Requirement Documents and Mapping documents for the development of ETL applications. The ideal candidate should have all the above skillsets at an expert level along wit...
Business Systems Analyst
Formulate and define scope (requirements) and objective based on user needs and thorough understanding of business processes. Evaluates/researches business problems and their relationship to technology. Identifies process, technology and organizational role changes necessary to support business goal...
Business System Analyst
Title: Business Systems Analyst. Collaborate with various teams to gather and analyze business requirements for data migration. Take initiative and work with key stakeholders while continuously improving new Knowledge Management system. Provide training and support to business users on how to use ma...