Data Engineer I

Simmons Bank; Little Rock (AR); On-site; USD 65,000 - 95,000; Full time

Job summary

Simmons Bank is seeking a Data Engineer I to design, develop, and deliver data solutions across business units. The role emphasizes building data pipelines with Microsoft Power Platform and cloud services, aligning with architecture and best practices.

You will collaborate with cross-functional teams to scale reliable data engineering solutions for on-premises and cloud analytics. The position requires a Bachelor's degree in a technical field and 1–4 years of hands-on data engineering

Qualifications

• Bachelor's degree in computer science, Information Technology, Engineering, or a related field.
• 1–4 years of hands-on data engineering experience.
• Certifications PL-900, PL-400/AB-400, AB-410, PL-300; banking certification a plus

Responsibilities

• Assist in building and maintaining ETL (extract, transform, load) pipelines.
• Write basic scripts to automate data collection and preprocessing tasks.
• Integrate data from various sources into data warehouses.
• Ensure data quality and consistency across different datasets.
• Perform data cleansing and validation tasks.
• Monitor data quality and report issues to senior team members.
• Work under the guidance of senior data engineers and data scientists.
• Assist in documenting processes and maintaining technical documentation.
• Performs other duties and responsibilities as assigned.

Tools

Power Fx

PowerShell

DAX

SQL

SharePoint Online

OneDrive

Power BI

Dataverse

SQL Server

Apache Airflow

Luigi

AWS

Azure

Google Cloud

Job description

It's fun to work in a company where people truly BELIEVE in what they're doing! We're committed to bringing passion and customer focus to the business.

The Data Engineer I is responsible for designing, developing and delivering effective data solutions for different business units. This position requires advanced level knowledge of Microsoft Power Platform and cloud native services for building data engineering pipelines and data products in alignment with architecture and best practices. They will collaborate with cross-functional teams to develop and manage scalable and reliable data engineering solutions.

Job Description Simmons Bank invites you to collaborate in an agile team of peers developing and supporting on-premises & cloud-based analytics platform integrating data from a broad number of systems to enable next-gen analytical products. The Data Engineer I is responsible for designing, developing and delivering effective data solutions for different business units. This position requires advanced level knowledge of Microsoft O365 Power Platform and cloud native services for building data engineering pipelines and data products in alignment with architecture and best practices. They will collaborate with cross-functional teams to develop and manage scalable and reliable data engineering solutions.

Essential Duties and Responsibilities

• Assist in building and maintaining ETL (extract, transform, load) pipelines.
• Write basic scripts to automate data collection and preprocessing tasks.
• Integrate data from various sources into data warehouses.
• Ensure data quality and consistency across different datasets.
• Perform data cleansing and validation tasks.
• Monitor data quality and report issues to senior team members.
• Work under the guidance of senior data engineers and data scientists.
• Assist in documenting processes and maintaining technical documentation.
• Performs other duties and responsibilities as assigned.

Qualifications

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.

Skills

• Programming Languages: Proficiency in languages like Microsoft Power Fx, PowerShell, DAX, SQL
• Familiarity with SQL for database querying.
• Familiarity with O365 data products (e.g., SharePoint Online, OneDrive, PowerBI, Dataverse)
• Understanding of relational databases (e.g., Microsoft SQL Server)
• Basic understanding of data warehousing concepts.
• Familiarity with Microsoft Power Platform tools and services PowerApps, Power Automate, Power BI
• Knowledge of ETL (Extract, Transform, Load) processes.
• Basic understanding of cloud services (AWS, Azure, Google Cloud Platform) & Familiarity with data services offered by these platforms.
• Understanding of building and maintaining data pipelines.
• Familiarity with workflow orchestration tools like Apache Airflow or Luigi.
• Knowledge & experience of working in Agile Delivery model

Education and/or Experience

Bachelor's degree in computer science, Information Technology, Engineering, or a related field AND 1-4 years of practical hands-on experience with data engineering projects.

Certificates, Licenses, Registrations Certifications

Certifications in relevant technologies or tools (PL-900 (Fundamentals), PL-400/AB-400 (Developer Associate), AB-410 (Intelligent Applications Builder), PL-300 (Power BI Data Analyst)). Banking certification or experience a plus

Other Qualifications (including physical requirements)

Please note 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. Activities, duties, and responsibilities may change at any time with or without notice.

Skills Training

Problem-Solving - Ability to identify and solve technical issues. Analytical thinking for data-related problems. Careful handling of data to ensure accuracy and integrity. Ability to explain technical concepts to non-technical stakeholders. Effective collaboration with team members. Ability to work in a team environment. Willingness to learn from senior team members and contribute to team goals.

Equal Employment Opportunity Information

Simmons First National Corporation and its subsidiaries are committed to a policy of equal employment with respect to a person's race, color, religion, sex, ancestry, sexual orientation, gender identity, national origin, covered veterans, military status, physical or mental disability or any other legally protected classifications.

Since 1903, we’ve been putting people first by making a commitment to you. Simmons Bank is the subsidiary bank for Simmons First National Corporation (NASDAQ: SFNC), a publicly traded bank holding company headquartered in Arkansas. Founded as a community bank, Simmons Bank has grown steadily to its current size of $28 billion in assets, with more than 3,000 associates located in Arkansas, Kansas, Missouri, Oklahoma, Tennessee and Texas. Our growth has led to some amazing career opportunities, while our dynamic culture has been recognized by publications across our footprint. Parallel to our growth, Simmons Bank’s community roots run deep – these are felt in the ways we seek to go the extra mile for our customers and communities through exceptional service and volunteerism, and in the strong career growth opportunities and wellness programs we offer associates. Our team is characterized by collaboration, integrity and passion for all we do, high performance, and a commitment to personal and professional growth.

If these cornerstones of company culture appeal to you, let’s talk! There’s never been a better time to join our team.