3Cloud · 2 days ago

Sr. Data Engineer

United States

Full-time

Remote

Senior Level

$92K/yr - $150K/yr

5+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

Technical Support

Insider Connection @3Cloud

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

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)

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Database DesignAzure TechnologiesConsulting ExperienceSQLStored ProceduresTriggersAnalytic FunctionsTuningRelational Database StructuresDimensional Database StructuresSynapseDatabase TheoryPredictive AnalyticsPrescriptive AnalyticsDescriptive AnalyticsData ScienceAzure ML StudioAzure ML ServicesR Programming LanguageAzure DevelopmentAzure DatabricksPythonScalaDataLakeDeltaLakeBlob Storage

Required

Bachelor’s Degree desired in Computer Science, Information Technology, or related field

Minimum of 5 years of experience with database design, at least 2 years with Azure technologies, and previous Consulting experience

Advanced knowledge of SQL, including ability to write stored procedures, triggers, analytic functions, and tuning

Knowledge of relational and dimensional database structures, theories, principles, and practice

Expertise in working with Synapse and related technologies

Preferred

Predictive, Prescription, and Descriptive Analytics using Data Science tools and technologies including Azure ML Studio/Services, R programming language

Other Azure development expertise including Azure Databricks, Python, Scala, R

Other Azure technologies including storage (DataLake, DeltaLake, Blob Storage)

Knowledge of relational and dimensional database structures, theories, principles, and practice

Certifications are a plus