Senior Azure SQL/Cosmos Data Architect

Kforce Inc; Charleston (SC); Remote; USD 110,000 - 150,000; Full time

Job summary

An established industry player is seeking a Senior Azure SQL/Cosmos Data Architect to join their innovative team. This role involves hands-on development and maintenance of Azure SQL and Cosmos DB, creating scalable database structures, and collaborating with developers to enhance data operations. You will play a crucial role in designing databases that meet business requirements, optimizing performance, and preparing data for advanced modeling. This position offers a dynamic work environment where your expertise will significantly impact data-driven decision-making. If you're passionate about data architecture and eager to contribute to exciting projects, this opportunity is perfect for you.

Benefits

Medical/Dental/Vision Insurance

401(k)

Paid Time Off

Life and Disability Insurance

Flexible Spending Account (FSA)

Health Savings Account (HSA)

Qualifications

• 6+ years of data engineering experience with Azure SQL and Cosmos DB.
• Experience with Azure Data Factory and batch ETL pipelines.

Responsibilities

• Develop and maintain database structures and ADF pipelines.
• Monitor database performance and implement improvements.

Skills

Data Engineering

Azure SQL

Cosmos DB

Azure Data Factory

ETL Pipelines

Python

Data Governance

Dimensional Modeling

Education

Bachelor's Degree in Computer Science or related field

Tools

Azure Data Factory

Power BI

D365 Customer Insights

Job description

This range is provided by Kforce Inc. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$110,000.00/yr - $150,000.00/yr

Responsibilities

Kforce has a client that is looking for a Remote Senior Azure SQL/Cosmos Data Architect for a client. Key Tasks:

• Hands-on development - Azure SQL & Cosmos DB: develop and unit test database code
• Create and maintain database structures
• Senior Azure SQL/Cosmos Data Architect will 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
• As a Senior Azure SQL/Cosmos Data Architect, you will collaborate with application developers/data analysts who will be consuming the data
• Play a direct role in the maintenance, 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
  
  

The pay range is the lowest to highest compensation we reasonably in good faith believe we would pay at posting for this role. We may ultimately pay more or less than this range. Employee pay is based on factors like relevant education, qualifications, certifications, experience, skills, seniority, location, performance, union contract and business needs. This range may be modified in the future.

We offer comprehensive benefits including medical/dental/vision insurance, HSA, FSA, 401(k), and life, disability & ADD insurance to eligible employees. Salaried personnel receive paid time off. Hourly employees are not eligible for paid time off unless required by law. Hourly employees on a Service Contract Act project are eligible for paid sick leave.

Note: Pay is not considered compensation until it is earned, vested and determinable. The amount and availability of any compensation remains in Kforce's sole discretion unless and until paid and may be modified in its discretion consistent with the law.

This job is not eligible for bonuses, incentives or commissions.

Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.

By clicking “Apply Today” you agree to receive calls, AI-generated calls, text messages or emails from Kforce and its affiliates, and service providers. Note that if you choose to communicate with Kforce via text messaging the frequency may vary, and message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You will always have the right to cease communicating via text by using key words such as STOP.

Seniority level

• Seniority level

  Associate

Employment type

• Employment type

  Full-time

Job function

• Job function

  Engineering and Information Technology

• Industries

  Leasing Non-residential Real Estate, Facilities Services, and Real Estate

Referrals increase your chances of interviewing at Kforce Inc by 2x

Get notified about new Data Architect jobs in Charleston, SC.

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.