Job Title: Business Analyst with – Data Warehousing & BI
Location: San Antonio, TX (Onsite)
Role Objective: Serve as the bridge between business stakeholders and data engineering teams, translating business needs into technical specifications for data models, ETL pipelines, and BI solutions to deliver a trusted single source of truth.
Key Responsibilities
Requirements Engineering: Lead discovery sessions; produce FRDs and mapping documents. Source-to-Target Mapping: Define data elements, business rules, and transformations.
Data Profiling: Use SQL, Pyspark, Python to assess data quality, identify anomalies, and validate integrity.
Data Modeling: Partner with data architects on star/snowflake schemas and dimensional models. UAT Ownership: Define test cases, execute UAT, and validate outputs against business requirements.
Stakeholder Management: Manage backlog and prioritize data initiatives by ROI and impact.
Technical Skills SQL: Queries (joins, CTEs, window functions).
Data Warehousing: ETL/ELT, ADF.
BI Tools: Power BI, Looker,
Documentation: Jira, Confluence, data dictionaries, SharePoint Online.
Preferred Qualifications 5–7 years in Data Warehousing or Analytics. Strong communicator able to explain technical concepts to executives. Experience with cloud data warehouses.
This role is open to W2 or those seeking Corp-Corp employment. The salary range for this role is $100- $110k. For corp-Corp rates please contact the recruiter. In addition to other benefits, Accion Labs offers a comprehensive benefits package, with Accion covering 65% of the medical, dental, and Vision Premiums for employees, their spouses, and dependent children enrolling in the Accion-provided plans.