• Analytical Engineer

    Cotton Holdings (Houston, TX)


    Analytical Engineer

    **Department:** Information Technology

    **Employment Type:** Full Time

    **Location:** Houston, TX

    Description

    Cotton Holdings, Inc., is a diversified holding company with subsidiaries that provide property restoration and recovery, construction, roofing, logistical support, temporary workforce housing, and culinary services to public and private entities worldwide. Cotton combines this diverse suite of services with top talent, innovative technology, and a large inventory of company-owned assets, to offer clients a total solutions package in support of disaster events and large development projects, including complex work environments.

     

    Analytical Engineer – dbt | Power BI | SQL

     

    Why this role matters

     

    Our dbt project already spans ~800 models. You’ll steer its evolution—keeping code clean, metrics trustworthy, and insights flowing into Power BI for every division at Cotton Holdings.

    Key Responsibilities

    What you’ll do

    + **Own the dbt repo** : refactor models, enforce SQLFluff lint rules, and keep documentation/lineage current (Unity Catalog).

    + **Model for consumption** : design semantic layers and star/snowflake schemas that power tabular datasets in **Power BI** .

    + **Optimize & monitor** warehouse cost, refresh cadence, and query performance; surface trends to leadership.

    + **Build & teach** : craft high-impact Power BI dashboards, write DAX measures, and host workshops so business users can self-serve confidently.

    + **Partner** with Data Engineers on source-to-target mapping and with stakeholders to translate requirements into governed metrics.

     

    Skills, Knowledge and Expertise

    What you bring

    + 5+ years in analytics engineering, BI development, or data warehousing (SQL heavy).

    + Proven ownership of a **large-scale dbt** project (hundreds of models) and comfort with Git PR reviews/tests.

    + Advanced **Power BI** skills: dataset design, DAX, Tabular Editor; familiarity with other BI tools a plus.

    + Solid understanding of data governance, column-level lineage, and documentation best practices.

    + Nice-to-have certs: dbt Certified Analytics Engineer, Microsoft Power BI Data Analyst (PL-300).

     

    Disclaimer

     

    This Job Description indicates the general nature and level of work expected of the incumbent(s). It is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities required of the incumbent. Incumbent(s) may be asked to perform other duties as requested.

     

    \#commercial