Data Management Specialist - Data Bricks

System One; Washington (District of Columbia); Presencial; USD 62.000 - 84.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Health benefits

401(k) plan

Dental and vision

Descripción de la vacante

System One has an opening for a Data Management Specialist in Washington, DC, onsite. The role focuses on Azure cloud resources, SQL Server administration, Power BI reporting, and data engineering with Databricks and Azure Data Lake.

The ideal candidate will hold a Bachelor's degree and 3+ years in Azure, SQL Server, BI, and data management, delivering reliable data solutions and actionable insights for business teams.

Formación

• Bachelor's degree required in CS/IT/Data-related field.
• 3+ years of hands-on Azure, SQL Server, Power BI, and Databricks experience.
• Experience with Azure cloud services and data engineering tools.

Responsabilidades

• Administer Azure cloud resources including Azure SQL Database and Azure Data Lake.
• Manage and configure Azure-based data storage, security, and access control.
• Implement automation scripts using Azure CLI and PowerShell.
• Monitor and optimize SQL Server instances for efficiency and reliability.
• Perform database backups, restores, and maintain integrity.
• Assist with migrations of SQL Server to Azure SQL cloud platform.
• Deploy and maintain applications on Apache Tomcat.
• Ensure Apache Tomcat servers run optimally and troubleshoot issues.
• Develop Data Bricks pipelines for data transformation and engineering.
• Build scalable ETL processes with Azure Databricks.
• Create Power BI reports and dashboards for business insights.
• Collaborate with business users to design intuitive visualizations.
• Use R Studio for data analysis and statistical modeling.
• Work with data science team on predictive models and reports.
• Document processes, workflows, and configurations for data management.

Educación

Bachelor's degree in Computer Science, Information Technology, Data Management, or a related field

Herramientas

Azure Administration

SQL Server DBA

Power BI

Apache Tomcat

R Studio

Azure Databricks

Azure SQL Database

Azure Data Lake

Blob Storage

Azure CLI

PowerShell

Descripción del empleo

Job Title: Data Management Specialist
Location: Washington, DC (onsite)
Type: Contract
Compensation: $52.99/HR on W2

Responsibilities

• Administer and support Azure cloud resources, including Azure SQL Database, Blob Storage, and Azure Data Lake, ensuring optimal functionality and performance.
• Manage and configure Azure-based solutions for data storage, security, and access control.
• Implement automation scripts for managing and provisioning Azure resources using Azure CLI and PowerShell.
• Monitor and optimize SQL Server instances for efficiency and reliability.
• Perform database backups, restore operations, and ensure database integrity.
• Assist with migrations and upgrades of SQL Server environments to cloud-based platforms (Azure SQL).
• Assist in the deployment and maintenance of applications using Apache Tomcat.
• Ensure Apache Tomcat servers are running optimally and troubleshoot any issues that arise.
• Contribute to the development of Data Bricks pipelines, helping to implement data transformation and data engineering processes.
• Work with data teams to build scalable ETL (Extract, Transform, Load) processes using Azure Databricks.
• Create and maintain Power BI reports, dashboards, and data visualizations that provide actionable insights to business teams.
• Collaborate with business users to understand their reporting needs and design intuitive visualizations that help with data-driven decision-making.
• Use R Studio for data analysis, statistical modeling, and generating insights from large datasets.
• Work with the data science team to build predictive models and statistical reports that meet business needs.
• Document processes, workflows, and configurations to ensure consistent and effective data management practices.

Requirements

• Bachelor's degree in Computer Science, Information Technology, Data Management, or a related field.
• 3+ years of experience working in data management, with hands-on experience in Azure, SQL Server, Power BI, Apache Tomcat, R Studio, and Data Bricks.
• Proficient in Azure Administration, including Azure SQL Database, Azure Blob Storage, and Azure Data Lake.
• Strong knowledge of SQL Server Database Administration, including performance tuning, backups, and restores.
• Experience working with Apache Tomcat for application deployments and integration.
• Practical experience with Power BI for report creation, dashboards, and data visualization.
• Proficiency in R Studio for data analysis and statistical modeling.
• Basic experience with Azure Databricks for data engineering and big data processing workflows.
• Ability to troubleshoot and resolve data management issues effectively.
• Strong teamwork abilities, with the capacity to communicate technical information to non-technical stakeholders.

System One, and its subsidiaries including Joulé and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.

System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.