Senior Database Engineer - Remote

Overview

Ironside Group is seeking a Database Engineer to join our team. In this role, you will support clients across a variety of industries by designing and implementing analytics-focused SQL databases and building efficient ETL/ELT pipelines. You’ll have the opportunity to work on diverse projects, often taking on multiple roles throughout the project lifecycle. This is a dynamic position ideal for someone who thrives in a client-facing, fast-paced environment and enjoys solving complex data challenges.

In Short

• Responsible for designing and implementing detailed SQL data warehouse models and data mappings for clients.
• Perform performance optimization and tuning on new and/or existing data warehouse implementations.
• Provide strategic and tactical guidance with respect to data warehousing best practices and attention to quality documentation within large and mid-market organizations.
• Create and manage data models and schema designs to support reporting, operational systems, and downstream analytics.
• Develop and maintain expertise in advanced and/or emerging data warehouse and analytical information technologies such as cloud data warehousing and ETL/ELT, modern data platforms and data lakes.
• Provide detailed documentation, end-user training, and knowledge-transfer services to customers.
• Partner with data analysts, data scientists, and business users to deliver reliable, well-documented data assets.
• Occasional travel within the United States is required.

Requirements

• 5+ years of experience in data modelling & managing data assets and working with Snowflake, Redshift, Netezza, and Databricks for data storage, processing, and analytics use cases.
• 3+ years of practical experience building and maintaining robust ETL/ELT pipelines for structured and semi-structured data using modern tools like Glue, DBT, Informatica, SSIS and best practices.
• Expertise in SQL scripting, writing complex and efficient queries, building complex and performant stored procedures in SQL.
• Expert knowledge in procedure languages – T-SQL and PL-SQL.
• Ability to understand and analyze data assets as part of reporting analytics.

Benefits

• The opportunity to join and grow an ever-expanding professional network of high-profile clients and reputable colleagues.
• A passionate and approachable leadership team that encourages an entrepreneurial frame of mind and welcomes contributions to business development from all members of the team.
• A challenging, dynamic, and rewarding work environment that fosters rapid professional growth in a space that is at the forefront of information technology.
• An unparalleled opportunity to gain in-depth operational experience across a variety of industries and organizational departments.
• The opportunity to explore and put into practice cutting-edge technology on a regular basis.
• An incentivized development program that enhances your skill set with professional training and certifications.
• Competitive merit-based compensation and bonus packages that rapidly reward passionate and driven team members.
• Small company culture, with big company benefits.