Senior Consultant - Data Architecture & Engineering
Remote - US
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 Sr. Data Engineer 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 architecture
- Be able to identify performance bottlenecks
- Monitor Azure Synapse Analytics using Dynamic Management Views
- Build performing data with Table Distribution and Index types
- Partition tables using partitioning strategy
- Creating and optimizing star schema models in a Dedicated SQL Pool
- Configure and manage workload classification and resource classes
- Build 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 field
- Minimum of 5 years âŚ
This job isn't fresh anymore!
Search Fresh JobsJob Profile
Bonus eligibility Competitive compensation Employee Assistance Program Employer premium coverage for STD and LTD Flexible work location Generous PTO Growth Opportunities Learning new technologies Medical plan options Monthly tech and home office allowance Paid leave Paid leave for birth Team-oriented environment Tech and home office allowance Three medical plan options Utilization and/or discretionary bonus Vision and dental coverage
SkillsAnalytical Analytics Azure Azure Databricks Azure Data Factory Azure Synapse Azure Synapse Analytics Azure technologies Communication Consulting Data & Analytics Data Architecture Database design Databricks Data engineering Data Factory Data ingestion Data Modeling Functions Performance Tuning Problem-solving Python R R Programming Scala SQL Synapse Teamwork
Experience5 years
EducationBachelor's Business Computer Computer Science Data Science Engineering Information Technology Related Field
TimezonesAmerica/Anchorage America/Chicago America/Denver America/Los_Angeles America/New_York Pacific/Honolulu UTC-10 UTC-5 UTC-6 UTC-7 UTC-8 UTC-9