The Power BI & Analytics Engineer will be an integral member of the Software Development team and will be responsible for developing governed semantic models, dashboards, reports, and self-service analytics solutions.
Responsibilities
Analytics Solution Design
Work with business owners and subject-matter experts to understand reporting needs, business processes, data requirements, and expected outcomes
Translate business requirements into dashboards, reports, governed semantic models, KPIs, and self-service analytics solutions
Design dimensional data models that support accurate calculations, reporting performance, usability, and future expansion
Define relationships, hierarchies, measures, calculated columns, and business logic within semantic models
Perform day-to-day administrative duties on Microsoft SQL Server instances, develop and maintain SSIS jobs and write Transact-SQL code for database management and optimization, and conduct performance tuning.
Responsibilities
Perform day-to-day administrative duties on Microsoft SQL Server instances, including backup, restore, and general troubleshooting
Develop and maintain SSIS jobs and write Transact-SQL code for database management and optimization
Conduct performance tuning to enhance database efficiency and responsiveness
Collaborate with software engineers to develop solutions using open-source PostgreSQL or other cost-effective alternatives
Participate in initiatives to modernize infrastructure, reducing reliance on SQL Server by leveraging cloud technologies
As the analytical and engineering engine behind S&P Global Market Intelligence's sales compensation function, you will convert complex commercial deal structures, multi-tier incentive plans, and governance controls into automated, audit-ready data models — building the infrastructure that makes accuracy scalable and compliance systematic.
Compensation
S&P Global states that the anticipated base salary range for this position is $70,817 to $125,091.
Responsibilities
Translate and engineer complex commercial deal structures into structured algorithmic logic and standardised business rules within the compensation calculation engine
Model and simulate the financial impact of proposed changes to compensation plans and crediting rules
Build and maintain automated reconciliation engines using Python, Alteryx, and SQL
Design and maintain governance control frameworks for manual adjustments and SOX audit documentation
Architect and maintain enterprise Power BI reporting suites
Requirements
Nice to have: B2B SaaS
Nice to have: Subscription-based sales compensation
As the operational owner of global SPIFF programs and end-to-end payee lifecycle management at S&P Global Market Intelligence, this role works at the intersection of Commercial Strategy, People Operations, and Sales Finance, ensuring every compensation event is calculated precisely, governed rigorously, and resolved with integrity.
Compensation
S&P Global states that the anticipated base salary range for this position is $70,817 to $125,091.
Responsibilities
Own end-to-end SPIFF operations
Architect and execute active payee lifecycle workflows
Own departure and offboarding precision
Conduct forensic financial investigations and resolve disputes
Serve as the operational governance and audit liaison
Requirements
Nice to have: Automated SPIFF tracking engine building
As S&P Global Market Intelligence's financial engine for sales compensation planning, you will design and run the simulation and scenario models that govern incentive spend across the global sales force — stress-testing plan structures, forecasting commission accruals, and delivering the predictive analytics that keep compensation spend aligned with divisional financial targets.
Compensation
S&P Global states that the anticipated base salary range for this position is $70,817 to $125,091.
Responsibilities
Build and execute dynamic financial forecasting models using Python (NumPy/Pandas) and advanced Excel/Power Query
Perform multi-variable stress-testing and sensitivity analyses on proposed compensation structures
Design and compute plan effectiveness metrics
Develop and maintain automated Power BI executive dashboards tracking global commission expense ratios, average realisation rates, CAC/COC ratios, and quota attainment curves
Build reusable, script-based scenario calculators using Python, SQL, and Alteryx
Provide consultative support for business intelligence tools and financial data products, managing complex client queries and troubleshooting data-related issues for financial institutions.
Responsibilities
Provide advanced client support via phone, email, and chat, resolving complex and data-intensive inquiries.
Conduct investigative client conversations to understand business needs, troubleshoot issues, and recommend effective solutions.
Act as a client advocate by identifying opportunities to improve product usability, data quality, and presentation.
Build customized Excel models, templates, and workflows using multiple datasets, including data not directly available on the platform.
Support clients in using mapping tools for mortgage, demographic, asset-level, and market analysis.
Requirements
Bachelor’s degree in Economics, Finance, Business, or a related field
Ensures the accuracy, consistency, and ethical use of data across SPDJI data assets and AI solutions, playing a pivotal role in data governance and quality management.
Responsibilities
Execute and operationalize data and AI governance frameworks, policies, and standards
Design and execute robust data quality monitoring programs
Support AI risk assessments by evaluating potential biases and unintended consequences
Participate in project intake and review processes, providing guidance on governance requirements
Serve as a governance resource and advisor to value stream SMEs
The manager in this role is accountable for designing and delivering a unified Security Master that serves as the single source of truth for security reference data across products, supporting Equities, Fixed Income, and Derivatives.
Responsibilities
Design and Maintain the Security Master
Implement robust data governance practices, including validation, auditing, and reconciliation processes
Ensure all relevant corporate actions (such as mergers, splits, and dividends) are promptly and accurately reflected in the security master
Work closely with index calculation, and client support teams to align the security master with business needs
Requirements
Professional foundation in Finance, Accounting, Business, or a related discipline
Joining the Loom Analytics team means shaping the direction of a product people genuinely love, at the intersection of product strategy, customer insight, and experimentation.
Compensation
In The United States, we have three geographic pay zones. For this role, our current base pay ranges for new hires in each zone are:
Zone A: $206,100 - $269,075
Zone B: $185,490 - $242,168
Zone C: $171,063 - $223,332
Responsibilities
Collaborate on a variety of product and business problems with a diverse set of cross-functional partners and become a trusted strategic partner through the structure and clarity of your work.
Apply technical expertise with quantitative analysis, experimentation, and the presentation of data to develop strategies for our business and help solve the business's biggest challenges.
Focus on developing hypotheses through analytical approaches, different methodologies, frameworks, and technical approaches to test them.
Define, understand, and test opportunities to improve the products and business and influence roadmaps through insights and recommendations.
Partner with cross-functional teams to inform, influence, and execute strategy decisions
Build and maintain data pipelines that extract, transform, and load live product data into research-ready formats.
Compensation
In The United States, we have three geographic pay zones. For this role, our current base pay ranges for new hires in each zone are:
Zone A: $167,400 - $218,550
Zone B: $150,660 - $196,695
Zone C: $138,942 - $181,397
Responsibilities
Build and maintain data pipelines that extract, transform, and load live product data into research-ready formats (Postgres, data lake, or analytics warehouse)
Design and optimize data models tailored to the recurring analyses behind our AI Impact Reports, DX Core 4 benchmarks, and industry-facing publications
Collaborate closely with the research and engineering teams to understand analytical requirements and translate them into scalable, reproducible data infrastructure
Ensure data quality and consistency: you care about definitions, edge cases, and making sure the same question gets the same answer every time
Support ad hoc data pulls for time-sensitive research and cross-functional requests from Sales, Customer Success, and product teams
Requirements
Nice to have: SaaS product data experience
Nice to have: Telemetry or event-driven data experience
Nice to have: Git/GitHub/GitLab/Bitbucket activity