Logo
Softworld, a Kelly Company

Data Architect/Developer

Softworld, a Kelly Company, Boston, MA, United States

Job Title 80616 - Data Architect/Developer

Job Location Boston MA 02210

Onsite Requirements

  • Proficiency in T-SQL scripting for creating complex stored procedures and queries.
    Hands-on experience with Azure services, including Azure Data Factories, Data Lakes, Data Bricks, SQL Server Managed Instance, and Azure Storage.
  • Proven experience as a Database Architect/Developer with a minimum of 8 years in database design and development.

Job Description

  • Softworld client is seeking a Database Architect/Developer.
  • The ideal candidate should possess a strong background in data modeling, RDMS, and data warehousing, along with extensive experience in creating and optimizing database structures and stored procedures using T-SQL.
  • Proficiency in working with Azure services, particularly Azure Data Factories, Data Lakes, Data Bricks, SQL Server Managed Instance, and Azure Storage, is essential for this role.

SUMMARY OF RESPONSIBILITIES:

  • Design and implement robust data models, relational database schemas, and data warehouses.
  • Develop and deploy complex stored procedures, tables, views, functions, triggers, indexes, constraints, and sequences using T-SQL.
  • Utilize Azure services for data-related tasks, including data ingestion, processing, and storage.\
  • Collaborate with developers to provide necessary database support and guidance for their projects.
  • Conduct comprehensive database reviews for development projects, ensuring adherence to standards and best practices.
  • Experience with Microsoft infrastructures, including Azure resources, MS SQL Server (2014/2017/2019).
  • Collaborate with stakeholders to understand business requirements and translate them into robust and scalable database architecture designs on the Azure Cloud platform.
  • Lead the end-to-end database solution development lifecycle, including data modeling, data flow design,
  • ETL processes, and database schema design.
  • Utilize Azure Data Lakes and Data Warehouses to architect modern data storage solutions that enable efficient data ingestion, processing, and retrieval for analytical purposes.
  • Evaluate and recommend appropriate data storage and database technologies within the Azure ecosystem to optimize performance and cost-efficiency.
  • Design and implement data security and access controls to ensure data integrity and compliance with industry regulations.
  • Work with the Data Governance team to develop strategies and best practices to maintain data quality and consistency across different databases and applications.
  • Work closely with data engineers, data scientists, and other teams to ensure seamless integration of data sources and enable advanced analytics and reporting capabilities.
  • Optimize database performance by fine-tuning queries, indexes, and configurations, and proactively monitor and address performance bottlenecks.
  • Work with the system engineers to recommend and implement disaster recovery and backup strategies to ensure high availability and data resiliency.
  • Stay up to date with the latest advancements in Azure Cloud database tools and recommend appropriate enhancements or migrations to improve the overall database architecture.

QUALIFICATIONS:

  • Bachelor's degree in computer science, Information Technology, or a related field.
  • Proven experience as a Database Architect/Developer with a minimum of 8 years in database design and development.
  • Strong expertise in data modeling, relational databases, and data warehousing concepts.
  • Proficiency in T-SQL scripting for creating complex stored procedures and queries.
  • Hands-on experience with Azure services, including Azure Data Factories, Data Lakes, Data Bricks, SQL
  • Server Managed Instance, and Azure Storage.
  • Familiarity with Azure Cosmos is a plus.
  • Ability to optimize database performance through code and structural improvements.
  • Experience with ETL processes and data movement between databases.
  • Knowledge of C# programming is a plus and may be beneficial in certain project contexts.
  • Familiarity with Business Intelligence (BI) tools will be advantageous for integrating data analysis and visualization capabilities.
  • Experience with Microsoft infrastructures, including Azure resources, MS SQL Server
  • A proactive problem-solving attitude with the ability to troubleshoot and resolve database issues efficiently.
  • Strong communication skills and the ability to work collaboratively in a team environment.
  • Demonstrated adherence to best practices in database design, development, and management.