Were looking for a skilled Applicative SQL Server DBA with a strong background in system design and a deep understanding of data architecture. This role is a key part of our Data Department, which plays a critical role in supporting business decisions and managing complex financial processes including reporting for NASDAQ compliance.
Responsibilities:
Design, develop, and maintain complex financial reporting solutions (including advanced SQL queries).
Investigate and troubleshoot data issues, validate results, and deliver high-quality ad-hoc reports and analysis.
Develop and maintain data pipelines that load data from external, heterogeneous sources using PowerShell and SQL scripts.
Support the migration of complex stored procedures and data processes from SQL Server to Snowflake.
Responsibilities:
Design, develop, and maintain complex financial reporting solutions (including advanced SQL queries).
Investigate and troubleshoot data issues, validate results, and deliver high-quality ad-hoc reports and analysis.
Develop and maintain data pipelines that load data from external, heterogeneous sources using PowerShell and SQL scripts.
Support the migration of complex stored procedures and data processes from SQL Server to Snowflake.
Requirements:
3+ years of experience as a SQL Server DBA.
Hands-on experience with Snowflake.
Experience with performance tuning and optimization using native tools.
Proven experience in automation through scripting (PowerShell, SQL, etc.).
Ability to translate business processes into efficient, functional code.
Strong understanding of data modeling, schemas, and database concepts.
Solid skills in database design, implementation, optimization, and maintenance.
Strong multitasking skills and the ability to perform under deadlines in a dynamic environment.
High standards in design, documentation, and testing.
Background or familiarity with financial systems/terminology (Advantage)
Experience working with AWS (Advantage)
Familiarity with PowerShell, SSIS, or tools such as Rivery, Qlik Replicate, dbt, or Airflow (Advantage).
3+ years of experience as a SQL Server DBA.
Hands-on experience with Snowflake.
Experience with performance tuning and optimization using native tools.
Proven experience in automation through scripting (PowerShell, SQL, etc.).
Ability to translate business processes into efficient, functional code.
Strong understanding of data modeling, schemas, and database concepts.
Solid skills in database design, implementation, optimization, and maintenance.
Strong multitasking skills and the ability to perform under deadlines in a dynamic environment.
High standards in design, documentation, and testing.
Background or familiarity with financial systems/terminology (Advantage)
Experience working with AWS (Advantage)
Familiarity with PowerShell, SSIS, or tools such as Rivery, Qlik Replicate, dbt, or Airflow (Advantage).
This position is open to all candidates.
