What are the responsibilities and job description for the Sr Analytics Engineer position 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.