"Alerted.org

Job Description

Our client is looking for Senior Data Engineer to join their growing team of data experts. In this role, you will be responsible for expanding and optimizing our data and data pipeline architecture, as well as optimizing data flow and collection for cross-functional teams. The ideal candidate is an experienced data pipeline builder and engineer who enjoys optimizing data systems and building them from the ground up. The Sr. Data Engineer will support our data analysts/scientists on data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects. They must be self-directed and comfortable supporting the data needs of multiple teams, systems and products. The right candidate will be excited by the prospect of optimizing or even re-designing our company’s data architecture to support our next generation of products and data initiatives.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to [email protected] learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.

Skills and Requirements

8+ years of professional software development or data engineering experience

5+ years of SQL experience with dimensional data modeling & schema design in relational data warehouses

5+ years of experience in end-to-end ETL/ELT pipeline design, implementation and maintenance

4+ years of experience in Python for data manipulation and scripting

3+ years of experience with Snowflake (Confident with dimensional modeling, fact/dimension tables, and star schema design).

Deep knowledge of DBT to create staging, intermediate and final models in SQL. Ensure data quality and lineage using DBT tests, documentation, and governance frameworks.

Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement

Ability to clearly articulate the reasoning, outcomes, and problems solved in data workflows and architecture decisions. Experience deploying production systems in the cloud (AWS)

Advanced Engineering or Technical Degree

Experience in Retail and/or Franchise operations

Astronomer null

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion,sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military oruniformed service member status, or any other status or characteristic protected by applicable laws, regulations, andordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to [email protected].