Managed Services Data Engineer
Posted on 8/31/2023
Locations
Remote
Experience Level
Entry
Junior
Mid
Senior
Expert
Desired Skills
Data Analysis
Microsoft Azure
SQL
Power BI
CategoriesNew
Data & Analytics
Requirements
- Bachelor's degree in Computer Science, Mathematics, or related field, or equivalent certification
- Experience working in a support role and understanding standard support processes (i.e. ITIL)
- 2 - 4 years working with data and business intelligence solutions on the Microsoft tool stack for Business Intelligence (ADF, SQL DW, Synapse, Databricks, etc.)
- Strong verbal and written communication skills
- A passion for problem solving and learning new technologies
- Client relationship skills and experience managing vendors
- Strong desire for personal development and learning, including commitment to continuously upgrading your technical skills as the data landscape change
- Experience maintaining and troubleshooting production database server issues
- Experience with Azure SQL PaaS services(e.g. Azure SQL Managed Instance, Azure SQL DB, Azure DB for PostreSQL, etc.)
- Understanding of security roles and how to implement database security
- Experienced running production database server environments including: maintenance, performance optimization, backup/restore, analysis and troubleshooting
- Work remote, but not alone - with a team filled top to bottom with data analytics professionals
Responsibilities
- Support of client's Azure Data platform and Power BI Environment, including response to any escalations while helping to analyze and resolve incidents for customers environment
- Consult, develop and advise on solutions in Microsoft Azure with tools such as Databricks, Synapse, Data Factory, Data Lake, Data Warehouse
- Consistently learn, apply, and refine skills around data engineering and some database administration (DBA)
- Design and deploy data pipelines, models, and AI-driven solutions for clients in various industries
- Work with clients on Database Migrations, High Availability and Disaster Recovery solutions, SQL and Windows Clustering solutions, Monitoring, Backup/Recovery solutions, Security and Performance Tuning including remediation on performance blockers
- Communicate ticket status information to all associated parties and escalate cases as appropriate
- Interact with clients to identify issues, troubleshoot expediently, and follow up on issues via e-mail, ticketing system, and phone calls. Communicate technical issues and solutions with clients in business terms
- Configure, administer, tune and develop client's data environment based on contracted services
- Create and maintain updated documentation for each client's environment
- Promote best practices for clients and internally to enhance and improve organizational processes
- Participate in recurring discussions with clients to review current issues and to propose possible solutions
Desired Qualifications
- Previous DBA experience and knowledge of Kusto Query Language (KQL) is a plus