Lenora Systems IncRemote
Analytics Engineer
United States
Full-time
5 hours ago
$140,000 - $150,000 USD
H1B Sponsor Likely
Key skills
SQLData EngineeringAnalyticsBIPower BISnowflakedbt
About this role
Lenora Systems Inc is seeking an Analytics Engineer who will bridge data engineering and analytics by refactoring existing data models and designing analytics-ready tables. The role focuses on enabling migration of reports and dashboards to Power BI and supporting enterprise self-service analytics.
Responsibilities:
- Advanced SQL for complex transformations, aggregations, and performance tuning
- Strong dimensional data modeling (fact & dimension design)
- Hands-on experience with Snowflake cloud data warehouse
- Experience building and maintaining models using dbt (testing & documentation)
- Ability to refactor analytical datasets for reporting/dashboard migrations
- Support enterprise BI platforms, preferably Power BI (semantic model alignment)
Requirements:
- Advanced SQL for complex transformations, aggregations, and performance tuning
- Strong dimensional data modeling (fact & dimension design)
- Hands-on experience with Snowflake cloud data warehouse
- Experience building and maintaining models using dbt (testing & documentation)
- Ability to refactor analytical datasets for reporting/dashboard migrations
- Support enterprise BI platforms, preferably Power BI (semantic model alignment)