Business Intelligence Engineer
15 days ago
New York
Role Overview \n The Analytics Engineer will own the development and maintenance of curated datasets, dimensional data models, dashboards, reports, and self-service analytics solutions across financial and operational workflows. This role partners with business stakeholders, Data Engineers, Data Architects, and Business Analysts to translate requirements into reliable, accurate, and scalable data products using Snowflake, Sigma Computing, and SQL. \n Key Responsibilities \n\n • Design, develop, and maintain scalable data models, curated datasets, dashboards, reports, and analytical applications.\n, • Build interactive Sigma Computing workbooks that support KPI monitoring, variance analysis, ad hoc reporting, and self-service data exploration.\n, • Develop reusable reporting components and analytical data models in Snowflake and Sigma using dimensional modeling practices.\n, • Design and maintain fact tables, dimension tables, views, semantic models, and curated analytical data layers.\n, • Define data grain, table relationships, hierarchies, calculated fields, standardized metrics, and reporting logic.\n, • Translate business requirements into logical and physical data models, datasets, visualizations, dashboards, and analytical solutions.\n, • Develop and maintain Sigma formulas, calculations, parameters, controls, and data transformations.\n, • Write, optimize, and maintain SQL queries using joins, aggregations, subqueries, common table expressions (CTEs), and window functions.\n, • Partner with Data Engineering and Data Architecture teams to understand source systems, data pipelines, transformation logic, warehouse structures, and downstream dependencies.\n, • Contribute to data architecture patterns connecting source applications, Snowflake, and business intelligence platforms.\n, • Perform data validation, reconciliation, variance analysis, and troubleshooting across source systems, warehouse models, and reporting applications.\n, • Develop data-quality checks, reporting controls, testing procedures, and validation processes to improve data accuracy and reliability.\n, • Support analytics solution deployment, documentation, access management, maintenance, and ongoing production enhancements.\n, • Monitor data model, SQL query, dashboard, and workbook performance; identify opportunities to improve scalability, efficiency, and usability.\n, • Support data governance initiatives involving access controls, certified datasets, documentation, data lineage, and standardized metric definitions.\n, • Participate in technical reviews, solution design sessions, architecture discussions, and cross-functional planning.\n, • Establish and maintain development standards for naming conventions, reusable logic, documentation, testing, and quality assurance.\n, • Support reporting and analytics related to financing activity, debt structures, credit facilities, capital allocation, liquidity, portfolio exposure, financial performance, and management reporting.\n\n Core Qualifications & Requirements \n\n • 1–3 years of professional experience in analytics engineering, business intelligence, data analytics, or a related discipline.\n, • Hands-on experience developing data models, dashboards, reports, or analytical applications using Sigma Computing or a comparable modern BI platform.\n, • Experience with Snowflake or another cloud-based data warehouse.\n, • Strong SQL skills, including joins, aggregations, subqueries, common table expressions (CTEs), and window functions.\n, • Understanding of dimensional data modeling, including fact tables, dimension tables, data grain, star schemas, relationships, and reporting layers.\n, • Foundational knowledge of data architecture, including source systems, transformation layers, curated datasets, semantic models, and downstream reporting.\n, • Ability to convert business requirements into clearly defined metrics, data models, visualizations, dashboards, and analytical products.\n, • Experience partnering with Data Engineering or Data Architecture teams to understand source data, resolve data-quality issues, and support end-to-end data solutions.\n, • Strong analytical, critical-thinking, troubleshooting, and problem-solving skills, particularly when investigating data discrepancies and reporting inconsistencies.\n, • Exceptional attention to detail and commitment to data accuracy, consistency, and reliability.\n, • Strong written and verbal communication skills, with the ability to explain technical concepts to technical and non-technical audiences.\n, • Ability to manage competing priorities and collaborate effectively in a cross-functional environment.\n, • Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Finance, or a related discipline, or equivalent practical experience.\n\n Nice-to-Have Qualifications \n\n • Experience developing directly against Snowflake data sources within Sigma Computing.\n, • Experience designing and maintaining Snowflake tables, views, schemas, and curated analytical datasets.\n, • Familiarity with dbt, Airflow, DataHub, or comparable data transformation, orchestration, and metadata management technologies.\n, • Understanding of modern data architecture, semantic layers, data pipelines, and governed self-service analytics.\n, • Exposure to Power BI, Tableau, Looker, or other business intelligence and data visualization platforms.\n, • Familiarity with AWS or another major cloud infrastructure provider.\n, • Experience with Git or another version-control system.\n, • Knowledge of data governance, data lineage, role-based access controls (RBAC), reporting standards, and certified data sources.\n, • Exposure to financial services, investment management, institutional finance, private markets, or real estate-related operations.\n, • Familiarity with financing arrangements, debt instruments, credit facilities, liquidity analysis, interest calculations, maturity schedules, or portfolio reporting.\n\n Core Technical Skills \n\n • Analytics Engineering & BI: Analytics engineering, business intelligence (BI), data analytics, reporting, dashboards, self-service analytics, Sigma Computing, Sigma workbooks, Power BI, Tableau, Looker\n, • Data Warehousing & Modeling: Snowflake, cloud data warehouses, dimensional modeling, star schemas, fact tables, dimension tables, data grain, semantic models, curated datasets\n, • Programming & Transformation: SQL, joins, aggregations, subqueries, common table expressions (CTEs), window functions, Sigma formulas, parameters, controls, transformations\n, • Data Architecture & Governance: Source systems, data pipelines, transformation layers, data architecture, data lineage, data quality, reconciliation, certified datasets, role-based access controls (RBAC)\n, • Supporting Technologies: dbt, Airflow, DataHub, AWS, Git, version control\n\n