This position works on-site at downtown Des Moines, IA campus.
This position is responsible for ingesting, processing, transforming, and modeling data to ensure it is ready for consumption. This role involves working with complex data pipelines, designing efficient data architectures, and developing automated systems to guarantee the availability of clean, accurate, and structured data. The Data Engineer collaborates closely with cross-functional teams, including data scientists and data analysts, to improve operational efficiency by enhancing data flow, integration, and accessibility to support real-time decision-making, business intelligence, and analytical initiatives. Additionally, the Data Engineer plays a key role in identifying and addressing data quality issues, and implementing best practices for data governance and security.
Responsibilities:
Carrying out the Company's organizational values and operating in accordance with applicable laws, regulations, and Company policies are rquired functions. Essential and other important responsibilities and duties may include, but are not limited to, the following:
- Data Modeling: Develop and implement data models and schemas to support data integration, storage, and analytics, ensuring data is structured optimally for both transactional and analytical use cases. Develop and maintain data models that align with business requirements and optimize data storage. Merge data from diverse sources to create a unified view.
- Pipeline Development: Collaborate with data teams to understand data needs and design reusable, configurable data pipelines for efficient data ingestion. Build scalable pipelines for seamless ETL (Extract, Transform, Load) processes, integrating data from any source. Ensure timely, accurate data integration and transformation.
- Monitoring and Maintenance: Regularly monitor the health of data systems and pipelines, performing regular maintenance, and troubleshooting issues that arise. Identify poor performing processes to add efficiencies and lower overall costs. Ensure that processes alert when something does not work as expected so the team can respond accordingly.
- Data Quality & Consistency: Ensure data is accurate, consistent, and reliable. This involves identifying and fixing data issues, performing data validation, and ensuring data quality controls are in place.
- Performance Optimization: Optimize the performance of data systems to ensure they can handle large volumes of data efficiently and cost effectively. This might involve query optimization, partitioning strategies, or code efficiency enhancements.
- Documentation: Create and maintain clear documentation of data processes, architectures, and workflows for knowledge sharing.
- Security & Compliance: Ensure data is handled securely and in compliance with company policy and relevant regulations. This might include encryption, access controls, and auditing.
- Continuous Learning and Skill Development: Stay updated on the latest trends, tools, and best practices in data engineering and related fields. Encourage a culture of continuous improvement and innovation within the team.
- Perform other job-related duties and special projects as required.
Requirements:
Job Requirements/Minimum Qualifications:
Bachelor's Degree or equivalent work experiences
Course(s) of Study: Computer Science, MIS, Mathematics, Engineering or related focus
Experience: 3 - 5 years
Type of Experience: Data Modeling, Development
Required Knowledge, Skills, and Abilities:
- Must be able to commit to Ruan's value statement by acting with integrity in everything we do.
- Must be able to meet behavioral expectations and perform in alignment with our guiding principles: safety, people, customer, performance, and continuous improvement.
- In-depth expertise with Cloud data services, storage and advanced management of data pipelines using a varied range of cloud data services to design complex, high performance ETL/ELT workflows that support enterprises-scale data solutions. Strong ability to architect and design complex, scalable cloud infrastructures with a focus on distributed systems, leveraging services to create resilient, cost-effective data pipelines and processing systems that align with business requirements and evolving needs. Lead the design and implementation of data governance frameworks. Expertise in enforcing data privacy and governance policies, aligning data systems with organizational data policies. Experience writing complex, optimized T-SQL queries. Analytics, with advanced knowledge in partitioning, indexing, and query execution plan analysis to ensure high performance and responsiveness in large-scale data systems. Proficiency in programming code for developing and optimizing Spark-based data processing workflows Knowledge in security features for role-based access control (RBAC), managing secrets and keys, and security centers for security monitoring, as well as familiarity with compliance for adhering to regulatory standards or organization policies. Experience with automating the setup of data systems, pipelines, and security configurations.
- Proven track record of working with cross-functional teams including data scientists, data analysts, and cloud architects to ensure the alignment of data infrastructure with business goals. Experience leading team efforts in using systems to support data-driven decision-making and machine learning initiatives.
- Expertise in building/release pipelines, and implementing sophisticated continuous integration/continuous deployment (CI/CD) practices. Responsible for designing and automating CI/CD pipelines for large-scale data workflows, ensuring high-quality, error-free data processes in production environments.
Physical Demands of the Job:
Team member must be able to twist, bend, pull, push and lift up to 25 pounds. May work in excess of 8 hours per day, 40 hours per week, as required to perform essential functions. Team member will be required to stand, walk, sit, use fingers, reach with hands and arms, stoop, kneel, and crouch. Team member will present a neat, clean appearance of self, and use professional business etiquette and language. Must be able to operate office equipment; including telephone, copy/fax machine, personal computer, have reasonable accuracy and speed on ten key skills or/and keyboarding.
Environmental Demands of the Job:
Typical office environment
Reporting Relationships:
Reports to: Manager, IT or Director IT
Direct Reports: N/A
Benefits: Ruan provides benefits which include: Medical, Dental, Vision, Disability, Life, as well as 401k and Paid Time off.
