Senior Data Management Professional - Analytics Engineer - DMO BI

Based in New York, onsite, this role sits within Bloomberg's Business Intelligence team. You will build and evolve Foundational Reporting Datasets (FRDs) to translate complex financial data into stable analytical schemas and empower self-service analytics across the reporting platform. The position offers a salary range of USD 110,000 to 190,000 per year and requires a minimum of 4 years of experience. Bloomberg provides a comprehensive benefits package along with the opportunity to contribute to critical data products within a high-impact environment.

Responsibilities

• Build, maintain, and evolve Foundational Reporting Datasets that serve as the analytical backbone for reporting and analysis
• Write and optimize SQL queries to clean, shape, and model noisy, real-world data into performant, reusable datasets
• Write modular, version-controlled SQL and PySpark, and implement CI/CD processes and automated data testing to ensure pipeline reliability
• Design storage layouts, partitioning strategies, and high-concurrency serving patterns (like One Big Table) for BI consumers
• Implement robust source validation, data profiling, and observability checks so stakeholders have absolute trust in the data
• Make pragmatic tradeoffs around correctness, scope, performance, and documentation, reasoning about data semantics and grain
• Work closely with domain experts and stakeholders to understand how the data is produced, interpreted, and used
• Actively build domain intuition over time, learning why the data behaves the way it does, not just how it’s structured
• Represent the data accurately and confidently in cross-functional discussions
• Identify analytical work that is worth formalizing into reusable data products
• Help define clear boundaries between foundational datasets and decision-specific, reusable data products
• Partner with Product Managers to define roadmap feasibility, and work alongside Software Engineers to influence upstream tooling and architecture decisions
• Collaborate with engineers on performance, tooling, and modeling decisions, while remaining focused on the data layer itself

Requirements

• 4+ years of experience as a BI analyst, analytics engineer, or similar data-focused role
• Proven ability to turn messy, ambiguous data into trusted analytical assets
• Comfort working under ambiguity and improving things incrementally
• Strong collaboration skills and interest in learning a data domain deeply
• Ability to translate semi-structured producer data into stable analytical schemas (OLTP to OLAP)
• SQL-based data modeling
• PySpark and Pandas/Polars
• Analytical dataset design
• Performance and efficiency considerations
• Storage/layout optimization for analytical tables
• Designing for schema evolution
• Source validation and data profiling

Technologies

• SQL
• PySpark
• Pandas
• Polars
• Iceberg
• Delta
• Trino
• Spark

Benefits

• merit increases
• incentive compensation (exempt roles only)
• paid holidays
• paid time off
• medical
• dental
• vision
• short and long term disability benefits
• 401(k) + match
• life insurance
• various wellness programs

Accommodations

Bloomberg provides reasonable adjustment/accommodation to individuals with disabilities. Please tell us if you require a reasonable adjustment/accommodation to apply for a job. To request an adjustment/accommodation to apply for a job, please email [email protected].

Equal Opportunity

Bloomberg is an equal opportunity employer and prohibits discrimination in employment. It is Bloomberg’s policy to provide equal opportunity and access for all persons.