Analytical Engineer

Analytical Engineer

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

About Cotton Holdings

Founded in 1996, Cotton Holdings Inc. is a leading infrastructure support services company with subsidiaries that conduct business under the Cotton USA, Cotton International, Cotton Roofing, Cotton Logistics, Cotton Culinary, OneLodge, OneTeam, Stellar Commercial Roofing, Full Circle Restoration, Target Solutions, and Advanced Catastrophe Technologies, Inc. brands. Headquartered in Katy, Texas with an International Logistics Center and regional offices throughout North America, Cotton provides property restoration and recovery, construction, roofing, consulting, workforce staffing, temporary housing and culinary services to public and private entities worldwide.