Lorven Technologies
Business System Analyst with ETL
Lorven Technologies, Elkins Park, Pennsylvania, United States, 19027
Job Title: Business System Analyst with ETL Job Location: Philadelphia, PA Job Type: Contract 12 Months (C2C/W2) Primary Skill Requirements gathering and analysis, Data analysis and interpretation. Business process modeling, data modeling and database design, Documentation and report writing Microsoft Office Suite, SQL, Visio, Power BI, Python, JIRA, Sharepoint Secondary Skills SSiS, SSRS, Tableau-This is a Technical BA role driven by datawarehousing and SQL WITH BA skills. The Business Systems Analyst role on the BTS Data Warehouse team requires experience in creating Business Requirement Documents, Functional 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. The ideal candidate should have all of the above skills at expert level along with strong verbal and written communication skills to work with various stakeholders, gather and formulate business requirements and translate the same to the technical team. Candidate with prior healthcare and data warehousing experience are preferred. The Business Systems Analyst role will also be required to support testing and production releases. This may include weekend and off hours support. Candidate must be local and available for a face-face interview. Description: Extensive experience in multiple and diverse environments and applications. Knowledge and experience in all major functions, issues and considerations of the subject matter. Resource has played a leadership role in establishing standards, policies strategy and best practice. Ability to discuss industry and marketplace trends and directions and site relevant case studies. Resource has had an influence on wide or high-impact decisions and initiatives and has a theoretical background and understanding of the subject matter. Capable of managing diverse and complex suite of projects simultaneously. Experience managing cross-functional projects/project teams. Candidate must be local and available for a face-face interview. Description: Extensive experience in multiple and diverse environments and applications. Knowledge and experience in all major functions, issues and considerations of the subject matter. Resource has played a leadership role in establishing standards, policies strategy and best practice. Ability to discuss industry and marketplace trends and directions and site relevant case studies. Resource has had an influence on wide or high-impact decisions and initiatives and has a theoretical background and understanding of the subject matter. Capable of managing diverse and complex suite of projects simultaneously. Experience managing cross-functional projects/project teams.