Data Engineer

Job Overview

Do you have hands-on experience with analytics engineering and modern data warehouses? Were looking for an expert communicator with a strong customer orientation and analytics engineering experience to join our Data Engineering team. In this role, youll design, develop and implement data models for our data warehouse and deliver insights to stakeholders and customers. If youre craving an exciting new opportunity where you can partner with project managers and other business leaders to facilitate projects that make good use of your data insights this opportunity is for you!

About Us

When you join iCIMS, you join the team helping global companies transform business and the world through the power of talent.Our customers do amazing things: design rocket ships, create vaccines, deliver consumer goods globally, overnight, with a smile.As the Talent Cloud company, we empower these organizations to attract, engage, hire, and advance the right talent. Were passionate about helping companies build a diverse, winning workforce and about building our home team. We're dedicated to fostering an inclusive, purpose-driven, and innovative work environment where everyone belongs.

Responsibilities

• Design and maintain data warehouse using Redshift.

• Use dimensional modeling and Kimball methodology to design and optimize data structures in dbt.

• Write optimized SQL queries to extract data and perform data analysis.

• Develop Looker dashboards and reports using LookML to enable stakeholders and customers to access and analyze data easily.

• Establishes methods and procedures for tracking data quality, completeness, redundancy, and improvement.

• Oversees the mapping of data sources, data movement, interfaces, and analytics, with the goal of ensuring data quality.

• Develop testing criteria to guarantee the fidelity and performance of data analytics solutions.

• Implements data management processes, procedures, and decision support.

• Implements Data Catalog, a scalable resource to support Self-Service and Single-source-of-truth analytics.

• Work with data governance, customer success and product reporting teams to build out advanced analytics and reporting dashboards leveraging tools such as Looker

• Collaborate with cross-functional teams to ensure data accuracy and integrity.

• Continuously monitor and optimize query performance for large data sets.

• Research emerging trends and best of breed solutions for data modeling, data contextualization, and predictive analytics.

• Understanding of distributed computing principles.

Qualifications

• 3+ years of experience in data modeling, database design, and ETL/ELT development.

• Strong experience with data warehouse (Redshift, Snowflake or BigQuery) and Modern data stack.

• Strong experience with creating dashboards using BI tools like Looker, Tableau, PowerBI.

• Advanced proficiency in SQL and query optimization.

• Excellent communication and collaboration skills.

• Knowledge of AWS, CICD, Git.

• Hands-on knowledge of data modeling, data profiling or data parsing and data migration.

• Experience with conducting studies, rapid pilots, PoCs, prototypes, and identifying metrics.

• Experience identifying & implementing best practices on data quality issues, root causes, and remedies.

• Experience developing scalable and reliable automated tests and data reconciliation scripts.

• Experience working directly with business teams and leaders to understand requirements and communicate results.

Preferred

• Programming experience with Python is highly desirable

• Good knowledge of applicable data privacy practices and laws

• Experience with dbt

• Experience with Looker and/or LookML

• Experience with Redshift

• Experience with user behavior data (Google Analytics; Snowplow; etc)

• Experience with dimensional modeling and Kimball methodology

EEO Statement

iCIMS is a place where everyone belongs. We celebrate diversity and are committed to creating an inclusive environment for all employees. Our approach helps us to build a winning team that represents a variety of backgrounds, perspectives, and abilities. So, regardless of how your diversity expresses itself, you can find a home here at iCIMS.

We are proud to be an equal opportunity and affirmative action employer. We prohibit discrimination and harassment of any kind based on race, color, religion, national origin, sex (including pregnancy), sexual orientation, gender identity, gender expression, age, veteran status, genetic information, disability, or other applicable legally protected characteristics. If you would like to request an accommodation due to a disability, please contact us at [ Email address blocked ] - Click here to apply to Data Engineer .

Compensation and Benefits

The target total compensation for this role is $92,600 - $123,500. Compensation will be based upon experience.

Competitive health and wellness benefits include medical, dental, vision, 401(k), dependent care, short term and long term disability, life and AD&D insurance, bonding and parental leave, mindfulness resources, an open vacation policy, sick days, paid holidays, quiet hours each workday, and tuition reimbursement. Benefits and eligibility may vary by location, role, and tenure. Learn more here: [ Link removed ] - Click here to apply to Data Engineer s