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!