Job Information
Reyes Holdings Remote ETL Architect in Rosemont, Illinois
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.
Reyes Holdings
- Reyes Holdings Jobs