Senior Data Engineer (Analytics)

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

Показать контакты

#analyst #engineer #remote