Junior Data Engineer en Arkansas Center for Data Science
Arkansas Center for Data Science · Fayetteville, Estados Unidos De América · On-site
- Oficina en Fayetteville
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 employees. Walton 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.
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 Requirements Technical 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.
What's 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. You're encouraged to apply even if your experience doesn't 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 employer's needs, we'll 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! We'll 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
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: https://apprenticely.org/privacy-policy/
Solicitar ahora
