Kforce - Charleston, SC

posted 3 months ago

Full-time - Senior
Charleston, SC
Administrative and Support Services

About the position

Kforce is seeking a Remote Senior Azure SQL/Cosmos Data Architect to join our client’s team. This role is pivotal in developing and maintaining database structures that support business requirements. The Senior Azure SQL/Cosmos Data Architect will engage in hands-on development, focusing on Azure SQL and Cosmos DB, where they will be responsible for developing and unit testing database code. This position requires a deep understanding of database design principles, including the ability to utilize first, second, or third normalized forms as necessary to meet the needs of the business. In addition to database development, the architect will create, deploy, and maintain Azure Data Factory (ADF) pipelines, ensuring that data flows efficiently and effectively through the system. Monitoring database performance is a critical aspect of this role, as the architect will need to identify bottlenecks and implement improvements to guarantee scalable and reliable database operations in a production environment. The architect will also perform complex data analysis, document findings, and prepare data for prescriptive and predictive modeling. Collaboration is key in this role, as the Senior Azure SQL/Cosmos Data Architect will work closely with application developers and data analysts who will be consuming the data. This position also involves maintaining technical support, documentation, and administration of databases, ensuring that all systems are running smoothly and efficiently. The architect will play a direct role in building and supporting complex data ingestion processes, combining raw data from various external sources to meet the organization’s data needs.

Responsibilities

  • Hands-on development - Azure SQL & Cosmos DB: develop and unit test database code
  • Create and maintain database structures
  • Participate in the design of databases, using first, second or third normalized form as needed to support business requirements
  • Create, deploy, and maintain ADF pipelines
  • Monitor database performance, identify bottlenecks and implement improvements to ensure scalable and reliable database operations in a production environment
  • Perform analysis of complex data and document findings
  • Prepare data for prescriptive and predictive modeling
  • Combine raw data from different external sources and build and support complex ingestions
  • Collaborate with application developers/data analysts who will be consuming the data
  • Maintain technical support, documentation, and administration of databases

Requirements

  • 6+ years of relevant and progressive data engineering experience
  • 3+ years of experience with Cosmos DB
  • Minimum of 3 years of relevant experience working with Azure Data Factory
  • Minimum of 1 year of relevant experience working with Azure Data Lakes Gen 2
  • Experience with Power Platform/Power BI
  • Experience in engineering practices such as code refactoring, design patterns, CI/CD, and highly scalable data applications
  • Experience developing batch ETL pipelines; real-time pipelines are a plus
  • Deep Technical knowledge and experience in Microsoft Azure architecture, including Azure PaaS databases, Synapse, ADF pipelines and Synapse stored procedures
  • Knowledge of advanced data engineering concepts such as dimensional modeling, ETL, data governance, data warehousing, structured and unstructured data
  • Hands-on skills working with data pipelines using SQL and No-SQL databases
  • Understanding/Experience with Python; Additional knowledge of parallel processing frameworks like MapReduce, Spark, Scala is a plus
  • Experience/Familiarity with D365 Customer Insights platform/Dataverse is a plus

Benefits

  • Medical insurance
  • Dental insurance
  • Vision insurance
  • Health Savings Account (HSA)
  • Flexible Spending Account (FSA)
  • 401(k)
  • Life insurance
  • Disability insurance
  • Accidental Death and Dismemberment (ADD) insurance
  • Paid time off for salaried personnel
  • Paid sick leave for hourly employees on Service Contract Act projects
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service