Business Analyst Sql R Python Jobs in Round Rock, TX

Business Analyst

Southern Regional Council of Carpenters

About the Role

The Business Analyst is a member of the Southern Regional Council of Carpenters' analytical and decision-support function, assigned to a department operationally while reporting to the Chief Project Manager. The role translates departmental needs into clear requirements, process improvements, and analytical deliverables. The Business Analyst partners with department leadership and the Chief Project Manager to scope initiatives, align work with Council priorities, and ensure solutions deliver measurable value.

This is not a reporting-only role. The Business Analyst is expected to understand operations, define requirements, document processes, support project execution, and ensure analytical work answers real business questions. While assigned to a department, the role remains part of the Council's centralized analytical and project execution function and follows the documentation, reporting, and methodological standards established by the Chief Project Manager.

What You Will Do

Needs analysis. Elicit, analyze, and prioritize business needs and operational pain points. Translate vague business requests into scoped, actionable work with defined deliverables.

Requirements and documentation. Decompose high-level goals into functional requirements, workflow specifications, and analytical deliverables.

Process mapping. Document As-Is processes and design To-Be processes that reduce administrative burden, improve accuracy, and enhance transparency.

KPI and metric ownership. Define, document, and maintain key performance indicators and operational metrics for the assigned department in coordination with the Chief Project Manager. Ensure consistent definitions across time and across the Council's reporting environment.

Reporting and analysis. Produce reports, dashboards, and analyses that support department operations and contribute to executive-level reporting. Maintain clear documentation showing how reported figures are calculated, sourced, and updated.

Project execution support. Support scoping, planning, and risk and issue management. Track deliverables and decisions, surface blockers early, and keep the Chief Project Manager informed of status and risk.

Change management and adoption. Draft communications, job aids, and standard operating procedures that support adoption of new processes, metric definitions, and tools.

Post-implementation review. Measure outcomes against defined success criteria. Assess adoption, identify opportunities for improvement, and produce executive-ready summaries of value realized and next steps.

What You Bring

Minimum Qualifications. Qualified candidates should be able to:

• Gather business needs from nontechnical stakeholders
• Document processes, requirements, and decisions clearly in writing
• Analyze operational information and communicate findings in plain language
• Use Microsoft Excel at an intermediate level or higher, including structured tables, formulas, filtering, basic pivot tables, and data validation
• Learn Council source systems and analytical tools relevant to the assigned department

Traits

• Holds the line on methodology when leadership pushes back, and revises it when the evidence requires
• Names what is not yet known and proposes how to find out, rather than overclaiming
• Treats stakeholder disagreement as information, not as an obstacle to manage
• Delivers on present operational needs while seeing the next set of needs taking shape
• Writes for the reader, adjusting register and framing for the audience
• Collaborates effectively across a geographically dispersed analytical team

Candidates selected for in-person interviews will complete a practical exercise.

Preferred

Advanced analytical tools. Advanced Excel including Power Query and complex data modeling. Working fluency with Power BI, SQL, database design, and dashboard design.

Certifications. Preferred but not required:

• Business analysis: CBAP, CCBA, ECBA, PMI-PBA
• Project management: PMP, PMI-ACP, CSM, CSPO
• Process improvement: LSSBB, LSSGB

Relevant experience. Unionized labor organization, construction industry organization, public-sector employer, or other mission-driven institutional environment. Background in organizational change work or enterprise reporting standards.

Working Conditions

Business Analysts are housed at the local facility nearest their location. The role involves frequent travel to regional offices, jobsites, training centers, and other Council facilities. Standard business hours with occasional extended hours during executive reporting cycles and similar high-demand periods.

Compensation and Benefits

Salary range: $70,000 to $95,000, with final placement determined by locality and experience. The Council offers a generous benefits package, including health coverage, retirement contributions, and paid time off, with specifics determined at the time of offer.

Why Join Us

The United Brotherhood of Carpenters has represented working people in North America since 1881. The Council's work supports decisions that affect tens of thousands of members and their families across the South.