Junior Data Engineer

Fayetteville, GA - USA

Monthly Salary: $ 20 - 30

Posted on: 5 hours ago

Vacancies: 1 Vacancy

Job Summary

Apprenticely is helping Walton Arts Center hire a Junior Data Engineer in Fayetteville AR & Rogers AR.

About the Employer:

At Walton Arts Center/Walmart AMP we strive to be the place where a diverse mix of talented people want to come to stay and do their best work. We pride ourselves on bringing the best Arts and Entertainment to our audiences in Northwest Arkansas and we know our organization runs on the hard work and dedication of our passionate and creative Arts Center and the Walmart AMP aspire to be welcoming spaces where people can be their authentic selves. We value diversity and inclusivity in every aspect of our operations.

$20 - $30 an hour

The Junior Data Engineer at the Walton Arts Center and Walmart AMP is a critical role responsible for building and maintaining data systems data warehouses and data pipelines to enable data-driven decision-making. This role collaborates with the Senior Director of Technology Services and other teams to strategize and implement roadmaps for data management ensuring data integrity security and accessibility across platforms.

Principle Responsibilities (Essential Functions)

Build and maintain reliable ETL/ELT pipelines that move data from core systems (ticketing CRM F&B digital platforms finance systems etc.) into Snowflake.

Write clean SQL queries views and transformations across SQL Server Snowflake and PostgreSQL/MySQL in support of analytics dashboards and operational needs.

Perform routine data quality checks validation steps and error handling to ensure accuracy and trust in our data sources.

Assist in integrating cloud storage systems (Azure Blob AWS S3) with Snowflake using COPY commands file stages and automated workflows.

Develop and schedule batch jobs and automated processes to keep data refreshed across systems.

Support Power BI dashboard development by preparing optimized datasets modeling relationships monitoring refresh schedules and resolving performance issues.0

Partner with business units to gather report requirements translate them into technical specifications and deliver clear and actionable insights.

Monitor daily pipelines system performance and data model health escalating issues before they impact the business.

Troubleshoot and debug data failures broken feeds or mismatched numbers between source systems and Snowflake.

Document data flows pipeline logic table definitions and reporting standards to maintain clarity and consistency across the Technology Services division.

Participate in data governance efforts including privacy security and compliance alignment across platforms.

Support AI and automation initiatives by preparing datasets for analysis assisting with feature engineering and validating model outputs when needed.

Position RequirementsTechnical Skills & Knowledge

Strong SQL skills including SELECT/INSERT/UPDATE/DELETE JOINs GROUP BY window functions and query optimization.

Experience with Snowflake: data loading COPY commands warehouse usage JSON parsing tables and views.

Familiarity with SQL Server PostgreSQL/MySQL and general relational database concepts.

Basic understanding of the Azure ecosystem (Blob Storage Functions Monitor) and AWS services (S3 Lambda).

Python skills for scripting API calls data manipulation with pandas/numpy file processing and automation tasks.

Power BI fundamentals: data modeling relationships basic DAX and report/dashboard building.

Strong Excel skills: advanced formulas pivot tables and data analysis.

Understanding of ETL/ELT concepts pipeline design and data modeling best practices.

Ability to work with multiple file formats including CSV JSON XML and Parquet.

Experience with version control (Git) branching strategies and collaboration workflows.

Basic DevOps understanding: deployments environments monitoring and resource troubleshooting.

Awareness of cost optimization principles for cloud platforms and data operations.

Professional Skills

Strong analytical and problem-solving skills with the ability to debug and resolve data issues quickly.

Ability to communicate clearly with both technical and non-technical stakeholders.

Experience gathering requirements from business users and translating them into reporting or data solutions.

Demonstrated ability to create clean concise technical documentation.

Understanding of data governance fundamentals including privacy security and compliance.

Ability to present insights in a clear structured and accessible way (data storytelling).

Ability to work independently while also collaborating closely with the Director of Technology Services Data Engineer and Technology Services team.

Strong attention to detail consistency and accuracy.

Physical and Work Environment Requirements

Must be able to lift and carry up to 50 lbs.

Ability to sit or stand for extended periods.

Must be able to work under pressure and meet deadlines.

Ability to work independently and within a team.

Occasional evening and weekend work required for events.

Whats an Apprenticeship An apprenticeship is a full time position with a focus on learning! During your first year of employment you are guaranteed formal training a mentor and a pay raise! Employers who have committed to the apprenticeship model for hiring are committing to building you and your career. Youre encouraged to apply even if your experience doesnt precisely match the job description. Apprenticeship positions welcome diverse applicants who are looking to grow their career in IT!

How does the interview process work We want to get to know you! Apprenticely will conduct an initial phone interview and knowledge assessment. If your skills and interest match with the employers needs well share your resume or ask you to apply directly with them. After that the employers will continue with their recruiting and interview process. If you are a match an offer will be made for you to get started in your new apprenticeship role! Well be here to make sure your apprenticeship year goes smoothly and that you are set up for career growth and success!

Keep in touch with us on social media

Linkedin . Facebook . Instagram

The Arkansas Center for Data Sciences dba Apprenticely will not discriminate against apprenticeship applicants or apprentices based on RACE COLOR RELIGION NATIONAL ORIGIN SEX (INCLUDING PREGNANCY AND GENDER IDENTITY) SEXUAL ORIENTATION GENETIC INFORMATION OR BECAUSE THEY ARE AN INDIVIDUAL WITH A DISABILITY OR A PERSON 40 YEARS OLD OR OLDER. Apprenticely will take affirmative action to provide equal opportunity in apprenticeship and will operate the apprenticeship program as required under Title 29 of the Code of Federal Regulations part 30

SMS terms: Arkansas Center for Data Sciences (ACDS) DBA Apprenticely offers you the option to engage in SMS text conversations about your application for jobs and training programs. By participating you also understand that message frequency may vary depending on the status of your job application and that message and data rates may apply. Please consult your carrier for further information on applicable rates and fees. Carriers are not liable for delayed or undelivered messages. Reply STOP to cancel and HELP for help. View our Privacy & SMS Policy: may use artificial intelligence (AI) tools to support parts of the hiring process such as reviewing applications analyzing resumes or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed please contact us.

Required Experience:

Junior IC

Apprenticely is helping Walton Arts Center hire a Junior Data Engineer in Fayetteville AR & Rogers AR.About the Employer:At Walton Arts Center/Walmart AMP we strive to be the place where a diverse mix of talented people want to come to stay and do their best work. We pride ourselves on bringing the ...