Financial Data Engineer

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 Word Press, 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 , Woo Commerce, Word Press 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.

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.

• 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.

• Proficiency in using SQL for data extraction, wrangling, and synthesis into information (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…