Rose International · 7 hours ago
Data Engineer
Durham, NC
Full-time
Hybrid
Senior Level
$60/hr - $65/hr
5+ years expRose International is seeking a Data Engineer for the development and optimization of end-to-end solutions using Microsoft Azure Synapse Analytics and Power BI. The role involves designing and implementing data engineering solutions to support child welfare business needs through effective data pipelines and analytics solutions.
Human ResourcesInformation TechnologyOutsourcingProject ManagementStaffing Agency
Responsibilities
Design, Develop and maintain data models in Synapse to support reporting and analytics
Develop ETL solutions using Azure Synapse Analytics Pipelines and dedicated SQL pools for extraction, transformation, and aggregation from Salesforce objects
Analyze the source system and design the ETL data load
Ability to create and configure an Azure Synapse Analytics workspace
Create pipelines in Azure Synapse using Linked Services/Datasets/Pipeline to Extract, Transform, and Load data from different sources like Salesforce
Perform needed monitoring, troubleshooting, and maintenance of the data architecture and pipelines
Collaborate with data engineers, analysts, and stakeholders to gather requirements, design visualizations, and provide training to use self-service BI Tools
Qualification
Required
Experience in designing and optimizing scalable data pipelines using modern platforms like Azure Synapse, Snowflake, or Databricks workflows (3 Years)
Programming Languages: Strong proficiency in Python or Scala for data processing (3 Years)
SQL Mastery: Advanced query writing, performance tuning, and optimization (5 Years)
Hands-on experience in developing efficient PL/SQL procedures (5 Years)
Experience with Programming and Scripting (SQL, T-SQL, and data query optimization) (1 Year)
Preferred
Experience with Azure Data Platform (Azure Data Factory, Azure Data Lake, and Azure SQL Database) (1 Year)
Experience with cloud platforms (e.g., AWS and Azure) and associated services for data processing and storage (1 Year)
Experience with Power BI (1 Year)
Company
Rose International
Rose International is provider of Workforce Solutions and Information Technology Solutions .
5001-10000 employees
H1B Sponsorship
Rose International has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2024 (3)
2023 (2)
2022 (2)
2021 (5)
2020 (9)
Funding
Current Stage
Late StageLeadership Team
Eric Token
Chief Revenue Officer (CRO)
Sue Bhatia
Founder and Chairwoman
Recent News
Company data provided by crunchbase