GID Investment Advisers LLC Careers

As a Data Engineer at GID, you will play a crucial role in building a data platform that supports BI & AI initiatives. You will be responsible for developing data models within Snowflake, leveraging dbt to transform and organize data, and building data pipelines using ETL tools like ADF, FiveTran, and Matillion to ensure seamless data ingestion. Your expertise in data modeling will be essential in creating an efficient, scalable, and well-structured data warehouse that supports analytics, reporting, and data science initiatives.

Responsibilities

• Develop and maintain ETL pipelines from various types of sources such as REST APIs, Databases, Sharepoint, SFTP, Web Scraping, etc.
• Design, implement, and optimize scalable data models to ensure efficient data storage, retrieval, and reporting.
• Use dbt to build, test, and maintain modular and reusable data transformations, applying data modeling principles to create structured and insightful datasets.
• Work closely with data analysts, data scientists, and business stakeholders to understand data requirements and translate them into well-designed data models.
• Document data models, ETL processes, and transformation logic to foster knowledge sharing and maintain data consistency.
• Ensure data quality and security through data governance, validation, and compliance practices.
• Monitor and troubleshoot data workflows to ensure high performance, reliability, and scalability of the data platform.
• Stay current on industry trends and best practices in data modeling, making recommendations for ongoing platform improvements.

Requirements

• Bachelor's degree in computer science, data engineering, information systems, or a related field.
• 3+ years of experience in data engineering with a focus on building data pipelines and data modeling.
• In-depth understanding of data modeling best practices, including dimensional modeling, star schema design, and normalization/denormalization techniques.
• Hands-on experience with ETL tools like ADF, FiveTran, Matillion, and dbt for data transformation.
•  Experience with building streaming and batch data pipelines in SQL or Python and familiarity with REST API sources. 
• Experience with using and maintaining cloud data platforms such as Snowflake and Microsoft Azure.
• Proficiency in SQL and Python.
• Design and support reverse ETL applications to operationalize data, ensuring that key insights are fed back into business tools and processes.
• Strong analytical and problem-solving skills with a commitment to data accuracy and quality.
• Excellent communication skills and the ability to work collaboratively across teams to align data models with business needs.
• Familiarity with data visualization tools (e.g., Power BI, Sigma) and their integration with data models.

Preferred Qualifications

• Snowflake, DBT and/or Microsoft Azure certified or equivalent experience.
• Hands-on-Experience with ETL tools, data transformation and pipeline orchestration tools.
• Background in DevOps practices, version control (e.g., Git), and CI/CD for data engineering.
• Knowledge of data governance principles and tools for ensuring data integrity and compliance.

 Why Join Us

• Opportunity to shape and enhance a data platform with a strong focus on data modeling best practices.
• Work in a collaborative environment with access to innovative tools and technologies.
• Competitive salary and benefits, with room for career growth and development.
• Continuous learning opportunities and an emphasis on innovation.