Senior Business Data Analyst

Neos Consulting; Austin (TX); Remote; USD 100,000 - 130,000; Full time

Job summary

A consulting firm is seeking a Senior Business Data Analyst in Austin, TX. The role focuses on data analysis and documentation to support technology modernization initiatives. Candidates must have at least 10 years of experience in business analysis, strong SQL proficiency, and excellent communication skills. This position offers a unique opportunity to work on impactful projects under limited supervision.

Qualifications

• 10+ years of business analysis experience with a focus on data modeling.
• 10+ years of strong analytical and communication skills.
• 10+ years of hands-on requirements elicitation.
• 10+ years of experience working with ETL/ELT teams.
• 10+ years of advanced SQL proficiency.

Responsibilities

• Perform advanced data analysis and documentation for modernization initiatives.
• Collaborate with product owners and reporting teams to translate business needs.
• Document source-to-target transformations and define data quality controls.

Skills

Business analysis experience focusing on data modeling

Strong analytical communication

Hands-on requirements elicitation

Experience with ETL/ELT teams

Advanced SQL proficiency

Technical writing skills

Education

Bachelor’s Degree in Computer Science, Business Administration or related discipline

Tools

MS SQL Server

SSIS

Azure DevOps

Job description

City : Austin

State : Texas

Neos is Seeking an Sr. Business Data Analyst for a contract role for with our client in Austin, TX.

***REMOTE- ONLY CANDIDATES CURRENTLY RESIDING IN THE U.S. WILL BE CONSIDERED***

No calls, no emails, please respond directly to the “apply” link with your resume and contact details.

Job Description

A senior Data Analyst to perform highly advanced (senior-level) data analysis and documentation supporting the agency’s Technology Modernization initiatives (including Mainframe Transformation and LoneSTAR). Work is data-centric: profiling and mapping data, documenting source-to-target (S2T) transformations, analyzing root causes of data defects, defining data quality controls, and creating dataflow/lineage documentation across SQL Server, Oracle, and mainframe/legacy sources.

The analyst collaborates with product owners, SMEs, DBAs, ETL engineers (SSIS/ADF/Informatica), and reporting teams (Power BI/SSRS) to translate business needs into requirements, specifications, and testable acceptance criteria, ensure accurate and timely extracts/loads, and support audit-ready reporting. Work is performed under limited supervision with considerable latitude for initiative and independent judgment.

This position will be responsible for data analysis and documentation in the implementation of multiple inter-related projects (including implementation of software applications in Software as a Service (SaaS) or Commercial off the Shelf (COTS), migration of data from the mainframe to the new systems and building a Data Warehouse). Assessment of existing Mainframe Transformation business analysis processes, implementation of any necessary improvements to these processes, and monitoring/enforcement of the processes to ensure deliverables and materials are produced and maintained in accordance with newly established processes and procedures, are of consistent quality, and use accepted business analysis methodologies. Make assignments and tracks work of other team members or completes individual assignments as needed. Works under limited supervision, with considerable latitude for the use of initiative and independent judgment.

Candidate Skills and Qualifications

Minimum Requirements:

Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.

• 10+ years required: 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.
• 10+ years required: 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.
• 10+ years required: Hands-on requirements elicitation; client management and technical documentation including traceability, use cases, prototyping, and data modeling.
• 10+ years required: Facilitating analysis of business and functional requirements and design of technology specifications, working with business/functional personnel.
• 10+ years required: Experience working with ETL/ELT teams and artifacts (SSIS, ADF, and/or Informatica): reading/writing S2T specs, documenting transformations, validating loads.
• 10+ years required: 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.
• 10+ years required: Developing/maintaining an understanding of key business drivers/impacts, assisting clients with identifying and solving business-related system and data errors.
• 10+ years required: Facilitating analysis of business and functional requirements and design of technology specifications, working with business/functional personnel.
• 10+ years required: Defining functional design and systems specifications; preparing/reviewing/delivering completed packages.
• 10+ years required: Advanced SQL proficiency (SQL Server and/or Oracle) for profiling, validation, and reconciliation; fluency with ERD/relational modeling, normalization, keys, indexing.
• 10+ years required: Participating in and providing guidance to Business and Functional Units in developing and completing user acceptance testing, training, and implementation-related activities.
• 4+ years required: Strong technical writing skills and proficiency with Visio/diagramming; experience maintaining auditable artifacts in SharePoint/Confluence/Azure DevOps.
• 4+ years required: Experience SQL, including MS SQL Server; SSIS and .Net development environments; Azure DevOps; Oracle; and analysis of data bridges.

Preferred:

• 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.

DICE

LI-CK