Senior Database Architect

Job Description

A data engineer is responsible for designing and building scalable data solutions to support business needs. This role requires a strong understanding of database administration, reporting, and dashboarding disciplines.

The ideal candidate will have extensive experience in TSQL, SSRS, ETL, Azure data storage, Azure Synapse, and data warehousing. They should be able to understand business requirements, design and build solutions, extract data from various sources, consolidate multiple data sources into a data warehouse or lake, ensure data accessibility, set up dashboards and reports, and implement best practices.

• Understand business needs and design solutions that meet those needs.
• Capable of architecture, design, and implementing warehouse and reporting solutions.
• Extract data from bespoke applications and third-party products.
• Consolidate multiple data sources into a data warehouse and / or data lake.
• Ensure data is accessible and structured to facilitate reporting needs.
• Set up dashboards and reports in data visualization and reporting tools.
• Build resilient, reliable, secure, and cost-effective solutions.
• Stay ahead of issues with proactive monitoring and alerting.
• Implement best practices.
• Collaborate as part of an agile team to design, develop, and maintain software.
• Collaborate with product management to prioritize and plan technical debt remediation and refactoring of data structures and stored procedures.
• Design and implement repeatable data pull requests and execute ad-hoc requests as needed.

Bachelor's degree in computer science or related field required. 10+ years of strong experience with SQL Servers and relational databases. Strong experience with querying and optimizing complex data sets, creating and optimizing complex stored procedures, functions, and triggers, working with older legacy code and systems, data engineering or related roles, end-to-end knowledge from product databases to information visualization, experience in Azure cloud technologies, experience in relational database design and architecture, expertise in data visualization and reporting using SSRS and Power BI, experience with SSIS, ADF, or any other ETL tools, experience with data warehouse and data modelling single-layer Data warehouse Kimball, .NET experience a plus, Azure experience a plus, Agile environment experience a plus, AWS cloud data technologies experience beneficial.

Teamwork and collaboration - willing to share thoughts and seek ideas and feedback from others in return. Excellent verbal and written communication skills, comfortable working with staff at all levels, ability to self-organize, prioritize, and track tasks, can work on their own or in a team.