Senior Database Engineer

Other Jobs To Apply

<p><span style="font-size:14px;"><span style="font-family:Georgia, serif;">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.</span></span></p><br><span style="font-size:14px;"><span style="font-family:Georgia, serif;"><strong><span style="line-height:115%;"><span style="line-height:115%;">Your Contributions:</span></span></strong></span></span><ul><li><span style="font-size:14px;"><span style="font-family:Georgia, serif;"><span style="line-height:115%;"><span style="line-height:115%;">Responsible for designing and implementing detailed SQL data warehouse models and data mappings for clients.</span></span></span></span></li><li><span style="font-size:14px;"><span style="font-family:Georgia, serif;"><span style="line-height:115%;"><span style="line-height:115%;">Perform performance optimization and tuning on new and/or existing data warehouse implementations.</span></span></span></span></li><li><span style="font-size:14px;"><span style="font-family:Georgia, serif;"><span style="line-height:115%;"><span style="line-height:115%;">Provide strategic and tactical guidance with respect to data warehousing best practices and attention to quality documentation within large and mid-market organizations.</span></span></span></span></li><li><span style="font-size:14px;"><span style="font-family:Georgia, serif;"><span style="line-height:115%;"><span style="line-height:115%;">Create and manage data models and schema designs to support reporting, operational systems, and downstream analytics</span></span></span></span></li><li><span style="font-size:14px;"><span style="font-family:Georgia, serif;"><span style="line-height:115%;"><span style="line-height:115%;">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.</span></span></span></span></li><li><span style="font-size:14px;"><span style="font-family:Georgia, serif;"><span style="line-height:115%;"><span style="line-height:115%;">Provide detailed documentation, end-user training, and knowledge-transfer services to customers</span></span></span></span></li><li><span style="font-size:14px;"><span style="font-family:Georgia, serif;"><span style="line-height:115%;"><span style="line-height:115%;">Partner with data analysts, data scientists, and business users to deliver reliable, well-documented data assets</span></span></span></span></li><li><span style="font-size:14px;"><span style="font-family:Georgia, serif;"><span style="line-height:115%;"><span style="line-height:115%;">Occasional travel within the United States is required.</span></span></span></span></li></ul><span style="font-size:14px;"><span style="font-family:Georgia, serif;"><strong><span style="line-height:115%;"> </span><br><span style="line-height:115%;"><span style="line-height:115%;">Your Proven Track Record:</span></span></strong></span></span><ul><li><span style="font-size:14px;"><span style="font-family:Georgia, serif;"><span style="line-height:115%;"><span style="line-height:115%;">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</span></span></span></span></li><li><span style="font-size:14px;"><span style="font-family:Georgia, serif;"><span style="line-height:115%;"><span style="line-height:115%;">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</span></span></span></span></li><li><span style="font-size:14px;"><span style="font-family:Georgia, serif;"><span style="line-height:115%;"><span style="line-height:115%;">Expertise in SQL scripting, writing complex and efficient queries, building complex and performant stored procedures in SQL</span></span></span></span></li><li><span style="font-size:14px;"><span style="font-family:Georgia, serif;"><span style="line-height:115%;"><span style="line-height:115%;">Expert knowledge in procedure languages – T-SQL and PL-SQL</span></span></span></span></li><li><span style="font-size:14px;"><span style="font-family:Georgia, serif;"><span style="line-height:115%;"><span style="line-height:115%;">Ability to understand and analyze data assets as part of reporting analytics</span></span></span></span></li></ul><span style="font-size:14px;"><span style="font-family:Georgia, serif;"><strong><span style="line-height:115%;"><span style="line-height:115%;">Bonus Experience:</span></span></strong></span></span><ul><li><span style="font-size:14px;"><span style="font-family:Georgia, serif;"><span style="line-height:115%;"><span style="line-height:115%;">AWS platform experience & certification is a plus.</span></span></span></span></li><li><span style="font-size:14px;"><span style="font-family:Georgia, serif;"><span style="line-height:115%;"><span style="line-height:115%;">Experience working in data migration projects is desirable</span></span></span></span></li><li><span style="font-size:14px;"><span style="font-family:Georgia, serif;"><span style="line-height:115%;"><span style="line-height:115%;">Snowflake or equivalent database certification is a plus</span></span></span></span></li><li><span style="font-size:14px;"><span style="font-family:Georgia, serif;"><span style="line-height:115%;"><span style="line-height:115%;">Experience working with Azure Synapse / Data Factory is a plus</span></span></span></span></li><li><span style="font-size:14px;"><span style="font-family:Georgia, serif;"><span style="line-height:115%;"><span style="line-height:115%;">Subject matter expertise in Insurance or Financial Services (Asset Management, Hedge Funds, Banking) is a plus.</span></span><span style="line-height:115%;"> </span></span></span></li></ul> <p><strong><span style="font-size:14px;"><span style="font-family:Georgia, serif;">The Ironside Edge:</span></span></strong></p><ul><li><span style="font-size:14px;"><span style="font-family:Georgia, serif;">The opportunity to join and grow an ever-expanding professional network of high-profile clients and reputable colleagues.</span></span></li><li><span style="font-size:14px;"><span style="font-family:Georgia, serif;">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.</span></span></li><li><span style="font-size:14px;"><span style="font-family:Georgia, serif;">A challenging, dynamic, and rewarding work environment that fosters rapid professional growth in a space that is at the forefront of information technology.</span></span></li><li><span style="font-size:14px;"><span style="font-family:Georgia, serif;">An unparalleled opportunity to gain in-depth operational experience across a variety of industries and organizational departments.</span></span></li><li><span style="font-size:14px;"><span style="font-family:Georgia, serif;">The opportunity to explore and put into practice cutting-edge technology on a regular basis.</span></span></li><li><span style="font-size:14px;"><span style="font-family:Georgia, serif;">An incentivized development program that enhances your skill set with professional training and certifications.</span></span></li><li><span style="font-size:14px;"><span style="font-family:Georgia, serif;">Competitive merit-based compensation and bonus packages that rapidly reward passionate and driven team members.</span></span></li><li><span style="font-size:14px;"><span style="font-family:Georgia, serif;">Small company culture, with big company benefits.</span></span></li></ul><p></p><p><strong><span style="font-size:14px;"><span style="font-family:Georgia, serif;">About Ironside</span></span></strong></p><p><span style="font-size:14px;"><span style="font-family:Georgia, serif;">At Ironside, we dive deep into clients’ core business challenges, emerging with new insights into how we can leverage the power of business analytics to help move companies further and faster toward their goals.</span></span></p><p><span style="font-size:14px;"><span style="font-family:Georgia, serif;">Our expertise in business intelligence, performance management, predictive analytics, information management, big data, and more only becomes meaningful when brought into careful alignment with where a business stands today and where it means to be tomorrow.</span></span></p><p><span style="font-size:14px;"><span style="font-family:Georgia, serif;">Our goal is to use the power of business analytics to propel businesses forward and upward until they break through to a new way of looking at their industry, the world, and their place in both. It’s a lofty way of thinking. One that has helped us make new inroads in our industry, and our clients in theirs.</span></span></p><p><span style="font-size:14px;"><span style="font-family:Georgia, serif;">* Please note this position is a remote position. </span></span></p>

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...