Business Analyst

Senior Business Analyst (BA)

Enterprise Products req.

Locals only

Houston, TX

12 months contract

Here's a detailed job description for a Senior Business Analyst (BA) role with a strong emphasis on SQL expertise, data modeling, and cross-functional collaboration between business and data engineering teams

Job Summary:

We are seeking an experienced and highly analytical Senior Business Analyst (BA) with advanced SQL skills and a strong understanding of data modeling principles. This role acts as the key liaison between business stakeholders and the data engineering team, responsible for gathering and translating business requirements into clear, actionable data specifications. You will play a pivotal role in helping the organization make data-driven decisions by ensuring that data solutions are aligned with strategic objectives.

Key Responsibilities:

• Business Requirements Gathering: Collaborate with business units (e.g., Marketing, Finance, Operations) to identify and document their data and reporting needs.
• Stakeholder Liaison: Serve as the bridge between business teams and the data engineering group, ensuring clarity and alignment on requirements, timelines, and deliverables.
• SQL Analysis: Write complex SQL queries to explore, validate, and analyze data to support business cases, testing, and decision-making.
• Data Modeling Support: Work closely with data engineers and architects to influence and validate data models, ensuring alignment with business requirements and best practices (e.g., star/snowflake schemas, dimensional modeling).
• Documentation: Create detailed business requirement documents (BRDs), data dictionaries, entity-relationship diagrams (ERDs), and functional specifications.
• User Acceptance Testing (UAT): Design and execute test cases to ensure data deliverables meet business expectations.
• Ad Hoc Reporting: Build ad hoc reports and dashboards (using tools such as Power BI, Tableau, or Looker) to answer critical business questions.
• Continuous Improvement: Identify opportunities to improve data quality, data governance, and business processes.

Required Qualifications:

• Bachelor s degree in Business, Information Systems, Computer Science, or related field.
• 5+ years of experience as a Business Analyst, preferably in a data-centric or analytics-focused environment.
• Advanced SQL skills with ability to query large and complex datasets (e.g., joins, CTEs, window functions).
• Strong understanding of data modeling principles, including normalized/denormalized structures, dimensional modeling, and ERD design.
• Experience working with cloud data warehouses (e.g., Snowflake, Redshift, BigQuery).
• Proven ability to gather and translate business requirements into clear technical deliverables.
• Excellent communication and stakeholder management skills, with the ability to translate technical concepts into business-friendly language.

Preferred Qualifications:

• Experience in Agile/Scrum environments and working with tools like JIRA or Confluence.
• Familiarity with data cataloging and lineage tools (e.g., Alation, Collibra).
• Experience in data visualization tools (Power BI, Tableau, or similar).
• Background in finance, marketing analytics, operations, or a regulated industry (e.g., healthcare, fintech).