Data Engineer

SUMMARY OF POSITION AND RESPONSIBILITY:

The Data Engineer is primarily responsible for resource designing, building, and maintaining our large-scale data infrastructure.

This includes data pipelines, ensuring high data quality and accessibility for business intelligence, data warehouse needs and data analytics applications.

This position will collaborate with data analysts, BI lead and other stakeholders to understand data requirements and design solutions to support business needs.

A high level of expertise in data modeling, ETL processes, and database management/warehousing/data lake will be essential in ensuring the integrity and availability of our organization’s data assets.

Essential Functions:

• Communicate effectively with business leads and stakeholders to shape/define project requirements and objectives.
• Design, construct, install, test, and maintain reliable and scalable data management systems, including data warehouse needs.
• Develop and optimize ETL (Extract, transform, load) processes to ensure timely delivery of high-quality data to downstream applications and analytics platforms.
• Ensure systems meet business requirements and industry best practices for data architecture and processing.
• Develop processes for data modeling and data production for downstream consumption.
• Integrate new data management technologies and processes as well as software engineering best practices into existing structures and processes.
• Create custom software components and analytics applications when necessary.
• Employ a variety of languages (primarily Python and SQL) and tools to marry systems together.
• Recommend ways to improve data reliability, efficiency, and quality.
• Collaborate with data architects, modelers, and IT team members on project goals.
• Mentor more junior data talent, fostering a culture of continuous improvement in data practices.
• Actively participate with application end users and IT teams to support system upgrades, new processes, and initiatives.
• Advocate within project design meetings to ensure all requirements are documented and accounted for.
• Lead user acceptance testing and end-to-end testing including end-user training.
• Provide monitoring and troubleshooting of integration points between the ERP system and external applications/API usage.
• Drive continuous improvement and challenge paradigms that may be barriers to progress.
• Assist in maintaining system standards, security and cleanliness of incoming data.
• Advise, develop and standup Allied Data Warehouse – capturing data needs across business units and departments.
  
  
  

Reasonable accommodation may be made to enable individuals with disabilities to perform these essential functions.

QUALIFICATIONS (EDUCATION, CERTIFICATIONS AND/OR TRAINING):

Required Education:

• Bachelor’s degree in computer science, Engineering, or related field; Master’s degree or equivalent experience preferred.
  
  
  

Preferred Education:

• Master’s degree in computer science, Engineering, or a related field.
  
  
  

Required Experience:

• Advanced knowledge of SQL and experience with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
• Experience building and optimizing data pipelines, architectures, and data sets for analytics.
• Strong analytic skills related to working with both structured and unstructured data assets.
• Experience with modern data tools: Snowflake, BigQuery, dbt, Airflow, dagster, Fivetran etc.
• Experience with cloud services: AWS, Azure, GCP, etc.
  
  
  

Preferred Experience:

• 5 years of experience in a Data Engineering role, with a proven track record in a senior or leadership position.
• Experience with modern data tools: Snowflake, BigQuery, dbt, Airflow, dagster, Fivetran etc.
• Experience with cloud services: AWS, Azure, GCP, etc.
  
  
  

ESSENTIAL SKILLS, KNOWLEDGE, ABILITY AND MENTAL REQUIREMENTS:

• Strong project management and organizational skills.
• Excellent communication and collaboration skills.
  
  
  

Work Environment: This position will be performed in an office setting.

Physical Demands: There are little to no physical demands associated with this position

Travel Required: Travel to other locations is not expected for this position.

About Allied Stone:

A trusted industry leader with over 20 years of experience, Allied Stone provides our clients with high-quality stone fabrication, delivered with exceptional customer service. Along the way we have fostered long-lasting partnerships with major suppliers to ensure that we can provide consistent quality at competitive prices. With a team of trendsetting designers, skilled craftsmen, and cutting-edge technology we create a seamless client experience that results in unrivaled finished spaces.

Allied Stone Offers

• Competitive salaries and comprehensive benefits
• On-going learning opportunities within a diverse, inclusive, and rewarding work environment
• Allied Stone is an Equal Employment Opportunity Employer
  
  
  

Affirmative Action/EEO Statement:

Allied Stone Inc. is committed to providing equal employment opportunities for all individuals without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other characteristic protected by applicable law. We embrace diversity and encourage a work environment where differences are respected and valued.

Other Duties:

Please note that this job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.