This job post is closed and the position is probably filled. Please do not apply. Work for 3Cloud and want to re-open this job? Use the edit link in the email when you posted the job!
\n\n\n\n \n\n\nAs 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.\n\nResponsibilities\n\n\n* Understand Azure Synapse Analytics architecture\n\n* Be able to identify performance bottlenecks\n\n* Monitor Azure Synapse Analytics using Dynamic Management Views\n\n* Build performing data with Table Distribution and Index types\n\n* Partition tables using partitioning strategy\n\n* Creating and optimizing star schema models in a Dedicated SQL Pool\n\n* Configure and manage workload classification and resource classes\n\n* Build ingestion pipelines with PolyBase and ADF to load and export data (best practices)\n\n\n\n\nQualifications\n\n\n* Bachelor’s Degree desired in Computer Science, Information Technology, or related field\n\n* Minimum of 5 years of experience with database design, at least 2 years with Azure technologies, and previous Consulting experience\n\n* Advanced knowledge of SQL, including ability to write stored procedures, triggers, analytic functions, and tuning\n\n* Knowledge of relational and dimensional database structures, theories, principles, and practice\n\n* Expertise in working with Synapse and related technologies\n\n\n\n\nProfessional Skills:\n\n\n* Eagerness to contribute in a team-oriented environment\n\n* Desire to work in an information systems environment\n\n* Excellent communication (written and oral) and interpersonal skills for both technical and non-technical teams\n\n* Passionate about learning new technologies\n\n* Analytical approach to problem-solving; ability to use technology to solve business problems\n\n* Ability to work in a fast-paced environment\n\n\n\n\nAdditional Preferred Experience:\n\n\n* Predictive, Prescription, and Descriptive Analytics using Data Science tools and technologies including Azure ML Studio/Services, R programming language\n\n* Other Azure development expertise including Azure Databricks, Python, Scala, R\n\n* Other Azure technologies including storage (DataLake, DeltaLake, Blob Storage)\n\n* Knowledge of relational and dimensional database structures, theories, principles, and practice\n\n* Certifications are a plus\n\n\n\n\n \n\nFull-time employment \n\n\n📌 Remote in USA\n\n\n \n\n\nDon’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.\n\nAt this time, we cannot sponsor applicants for work visas.\n\n\n \n\n#Salary and compensation\n
No salary data published by company so we estimated salary based on similar jobs related to Senior and Engineer jobs that are similar:\n\n
$62,500 — $115,000/year\n
\n\n#Benefits\n
💰 401(k)\n\n🌎 Distributed team\n\n⏰ Async\n\n🤓 Vision insurance\n\n🦷 Dental insurance\n\n🚑 Medical insurance\n\n🏖 Unlimited vacation\n\n🏖 Paid time off\n\n📆 4 day workweek\n\n💰 401k matching\n\n🏔 Company retreats\n\n🏬 Coworking budget\n\n📚 Learning budget\n\n💪 Free gym membership\n\n🧘 Mental wellness budget\n\n🖥 Home office budget\n\n🥧 Pay in crypto\n\n🥸 Pseudonymous\n\n💰 Profit sharing\n\n💰 Equity compensation\n\n⬜️ No whiteboard interview\n\n👀 No monitoring system\n\n🚫 No politics at work\n\n🎅 We hire old (and young)\n\n
\n\n#Location\nDowners Grove, Illinois, United States
# How do you apply?\n\nThis job post has been closed by the poster, which means they probably have enough applicants now. Please do not apply.
Frontpage
🏝 Remote jobs
🌗 Dark mode
👩💻 Hire remote workers
🚨 Post a job
⭐️ Go premium
Health insurance for teams
Hacker News mode
Safe for work mode
