Senior ETL/ Data Wаrehouse Developer – Contractor 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 Posting Summary Job role Engineering & TechnologyData Engineering Experience Level Senior Employment Type Contractor Location Bulgaria RemoteGlobal Remote Apply now Posting Summary Job role Engineering & TechnologyData Engineering Experience Level Senior Employment Type Contractor Location RemoteBulgaria RemoteGlobal Remote Apply now We offer Benefits 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. 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