Analytics Engineer

An innovative financial services organization is seeking an Analytics Engineer to support their enterprise-wide analytics initiatives, focusing on data modeling, business intelligence development, and operational reporting using industry-standard BI tools. This role offers an excellent opportunity for early-career professionals to develop their expertise in analytics engineering, working closely with cross-functional teams to deliver reliable, reusable data solutions that enable strategic decision-making.

Role Overview

This Analytics Engineer will be responsible for designing, developing, and maintaining analytical datasets, interactive reports, and dashboards that support financial planning, operational insights, and business intelligence efforts. The role involves translating business requirements into scalable data models and analytics solutions, working with modern BI platforms, and collaborating with data engineering, finance, and IT teams to ensure data accuracy and consistency.

Key Responsibilities

• Develop and maintain analytical datasets, data models, and visualizations to support recurring financial and operational reporting needs
• Build, optimize, and enhance dashboards and reports using Power BI, including DAX measures, relationships, and performance tuning
• Design and implement interactive analytics applications within Sigma Computing, utilizing input forms, writeback capabilities, approval workflows, and integrations with cloud data platforms like Snowflake
• Collaborate with Data Engineering teams to understand source systems, support data pipeline development, and troubleshoot data quality issues
• Transform raw data into structured, fact and dimension tables, establishing data relationships, hierarchies, and business definitions in line with dimensional modeling standards
• Support financial data reconciliation and validation, resolving discrepancies across source systems, analytical datasets, and reports
• Automate data quality checks and testing procedures, maintaining thorough documentation on data lineage, model configuration, and business logic
• Assist in platform support, deployment, version control, access management, and adoption of analytics best practices

Core Qualifications & Requirements

• 1 to 3 years of experience in analytics engineering, business intelligence, or related roles
• Practical experience with Power BI, including semantic modeling, DAX, and report optimization
• Design and implement interactive analytics applications within Sigma Computing
• Strong proficiency in SQL, with the ability to write complex queries, joins, subqueries, window functions, and CTEs
• Hands-on knowledge of modern data warehouses like Snowflake or similar cloud platforms
• Understanding of dimensional data modeling concepts, star schemas, fact and dimension tables, and data relationships
• Experience transforming raw source data into standardized, reusable analytics datasets
• Ability to coordinate with data engineering and technical teams on data pipeline support
• Knowledge of financial fundamentals including general ledger structures, account classifications, and reporting requirements
• Effective communication skills, capable of explaining technical solutions to both technical and non-technical stakeholders
• Bachelor’s degree in Computer Science, Data Analytics, Finance, or related fields; equivalent practical experience acceptable

Nice-to-Have Qualifications

• Advanced expertise with Sigma Computing, including input tables, security controls, and workbook performance tuning
• Experience with data transformation frameworks like dbt, and familiarity with orchestration tools such as Airflow or DataHub
• Exposure to enterprise data governance, metadata management, and master data management
• Experience supporting financial activities such as close, consolidation, budgeting, or forecasting
• Knowledge of cloud infrastructure environments like AWS or Microsoft Fabric
• Familiarity with agile development practices and automated testing methodologies
• Prior experience in finance, asset management, or other data-intensive industries

Core Technical Skills

• Power BI (semantic models, DAX, relationships, security)
• SQL (joins, aggregations, subqueries, window functions, CTEs)
• Snowflake or similar cloud data warehouses
• Sigma Computing (workbooks, input tables, security features)
• Dimensional data modeling (fact/dimension tables, star schema)
• Data transformation, ETL, and data pipeline support
• Version control systems (e.g., Git)

Career Impact

This role offers significant growth potential within a leading organization committed to leveraging data analytics for strategic advantage, enabling the candidate to deepen expertise in enterprise data modeling, BI development, and financial analytics.

Compensation and Benefits

Salary range approximately $120,000 - $140,000, with potential bonus and comprehensive benefits.

Apply Today!

Candidates eager to advance their analytics career and work within a dynamic, data-driven environment are encouraged to apply now.

The Phoenix Group Advisors is an equal opportunity employer. We are committed to creating a diverse and inclusive workplace and prohibit discrimination and harassment of any kind based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. We strive to attract talented individuals from all backgrounds and provide equal employment opportunities to all employees and applicants for employment.