Sr Data Warehousing BA

Remote • Posted 3 hours ago • Updated 3 hours ago

Contract Independent

Contract W2

Contract Corp To Corp

Remote

Depends on Experience

Dia Software Solutions

Fitment

Dice Job Match Score™

🧠 Analyzing your skills...

Job Details

Skills

medium to large information technology environment as a System Analyst
Business Analyst
data extracts
data driven applications
mainframe systems (IMS COBOL files JCL batch processes)
harePoint
cloud data platforms (Azure AWS Databrick Snowflake ).
interpret data models
data dictionaries
technical documentation
database structures and theories
enterprise information management processes and methodologies
relational database management systems
and metadata management
federal laws and regulations (PII)
relevant to data management and data governance
fast-paced and ever-changing environments
master data
metadata
reference data
data warehousing
and business intelligence principles and process
including technical architecture
data focused projects
like moving from Legacy to newer systems.
data processing

Summary

Hi,

Greetings from DIA SOFTWARE SOLUTIONS LLC!

We reaching out about an exciting Direct client opportunity with one of our clients. Please review the requirements and let me know if you are interested in this position?

Direct client Req:: Need Sr Data Warehousing BA Remote ,TX

PLEASE SEND THE RESUMES TO SKUMAR AT DIASOFTWARESOLUTIONS DOT COM !

Job Description:

Major responsibilities include conducting detailed sessions with business stakeholders to understand reporting needs, data extract requirements, and downstream data consumption patterns. Document current state reporting logic, data sources, extract schedules, and dependencies within the mainframe IMS environment. Analyze gaps between current state mainframe processes and future state cloud or data lake architecture. Translate business requirements into clear functional and technical specifications for development teams. Validate requirements with stakeholders to ensure accuracy and alignment with business objectives.

Other responsibilities may include coordination and overseeing the analysis, designs, plans, diagrams, and verifying procedures for existing and proposed applications. Provides technical advice, assistance, and recommendations in matters related to reports development.

Essential Job Duties

Review and interpret mainframe IMS data structures, file layouts, and extract processes.
Collaborate with data engineers and architects to map legacy data elements to cloud based data models.
Support the design of new reporting and extract workflows that leverage cloud capabilities.
Assist in defining data transformation rules, metadata, and data lineage documentation.
Ensure reporting and extract requirements align with enterprise data governance standards.
Work closely with project managers, developers, QA teams, and business units to ensure requirements are understood and implemented correctly.
Provide subject matter expertise on reporting logic, data dependencies, and extract processes throughout the project lifecycle.
Facilitate Joint Application Development (JAD) sessions and stakeholder interviews, and document both business and technical requirements in a clear, comprehensive, and actionable format.
Elicit and document data & reporting requirements (KPIs, filters, delivery cadence) and translate into functional/data specifications.
Communicate progress, risks, and issues clearly to project leadership.
Produce and maintain mappings, business rules, data dictionaries, and lineage/data flow diagrams spanning staging, integration, and presentation/reporting layers.
Develop test cases and acceptance criteria for reporting and extract functionality.
Support user acceptance testing (UAT) by validating data accuracy, report outputs, and extract completeness.
Troubleshoot defects and work with technical teams to resolve issues.

SKILLS MATRIX

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.
Actual Years Experience	Years Experience Needed	Required/ Preferred	Skills/Experience
	6	Required	Experience working in a medium to large information technology environment as a System Analyst, Business Analyst, or similar role.
	3	Required	Strong experience gathering and documenting requirements for reporting, data extracts, or data driven applications
	3	Required	Familiarity with mainframe systems (IMS, COBOL files, JCL, batch processes)
	5	Required	Skill with Microsoft Office tools, particularly with Word, Excel, PowerPoint, Visio, and SharePoint
	3	Required	Understanding of cloud data platforms (Azure, AWS, Databricks, Snowflake, or similar).
	3	Required	Ability to interpret data models, data dictionaries, and technical documentation
	2	Required	Knowledge of database structures and theories
	2	Required	Knowledge of enterprise information management processes and methodologies, relational database management systems, and metadata management
	2	Required	Knowledge of local, state, and federal laws and regulations (PII) relevant to data management and data governance
	2	Required	Experience in working in fast-paced and ever-changing environments; achieving project s deliverables and deadlines; exercising sound judgment in making critical decisions; analyzing complex information and developing plans to address identified issues.
	2	Required	Skill in interpersonal relationships, including the ability to work with people under pressure, negotiate among multiple parties, resolve conflicts, and establish and maintain effective working relationships with various levels of personnel
	2	Preferred	Knowledge of master data, metadata, reference data, data warehousing, and business intelligence principles and process, including technical architecture
	2	Preferred	Experience in data focused projects, like moving from Legacy to newer systems.
	2	Preferred	Graduation from an accredited four-year college or university with major coursework in data processing, computer science, business administration, or a related field.

DIA SOFTWARE SOLUTIONS LLC.

Austin, TX 78727| Direct:

DIA SOFTWARE SOLUTIONS is an Affirmative Action/Equal Opportunity Employer that supports workplace diversity. All employment decisions are made without regard to race, color, religion, sex, national origin, age, disability, veteran status, marital or family status, sexual orientation, gender identity, or genetic information. All Dia soft staff must be able to demonstrate the legal right to work in the United States. DIA SOFTWARE SOLUTIONS is an E-Verify employer

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 91162472
Position Id: 8894109
Posted 3 hours ago

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

It looks like there aren't any Similar Jobs for this job yet.

Search all similar jobs