Senior Analytics / Data Engineer

Mercury Development, Remote
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.
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
Apply