LanceSoft, Inc.
Data engineer with Azure data Factory : REMOTE
LanceSoft, Inc., Raleigh, North Carolina, United States, 27601
Looking for a Data Engineer with experience in Oracle, DB2, MySQL, and SQL Server, as well as desktop-based applications such as MS Access and MS Excel. The primary goal is to establish an enterprise data model to standardize shared data entities and attributes, and the secondary goal is to standardize database management systems and tools. Related transactional databases and data warehouses will be hosted in Azure, generally using Microsoft Dataverse and SQL Server. The Senior Data Analyst/Architect will provide analysis and leadership on data analysis projects across the client enterprise. You will also provide subject matter expertise related to Microsoft Dataverse, SQL Server, Azure Data Factory, and SSIS.
Skills
Experience with Azure Data Factory as an ETL tool.Experience with MS Dataverse is required.Experience with MS SSIS.Proven track record of solving real-world problems using data. Excellent critical thinking skills are a must-have for this role.Understanding of different database platforms: Oracle, SQL Server (On-Prem / Azure), DB2, and MS Access.Understanding of Data Warehousing and data mining.Understanding of modeling strategies (dimensional, snowflake, relational, unstructured).Strong interest in playing a technical data steward role across our business and technology partners.Proven experience with ERD/Data Modeling tools (Toad or others).Experience in executing projects in an Agile / Hybrid environment.Experience with data reporting tools (Power BI, others).
#J-18808-Ljbffr
Skills
Experience with Azure Data Factory as an ETL tool.Experience with MS Dataverse is required.Experience with MS SSIS.Proven track record of solving real-world problems using data. Excellent critical thinking skills are a must-have for this role.Understanding of different database platforms: Oracle, SQL Server (On-Prem / Azure), DB2, and MS Access.Understanding of Data Warehousing and data mining.Understanding of modeling strategies (dimensional, snowflake, relational, unstructured).Strong interest in playing a technical data steward role across our business and technology partners.Proven experience with ERD/Data Modeling tools (Toad or others).Experience in executing projects in an Agile / Hybrid environment.Experience with data reporting tools (Power BI, others).
#J-18808-Ljbffr