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. As a top engineering employer run by engineers, MentorMate provides challenging careers in a friendly, people-oriented environment. We value our employees and share our success through competitive pay and benefits, advancement opportunities, and flexible working models. 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 Posting Summary Job role Engineering & TechnologyData Engineering Experience Level Senior Employment Type Full - time Location SofiaPlovdivBulgaria RemoteVarnaVeliko TarnovoRuse Apply now Posting Summary Job role Engineering & TechnologyData Engineering Experience Level Senior Employment Type Full - time Location SofiaRemotePlovdivBulgaria RemoteBulgariaVarnaVeliko TarnovoRuse Apply now We offer Flexible Benefits Professional Growth Clear career path, meaningful projects, tech innovations. Regular Salary Raises Following the curve of your career path and performance. Work Where You Want Choose to work remotely, in-office, or a combination of the two. Upskilling Various trainings, knowledge sharing events, personal learning budget. Incentive Programs Rewards for referring employees, sharing knowledge, and more. Additional Insurance Attractive health and dental insurance packages. Extra Days Off The longer you work with us, the more paid leave you get. Transport & Leisure Partial coverage of transport costs, sports passes, takeaway food. Save for the Future Set a retirement plan or start an investment program. Teambuilding Enjoy team gatherings and communities of interest. Giving to Others Take part in various charity and volunteer activities. Mental Wellness Support with a counseling package if needed. Career Development Career Path We strive to provide everyone working at MentorMate with plenty of opportunities to further their career. In fact, we have an entire team dedicated to learning and development to do exactly that. To further aid in individual career growth, we developed the MentorMate Career Path to serve as a roadmap for the professional development of each team member. Moreover, it provides information about the technical and soft skill requirements for upskilling and taking the future steps of the individual professional journey within the company. The Career Path provides opportunities for people to determine their own goals based on how they want to grow and serves as a foundation and reference point for career discussions. It also cultivates a culture of proactiveness regarding personal career growth. Let’s Work Together Related job positions More opportunities in the Engineering & Technology team Windows System Administrator – Contractor Global Remote Contractor .NET Technical Lead Paraguay Paraguay Remote Full - time .NET Technical Lead Bulgaria Bulgaria Remote Full - time