Data Architect/Developer at Softworld Inc

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.