Data Architect/Developer

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.