Senior Analytics / Data Engineer

We are currently looking for an experienced Senior Analytics / Data Engineer Mercury Development specializes in developing custom software for various US companies: from large enterprises to the tiniest startups. Our apps are used by more than 40 million people globally, and many of our products have been featured on the App Store and covered by TechCrunch, Engadget, and Gizmodo. We have over 500 highly qualified and skilled specialists working on dozens of interesting projects, based all over the world. The Project We are looking for a Senior Analytics / Data Engineer to become the primary owner of the project's analytics platform. The current platform includes: PostgreSQL (AWS RDS) DBT AWS DMS Metabase A large number of existing reports and analytical logic This is a mature project with a complex, historically accumulated data schema and substantial business logic embedded in reports. The primary goal is not just to maintain the current system, but to gradually bring the analytics layer to a more structured, transparent, and maintainable state. The Role We are looking for a hands-on senior specialist who is comfortable navigating complex legacy data environments, taking ownership of the analytics platform, and driving gradual, meaningful improvements. Responsibilities Maintain and develop existing DBT models and Python logic within the analytics platform Navigate and understand complex legacy data structures and existing reports Improve the quality and consistency of analytical data Refactor outdated or poorly maintained reports Build new data marts and dashboards in Metabase Investigate and resolve complex data issues Optimize complex SQL queries Work with PostgreSQL execution plans (EXPLAIN ANALYZE) Support and improve data replication processes Gradually build a unified metrics dictionary and shared business terminology Collaborate with a BA who assists with requirements gathering and business communication Requirements Strong hands-on experience with PostgreSQL Advanced SQL skills: Complex CTEs Window functions Query optimization Incremental approaches Experience with DBT (or ability to pick it up quickly) Experience building and maintaining BI reporting Experience with Metabase, Tableau, Power BI, or similar tools Ability to independently explore and work with complex legacy systems Strong analytical and structured thinking English proficiency for day-to-day communication Nice to Have Experience with AWS DMS Understanding of PostgreSQL replication Query tuning and index optimization Experience improving data quality Experience with Python data stack Experience building a metrics dictionary or data catalog Experience working in low-documentation environments Experience owning an analytics platform end-to-end Join us in building the future!