Trellance Cooperative Holdings, Inc.
Join to apply for the Sr Analytics Engineer role at Trellance Cooperative Holdings, Inc.
Overall Responsibility Rise is hiring a Sr Analytics Engineer to design, build, and ship end-to-end analytics for s on our modern data platform (Snowflake + dbt) and own Power BI semantic models and dashboards. You’ll span data engineering (ingest/model/optimize), analytics engineering (business-ready marts), and BI (data modeling in Power BI, DAX, report development, governance), deliver production-grade solutions and enabling stakeholder teams.
Essential Functions
Lead end-to-end technical delivery: discovery to go-live; translating business needs into scalable data models, dashboards, and KPIs.
Conduct design workshops define acceptance criteria and release plans focused on measurable impact.
Develop AI-driven processes for efficient engagement delivery; contribute accelerators (dbt packages, Power BI templates) and playbooks.
Architect and implement ELT pipelines in Snowflake (LZ/Bronze/Silver/Gold); build dbt models with CI/CD, tests, and lineage.
Automate Snowflake provisioning via Terraform; enforce security and governance.
Design Power BI semantic layers: star schema, DAX, Power Query, RLS/OLS; optimize performance (DirectQuery, aggregations, composite models).
Manage Power BI Service artifacts (workspaces, pipelines, refresh strategies); define UI/UX standards and reusable components.
Deliver dashboards, enablement sessions, and documentation (data dictionaries, runbooks); coach analysts and power users.
Implement automated data quality checks, monitoring, and alerting.
And Other Duties as assigned.
Position Requirements Minimum Education/Experience: Bachelor’s degree (BA or BS) from an accredited college or university. Minimum of seven (7) years of experience in software engineering, with a minimum of three (3) years managing successful product development OR a high school diploma with a minimum of twelve (12) years of experience in software engineering.
Company / Industry Knowledge Prior experience in banking, credit unions or financial services industries is strongly preferred.
Required Qualifications
5–8+ years delivering data/BI solutions;
3–5+ years in consulting and solution architecture.
1–3+ years financial services experience (credit unions/community banks).
Expertise in dbt/dbt Cloud (modular modeling, tests, macros, CI/CD).
Power BI expert: Dimensional modeling, DAX, Power Query (M), governance, security (RLS/OLS).
Skilled in Snowflake/cloud DW: SQL performance, design, tuning.
Strong fundamentals in data modeling (Kimball/semantic), metrics design, and visualization.
Proficient in performance optimization, enterprise lifecycle practices.
Excellent communication and stakeholder management.
Exceptional communication, conflict resolution, and impediment removal skills.
Other Skills & Abilities
Financial Services expertise (core systems, lending, ALM, GL data).
Skilled in data movement (Estuary, Fivetran) and orchestration (Airflow, cloud-native).
Python for ELT utilities/testing; CI/CD with Azure DevOps & GitHub.
Knowledge of RBAC and workload separation (ETL vs BI).
Experience with metrics layers, tabular modeling (SSAS Tabular), and Power BI migration.
Adept at fostering transparency, communication, and adaptability in a fast-paced, demanding environments.
Seniority level
Associate
Employment type
Full-time
Job function
Engineering and Information Technology
#J-18808-Ljbffr
Overall Responsibility Rise is hiring a Sr Analytics Engineer to design, build, and ship end-to-end analytics for s on our modern data platform (Snowflake + dbt) and own Power BI semantic models and dashboards. You’ll span data engineering (ingest/model/optimize), analytics engineering (business-ready marts), and BI (data modeling in Power BI, DAX, report development, governance), deliver production-grade solutions and enabling stakeholder teams.
Essential Functions
Lead end-to-end technical delivery: discovery to go-live; translating business needs into scalable data models, dashboards, and KPIs.
Conduct design workshops define acceptance criteria and release plans focused on measurable impact.
Develop AI-driven processes for efficient engagement delivery; contribute accelerators (dbt packages, Power BI templates) and playbooks.
Architect and implement ELT pipelines in Snowflake (LZ/Bronze/Silver/Gold); build dbt models with CI/CD, tests, and lineage.
Automate Snowflake provisioning via Terraform; enforce security and governance.
Design Power BI semantic layers: star schema, DAX, Power Query, RLS/OLS; optimize performance (DirectQuery, aggregations, composite models).
Manage Power BI Service artifacts (workspaces, pipelines, refresh strategies); define UI/UX standards and reusable components.
Deliver dashboards, enablement sessions, and documentation (data dictionaries, runbooks); coach analysts and power users.
Implement automated data quality checks, monitoring, and alerting.
And Other Duties as assigned.
Position Requirements Minimum Education/Experience: Bachelor’s degree (BA or BS) from an accredited college or university. Minimum of seven (7) years of experience in software engineering, with a minimum of three (3) years managing successful product development OR a high school diploma with a minimum of twelve (12) years of experience in software engineering.
Company / Industry Knowledge Prior experience in banking, credit unions or financial services industries is strongly preferred.
Required Qualifications
5–8+ years delivering data/BI solutions;
3–5+ years in consulting and solution architecture.
1–3+ years financial services experience (credit unions/community banks).
Expertise in dbt/dbt Cloud (modular modeling, tests, macros, CI/CD).
Power BI expert: Dimensional modeling, DAX, Power Query (M), governance, security (RLS/OLS).
Skilled in Snowflake/cloud DW: SQL performance, design, tuning.
Strong fundamentals in data modeling (Kimball/semantic), metrics design, and visualization.
Proficient in performance optimization, enterprise lifecycle practices.
Excellent communication and stakeholder management.
Exceptional communication, conflict resolution, and impediment removal skills.
Other Skills & Abilities
Financial Services expertise (core systems, lending, ALM, GL data).
Skilled in data movement (Estuary, Fivetran) and orchestration (Airflow, cloud-native).
Python for ELT utilities/testing; CI/CD with Azure DevOps & GitHub.
Knowledge of RBAC and workload separation (ETL vs BI).
Experience with metrics layers, tabular modeling (SSAS Tabular), and Power BI migration.
Adept at fostering transparency, communication, and adaptability in a fast-paced, demanding environments.
Seniority level
Associate
Employment type
Full-time
Job function
Engineering and Information Technology
#J-18808-Ljbffr