Senior ETL/ Data Wаrehouse Developer

A custom development company, MentorMate is a design and software powerhouse with mature and established practices in Enterprise Web & Mobile Development, Technical Architecture, Human-Centered Design, Cloud & DevOps, Advanced-Data Мanagement & Analytics. We are looking to hire a Senior ETL/ Data Wаrehouse Developer for our Data & Analytics Center of Excellence (DCOE).

As a Senior ETL/ Data Wаrehouse Developer in DCOE, your primary goal will be to offer non-standard solutions and unlock the potential of our clients. You will be responsible for developing scalable and high-performance reporting solutions and determining appropriate applications for data processing, storing, analysis and visualization.

Responsibilities

• Analyze, design, and architect big data solutions to support business needs
• Design and architect database back-end as well as web services to interface with external applications
• Design business intelligence reporting applications and dashboards
• Identify data quality issues through data profiling and analysis
• Perform optimization and tuning on queries, stored procedures, and caching as necessary
• Make recommendations about platform and technology adoption
• Ensure that the technical strategies, standards, and practices are correctly applied
• Work with the latest development and server technologies from Microsoft, Amazon, and Apache
• Review and analyze business requirements and provide a technical perspective on approach, risk, and estimated development time
• Day-to-day communication with client team members, expert personnel, and subject matter experts
• Participate in rapid, prototype-based design sessions

Requirements

• 5+ years of hands-on ETL
• 5+ years of hands-on database design, modeling, data mart, and data warehouse architecture for business intelligence solutions
• 3+ years of hands-on in one or more of the following: SQL/ Python/ Scala
• In-depth knowledge of any popular database and data warehouse technologies from SQL & NoSQL realm - Redshift, DynamoDB, Oracle, Azure Synapse Analytics, MS SQL Server, PostgreSQL, Snowflake, MongoDB, Cassandra, etc.
• Strong knowledge of systems development, including system development life cycle, project management approaches and requirements, design and testing techniques
• Ability to think strategically and demonstrate analytical and problem-solving skills
• Ability to adapt to and learn new technologies and concepts
• Fluent in English

A significant advantage would be an experience with

• Data lake design, profiling, and conceptual modeling
• Amazon Web Services (AWS Athena, AWS Lambda, Glue, Kinesis, DMS, S3, DynamoDB, RDS, EMR, Redshift, EC2)
• Azure Business Intelligence Services (Power BI, Power BI Embedded, Azure Analysis Services, Azure Synapse Analytics)
• Azure Big Data Services (HDInsight, Data Lake Analytics, Data Lake Store)
• Databricks and/or Apache Spark
• Hadoop ecosystem

We offer

• Remote Work Model: Freedom to be based anywhere in the world
• Global Tech Community: Work in a global team using the latest technologies
• Exciting Career Prospects: Enterprise projects that set standards and save lives
• Competitive Pay: Feel satisfied with the negotiated terms
• No Intermediaries: Direct communication with our teams
• Personal Assistance: Support with administrative, financial, etc. issues