Location: New York,NY, USA
Are you looking for a role that motivates and challenges you? Are you ready for an opportunity for growth? Do you want to work on teams where people roll up their sleeves to take on tough problems together, and regularly blow the doors off our clients with their outstanding teamwork? If you answered yes to those questions, 3Cloud might just be for you!At 3Cloud, we hire people who aren't afraid to experiment or fail. We hire people who are willing to give direct and candid feedback to their managers, leaders, and team members. We hire people who jump at those opportunities because they care about our collective growth and success. We hire people who challenge and hold each other accountable for living 3Cloud's core values because they know that it will result in amazing experiences and solutions for our clients and each other. As a consultant in the Data and Analytics Practice you will be responsible for delivering quality solutions using the Microsoft's Azure suite of tools, focusing specifically on the Synapse ecosystem. This is a senior position with extensive experience in data engineering and development, focused on database technologies, with specific experience with Azure Synapse. You will use your experience creating and optimizing star schema models in a dedicated SQL pool on Synapse to create effective structures to ingest data for analysis. You will also work with Table Distribution and Index types and understand partitioning strategies to update large tables. You will also use PolicyBase and Azure Data Factory to help ingest data. Your experience with Synapse Dynamic Management Views will help you to monitor and manage Azure Synapse Analytics. If you are an individual who is highly interested in Azure and Databricks technologies, you may be just who we are looking for to join our team.Responsibilities Understand Azure Synapse Analytics architectureBe able to identify performance bottlenecksMonitor Azure Synapse Analytics using Dynamic Management ViewsBuild performing data with Table Distribution and Index typesPartition tables using partitioning strategyCreating and optimizing star schema models in a Dedicated SQL PoolConfigure and manage workload classification and resource classesBuild ingestion pipelines with PolyBase and ADF to load and export data (best practices) Qualifications Bachelor's Degree desired in Computer Science, Information Technology, or related fieldMinimum of 5 years of experience with database design, at least 2 years with Azure technologies, and previous Consulting experienceAdvanced knowledge of SQL, including ability to write stored procedures, triggers, analytic functions, and tuningKnowledge of relational and dimensional database structures, theories, principles, and practiceExpertise in working with Synapse and related technologies Professional Skills: Eagerness to contribute in a team-oriented environmentDesire to work in an information systems environmentExcellent communication (written and oral) and interpersonal skills for both technical and non-technical teamsPassionate about learning new technologiesAnalytical approach to problem-solving; ability to use technology to solve business problemsAbility to work in a fast-paced environment Additional Preferred Experience: Predictive, Prescription, and Descriptive Analytics using Data Science tools and technologies including Azure ML Studio/Services, R programming languageOther Azure development expertise including Azure Databricks, Python, Scala, ROther Azure technologies including storage (DataLake, DeltaLake, Blob Storage)Knowledge of relational and dimensional database structures, theories, principles, and practiceCertifications are a plus Full-time employment Remote in Philippines Don't meet every single requirement?At 3Cloud we are dedicated to building a diverse, inclusive and authentic workplace, so if you're excited about this role but your past experience doesn't align perfectly with every qualification in the job description, we encourage you to apply anyway.At this time, we cannot sponsor applicants for work visas.