Financial Data Engineer

The Company

Automattic—the global leader in publishing, messaging, and commerce software—is building the operating system for the open web. Our goal is to democratize publishing, messaging, and commerce so that anyone with a story can tell it, and anyone with a product can sell it, regardless of income, gender, politics, language, or where they live in the world. With a strong commitment to open source, we have deep roots in WordPress, the platform that powers our business and 43% of the web.

We own a diverse set of assets, deploy numerous business models, and offer scalability from B2C to SMB and Enterprise customers in a fast-paced, complex market. Our brands include WordPress.com, WooCommerce, WordPress VIP, Jetpack, Tumblr, Beeper, and a business incubator full of early-stage scale-ups.

We’re a distributed company with more than 1700 Automatticians in nearly every corner of the globe, speaking over a hundred different languages. Unlike many companies, we are and will always be 100% remote (we call it distributed). This means that you can work from anywhere in the world, in any time zone, leveraging collaboration tools and asynchronous communication.

The Opportunity

We are looking for a Financial Data Engineer to build and maintain robust data systems at our globally distributed company.

As a Financial Data Engineer, you’ll play a pivotal role in developing reliable data pipelines, analysis, and visualizations that drive financial reporting and business insights. You will collaborate closely with analytics engineers, software developers, finance teams, and other stakeholders to transform complex financial data into accessible, actionable information.

You will build and maintain ETL processes for financial data, build and maintain internal reporting tools, design metrics to illuminate business performance, and create high-quality analyses and dashboards to communicate insights broadly. Working with large datasets, you'll help ensure data quality and integrity, build and maintain reporting processes and self-service tools, and serve as a fulcrum point to help the organization leverage its financial data for high-quality decision-making.

This role requires strong SQL proficiency, programming skills, experience with data visualization tools, and a deep understanding of data warehousing concepts. Experience with finance/accounting teams and SaaS business models is valuable. Most importantly, you should be self-directed, have a bias for action, communicate effectively through written channels, and embrace continuous learning in our distributed work environment.

Responsibilities (What you will do)

• Build and maintain robust and reliable extract, transform, load (ETL) pipelines for financial data. 
• Continually improve ongoing reporting and analysis processes, automating or simplifying self-service support for customers.
• Work closely with analytics engineers, software developers, finance and accounting teams, and other business stakeholders to solve unique business problems.
• Build and deliver high-quality data solutions to support analysts, engineers, and data scientists.
• Design and build metrics/dimensions to monitor product and business performance.
• Build and maintain high-quality and reliable data visualizations/dashboards, and communicate insights broadly.
• Maintain and extend our internal tool used to report business metrics.
• Monitor and maintain the quality and integrity of financial data.

Qualifications and Experience

• Proficiency in using SQL for data extraction, wrangling, and synthesis into information (must have).
• Experience in at least one programming language (Python, Scala, Javascript, PHP)(must have).
• Expertise in telling stories with data and fluency in building with at least one data visualization tool (e.g. Looker, Superset, Tableau) (must have).
• Experience working with large datasets (must have).
• Strong understanding of data warehousing and data modeling concepts (must have).
• Experience with ETL processes and data pipeline development (must have).
• Understanding of the SaaS business model (nice to have).
• Experience in or working with finance and accounting teams, with a focus on topline metrics and revenue/revenue recognition (nice to have).
• Strong problem-solving and critical thinking abilities, with a keen attention to detail (must have).
• Experience working within a version control system (Git, Phabricator) (nice to have).
• Experience using AI tools to support and augment your own data engineering efficiency (nice to have).

Key Attributes for Success

• Self-Directed and Autonomous–Ability to manage your own time, set priorities, and deliver results without micromanagement.
• Bias for Action and Ownership–Comfortable taking initiative, solving problems proactively, and owning projects from start to finish.
• Strong Written Communication Skills–Since Automattic operates largely through text-based communication, being able to convey complex ideas clearly and concisely is crucial.
• Emphasis on Continuous Learning–A growth mindset, openness to feedback, and a drive to improve technical and soft skills.

Salary range: $90,000-$150,000 USD. Please note that salary ranges are global, regardless of location, and we pay in local currency.

We are searching for high-caliber candidates with the skills and qualities to have a net positive for Automattic. Pay will reflect the potential contribution and the impact you can bring, which may, in some cases, go beyond the range stated.

We’re pleased to offer a straightforward, competitive base salary, providing financial clarity without complex variable components. This isn’t your typical work-from-home job—we are a fully-remote company with an open vacation policy. Read more about our compensation philosophy. To see a full list of benefits by country, consult our Benefits Page. And check out these links to learn more about How We Hire and What We Expect from Ourselves.