Senior Analytics Consultant (Looker/BI)

Join phData, a remote-first data and AI consultancy company with employees across the United States, Latin America, and India. We partner with industry leaders, including Snowflake, AWS, Anthropic, Glean, and dbt, to solve the complex data and AI challenges that slow large enterprises. We're growing fast, and we give our people real ownership over their work. We hire top performers and trust them to deliver results. Why phData? • Snowflake Implementation Partner of the Year — 7 consecutive years, and 2026 Snowflake AI Partner of the Year • AWS Premier Tier Services Partner — the highest tier of recognition in the AWS Partner Network • 2025 Fivetran Partner of the Year (4th consecutive year) • 2025 dbt Labs Partner of the Year (3x winner) with Visionary partner status • 2026 KNIME Customer Excellence Partner of the Year • Preferred Partner in the Anthropic Claude Partner Network • #1 Partner in Snowflake Advanced Certifications • 600+ Expert Cloud Certifications (Sigma, AWS, Azure, Dataiku, and more) • Recognized as an award-winning workplace in the US, India and LATAM About the Role We are looking for a Senior Consultant with deep, hands-on Looker (LookML) expertise to work on enterprise BI engagements. A typical project may be a fresh Looker development build or a migration of existing reports from other platforms into Looker — in both cases delivered on a governed cloud data warehouse with row-level security. This is a developer-heavy consulting role: you will design semantic models, validate data before building, work day-to-day with Data Engineering teams, review peers' code, and communicate directly with clients. We are specifically looking for someone eager to upskill into adjacent and emerging technologies — Omni in particular — and who treats learning new tools as part of the job, not an interruption to it. Key Responsibilities • Design and build Looker semantic models end-to-end: model files, views, explores, LookML dashboards, and Looks. • Migrate legacy reports into Looker: analyze the source report, map its columns to warehouse tables, identify and document gaps, and rebuild it to standard — not pixel-copy it blindly. • Validate data before building: profile source tables in SQL for completeness, coverage, and quality so dashboards are built on verified data rather than assumptions. • Implement and maintain row-level security using Looker user attributes and access filters. • Collaborate with Data Engineering: propose column mappings, raise precise data gaps and blockers (which table, which column, what it blocks), and secure their sign-off before building — push calculations upstream to the warehouse rather than hiding logic in LookML. • Work in Looker's Git-based development workflow, including peer review of teammates' LookML. • Establish and enforce LookML standards across a team (naming, model structure, shared view libraries, review checklists). • Communicate with client stakeholders: demo work, explain trade-offs, flag risks early, and keep delivery visible sprint over sprint. • Mentor junior developers and review their work. Must-Have Skills Looker / LookML (core requirement) • Expert-level LookML: views, explores, model files, dimension/measure design, dimension groups, drill fields. • Scalable model architecture: reusable base explores and explore inheritance, shared views defined once and used across models, a clean include structure, and curated field exposure rather than surfacing everything. • Row-level security: knows how to implement RLS in Looker using user attributes and access filters. • Liquid templating: parameters, templated filters, and conditional logic for dynamic report behavior. • Caching and performance: datagroups and caching policies, persistent derived tables and when not to use them, and query performance tuning. • Looker content management: LookML dashboards vs UI dashboards, folder/permission structure, embedding basics. SQL & Data Warehousing • Strong SQL — data profiling, joins, and window functions; the habit of proving that data exists, is populated, and carries real signal before building on it. • Dimensional modeling literacy: star schemas, fact/dimension design, slowly changing dimensions and point-in-time joins, and recognizing and preventing join fan-out. • Comfortable working against a cloud data warehouse and building reports only on governed, modeled tables. Migration Experience • Delivered at least one BI migration: legacy reports (proprietary platforms, Tableau, SSRS, or similar) rebuilt in Looker against a new data model. • Comfortable with the reality of migration work: source-to-target mappings that turn out inaccurate, test and production data that differ, incomplete or poor-quality data — and the discipline to verify, document, and escalate rather than silently work around it. Consulting & Communication • Clear written and verbal communication with clients and cross-functional teams (data engineering, product, program management). • Able to state blockers precisely and distinguish hard blockers from degradations; comfortable saying "this can't be built yet, and here is exactly why." • Self-directed in ambiguous, fast-changing project environments. Good to Have • Omni — strongly preferred. Omni's modeling layer is closely related to LookML, so strong Looker skills transfer directly; it is the intended upskilling path for this role, and prior exposure is a significant plus. • Other BI platforms: Tableau, Power BI, Sigma — breadth across tools indicates the adaptability we need. • Git/GitLab fluency: branches, merge requests, peer review, resolving conflicts — Looker (and Omni) development is version-controlled. • Embedded analytics delivery: signed/SSO embedding, white-labeled reporting. • Looker API / SDK, System Activity, or admin experience (users, roles, user-attribute sync). • dbt or similar transformation-layer exposure. • AI-assisted development experience (e.g., Claude, Copilot) — our teams actively use AI tooling in delivery. • Hands-on Snowflake experience; SnowPro certification is a plus. • Looker (LookML Developer) certification. What We Value in This Role • Upskilling mindset. The explicit plan for this position is to grow from Looker into Omni and other emerging BI technologies. We want someone who has done this kind of jump before and enjoys it. • Verification over assumption. The best Looker developers here check the data before they build the tile. • Team standards over personal style. Shared view libraries and model conventions only work when everyone follows them; additive, review-friendly changes are the norm. • Ownership. Seniors here review peers' code, deploy to production, unblock juniors, and face the client. phData celebrates diversity and is committed to creating an inclusive environment for all employees. Our approach helps us to build a winning team that represents a variety of backgrounds, perspectives, and abilities. So, regardless of how your diversity expresses itself, you can find a home here at phData. We are proud to be an equal opportunity employer. We prohibit discrimination and harassment of any kind based on race, color, religion, national origin, sex (including pregnancy), sexual orientation, gender identity, gender expression, age, veteran status, genetic information, disability, or other applicable legally protected characteristics. If you would like to request an accommodation due to a disability, please contact us at People Operations.