Database Engineer
Database Engineer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
USD 130 - 160
1 Vacancy
Job Description
Ironside Group is seeking a Database Engineerto join our team. In this role you will support clients across a variety of industries by designing and implementing analyticsfocused databases and building efficient ETL/ELT pipelines. Youll 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 clientfacing fastpaced environment and enjoys solving complex data challenges.
Your Contributions:
- Responsible for designing and implementing detailed 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 midmarket organizations.
- Create and managedata models and schema designsto 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 enduser training and knowledgetransfer services to customers
- Partner with data analysts data scientists and business users to deliver reliable welldocumented data assets
- Occasional travel within the US required.
Your Proven Track Record:
- 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 robustETL/ELT pipelinesfor structured and semistructured 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 TSQL and PLSQL
- Ability to understand and analyze data assets as part of reporting analytics
- Experience working in data migration projects is desirable
- Experience working with Azure Synapse / Data Factory is a plus
- AWS platform experience & certification is a plus.
- Snowflake or equivalent database certification is a plus.
- Subject matter expertise in Insurance or Financial Services (Asset Management Hedge Funds Banking) is a plus.
The Ironside Edge:
- The opportunity to join and grow an everexpanding professional network of highprofile 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 indepth operational experience across a variety of industries and organizational departments.
- The opportunity to explore and put into practice cuttingedge technology on a regular basis.
- An incentivized development program that enhances your skill set with professional training and certifications.
- Competitive meritbased compensation and bonus packages that rapidly reward passionate and driven team members.
- Small company culture with big company benefits.
About Ironside
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.
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.
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. Its a lofty way of thinking. One that has helped us make new inroads in our industry and our clients in theirs.
* Please note this position is a remote position.
Required Experience:
Senior IC
Employment Type
Full-Time
