Pay Transparency Statement: The compensation philosophy reflects the Company’s reasonable expectation at the time of posting. We consider a number of factors when making individual compensation decisions including, but not limited to, skill sets, experience and training, and other business needs.  This role may also be eligible to participate in a discretionary incentive program, subject to the rule governing the program.

Position Summary: The ETL Architect is responsible for designing, developing, and supporting data ingestion and transformation solutions that will be utilized in reporting, analytics, or within other applications. The position will also perform data analysis, construct technical designs, communicate with team members and business stakeholders, and support existing data ingestion and transformation pipelines. This position will also coordinate and review the work activities of offshore development and support resources. Position Responsibilities may include, but not limited to:

• Responsible for the design, development, and support of data ingestion and transformation solutions

• Perform data analysis and create data models for peer review

• Provide guidance and direction to offshore support/development resources

• Communicate with other BI team members, offshore team members, and cross-IT staff on support and project activities

• Assist with task identification and effort estimates for ETL development

• Assist with risk and issue identification

• Provide off-hour/weekend support (on a rotating basis)

• Other projects or duties as assigned

  Required Skills and Experience:

• Bachelor’s Degree in Computer Science, Information Systems, or in a related discipline

• 4+ years of ETL development experience

• 2+ years of ETL design experience

• Design and development experience utilizing scheduling/automation tools preferably in the Azure environment

• Strong communication skills, including written and verbal communication skills

• Strong problem solving and analytical skills

• Strong ETL design skills

• Excellent ETL development skills utilizing an ETL tool, preferably utilizing Azure Data Factory

• Excellent SQL skills

• Strong understanding of Dimensional Modeling and other modeling techniques

• Strong understanding of SDLC best practices with an emphasis on DW/BI/Analytics practices

• This position must pass a post-offer background and drug test

  Preferred Skills and Experience:

• Experience with orchestration in the Azure environment

• Snowflake data warehouse experience

• Azure DevOps experience

• GitHub experience

• MS Power BI experience

• Azure Blob Storage / ADLS experience with Data Storage, Analysis

• Data modeling experience

• Experience working with both structured and semi-structured data sources

• JavaScript and Python for stored procedures and scripting

• Experience leading offshore resources

• Microsoft Azure, Snowflake, and other relevant certifications

  Physical Demands and Work Environment :Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Due to the nature of our business in regard to such things as delivery schedules, order inputs, selection, and Department of Transportation Hours of Service, overtime, attendance and punctuality are essential job functions. Should an individual in this classification not be able to adhere to this requirement due to a disability, they should contact their Human Resources department to see what, if any, reasonable accommodation may be made.

Equal Opportunity Employee & Physical Demands

Reyes Holdings and its businesses are equal opportunity employers. Company policy prohibits discrimination and harassment against any applicant or employee based on race, color, religion, sex, pregnancy or pregnancy-related medical conditions, marital status, sexual orientation, gender identity or expression, age, national origin, citizenship, disability, genetic information, military or veteran status, or any other basis protected by applicable law. In addition, the Company is committed to providing reasonable accommodation to applicants and employees in accordance with applicable law. Requests for accommodation should be directed to your point of contact in the Talent Acquisition or Human Resources departments.

Background Check and Drug Screening

Offers of employment are contingent upon successful completion of a background check and drug screening.

Pay Transparency

Our compensation philosophy embraces diverse factors for fair pay decisions, valuing skills, experience, and the needs of our business. Moreover, this role may have the opportunity to participate in a discretionary incentive program, subject to program rules.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation and gender identity, national origin, disability, or protected veteran status. Drug Free Workplace.