LanceSoft is hiring: Business Analyst 3 / Data Analyst in Texas City

Business analysis experience with a focus on data modeling and data flow for software development projects; including the preparation of project related documentation, data model and data flow documentation. Strong interpersonal, collaborative, analytical, written/verbal/
presentation communication skills in English (specifically
technical writing); and well versed with MS Office suite of
products and prototyping/screen mock-up tools such as Visio and SnagIt. Hands-on requirements elicitation; client management and
technical documentation including traceability, use cases,
prototyping, and data modeling. Facilitating analysis of business and functional requirements and design of technology specifications, working with business /
functional personnel.
Experience working with ETL/ELT teams and artifacts (SSIS, ADF, and/or Informatica): reading/writing S2T specs, documenting transformations, validating loads. Strong analysis experience and expertise in assessing Production Support issues related to system and/or data bridges to determine Root Cause and document items needed for data or system correction. Developing/maintaining an understanding of key business drivers/impacts, assisting clients with identifying and solving business-related system and data errors. Facilitating analysis of business and functional requirements and design of technology specifications, working with business /
functional personnel. Defining functional design and systems specifications; preparing/reviewing/delivering completed packages. Advanced SQL proficiency (SQL Server and/or Oracle) for profiling, validation, and reconciliation; fluency with ERD/relational modeling, normalization, keys, indexing. Participating in and providing guidance to Business and
Functional Units in developing and completing user acceptance
testing, training, and implementation-related activities. Strong technical writing skills and proficiency with Visio/diagramming; experience maintaining auditable artifacts in SharePoint/Confluence/Azure DevOps. Experience SQL, including MS SQL Server; SSIS and .Net development environments; Azure DevOps; Oracle; and analysis of data bridges. Familiarity with mainframe environments, including hierarchical databases and their limitations; relational databases; Informatica, MuleSoft, COBOL, Java, Salesforce, Snowflake and GoAnywhere. Experience with process improvement strategies and
methodologies. Proven ability to lead change and design more efficient
processes. Experience in Oil and Gas industry as well as general
compliance and enforcement related projects as a Business
Analyst with a focus on data, databases, and data bridges. Proven ability to work compatibly within multifaceted teams;
resolve conflict; and deal with challenging situations. Bachelor's Degree in Computer Science, Business
Administration or related discipline or equivalent work
experience.