Data Architect/Developer

Softworld - Boston, MA

Full-time

Boston, MA

Administrative and Support Services

About the position

The Data Architect/Developer role involves designing and implementing robust data models and relational database schemas, primarily utilizing Azure services. The position requires extensive experience in database design and development, particularly with T-SQL scripting, and aims to optimize database performance while ensuring data integrity and compliance with industry regulations.

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.
• 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.

Requirements

• 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.
• Ability to optimize database performance through code and structural improvements.
• Experience with ETL processes and data movement between databases.
• 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.

Nice-to-haves

• Familiarity with Azure Cosmos is a plus.
• 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.