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 OverviewThis 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 ResponsibilitiesDevelop and maintain analytical datasets, data models, and visualizations to support recurring financial and operational reporting needsBuild, optimize, and enhance dashboards and reports using Power BI, including DAX measures, relationships, and performance tuningDesign and implement interactive analytics applications within Sigma Computing, utilizing input forms, writeback capabilities, approval workflows, and integrations with cloud data platforms like SnowflakeCollaborate with Data Engineering teams to understand source systems, support data pipeline development, and troubleshoot data quality issuesTransform raw data into structured, fact and dimension tables, establishing data relationships, hierarchies, and business definitions in line with dimensional modeling standardsSupport financial data reconciliation and validation, resolving discrepancies across source systems, analytical datasets, and reportsAutomate data quality checks and testing procedures, maintaining thorough documentation on data lineage, model configuration, and business logicAssist in platform support, deployment, version control, access management, and adoption of analytics best practicesCore Qualifications & Requirements1 to 3 years of experience in analytics engineering, business intelligence, or related rolesPractical experience with Power BI, including semantic modeling, DAX, and report optimizationDesign and implement interactive analytics applications within Sigma ComputingStrong proficiency in SQL, with the ability to write complex queries, joins, subqueries, window functions, and CTEsHands-on knowledge of modern data warehouses like Snowflake or similar cloud platformsUnderstanding of dimensional data modeling concepts, star schemas, fact and dimension tables, and data relationshipsExperience transforming raw source data into standardized, reusable analytics datasetsAbility to coordinate with data engineering and technical teams on data pipeline supportKnowledge of financial fundamentals including general ledger structures, account classifications, and reporting requirementsEffective communication skills, capable of explaining technical solutions to both technical and non-technical stakeholdersBachelor’s degree in Computer Science, Data Analytics, Finance, or related fields; equivalent practical experience acceptableNice-to-Have QualificationsAdvanced expertise with Sigma Computing, including input tables, security controls, and workbook performance tuningExperience with data transformation frameworks like dbt, and familiarity with orchestration tools such as Airflow or DataHubExposure to enterprise data governance, metadata management, and master data managementExperience supporting financial activities such as close, consolidation, budgeting, or forecastingKnowledge of cloud infrastructure environments like AWS or Microsoft FabricFamiliarity with agile development practices and automated testing methodologiesPrior experience in finance, asset management, or other data-intensive industriesCore Technical SkillsPower BI (semantic models, DAX, relationships, security)SQL (joins, aggregations, subqueries, window functions, CTEs)Snowflake or similar cloud data warehousesSigma Computing (workbooks, input tables, security features)Dimensional data modeling (fact/dimension tables, star schema)Data transformation, ETL, and data pipeline supportVersion control systems (e.g., Git)Career ImpactThis 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 BenefitsSalary 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.