OBJECTIVE: Iowa Soybean Association (ISA) is seeking a highly skilled Analytics Engineer to develop and execute the organization’s data strategy. The ideal candidate will have a balance of strategy and technical experience, with a strong background in data warehousing, experience with Power BI, and proficiency in Python ETL processes. As an Analytics Engineer, you will play a critical role in designing, developing, and maintaining data infrastructure and analytics solutions that enable data-driven decision-making across the organization.
ESSENTIAL FUNCTIONS
- Advise operation team and senior staff on the organization’s data strategy to optimize value to internal teams and external stakeholders
- Design, develop, and maintain scalable data pipelines and ETL processes to collect, integrate, and transform large datasets from various sources using Python.
- Build and optimize data warehouses to ensure efficient data storage, retrieval, and analysis.
- Develop interactive dashboards and reports using Power BI to provide actionable insights to stakeholders.
- Collaborate with cross-functional teams to understand business requirements and translate them into a working solution.
- Implement data quality and validation processes to ensure the accuracy and reliability of data.
- Stay up to date with industry trends, and best practices in data engineering and analytics.
COMPETENCIES
- A visionary with the ability to identify the needs of internal and external users into technical solutions
- An entrepreneur who is excited by the opportunity to build, design and impact an industry through innovation and implantation
- A collaborator who brings out the best in a team and grows better from surrounding talent and support
- A confident communicator who can clearly and concisely communicate deep technical concepts to a variety of technical and non-technical partners
- A self-starter who operates at a high level independently and takes initiative to seeks to solve problems.
- A project management wizard who thrives on organizing, managing and delivering complex projects on varying timelines.
- A humble servant leader who is confident in their ability but honest and resourceful to identify talent gaps.
TRAVEL
SUPERVISORY RESPONSIBILITY
REQUIRED EDUCATION AND EXPERIENCE
- Bachelor’s degree in Data Analytics, Information Systems, or a related field.
- 5+ years of experience in data engineering, data analytics, or a similar role.
- Proficiency in Power BI for creating dashboards and managing environments.
- Strong experience in designing and managing data warehouses (e.g., Snowflake, Redshift, BigQuery).
- Solid understanding of ETL processes and tools (e.g., Azure Data Factory, Talend, C-Data).
- Experience with SQL and relational databases (e.g., MySQL, PostgreSQL, SQL Server).
- Familiarity with cloud platforms (e.g., AWS, Azure, GCP) and their data services.
- Excellent project management skills to collaborate effectively with technical and non-technical stakeholders.
PHYSICAL DEMANDS
While performing the duties of this job, the employee is occasionally required to stand; walk; sit; use hands to finger, handle, or feel objects, tools, or controls; reach with hands and arms; climb stairs; balance; stoop, kneel, crouch or crawl; talk or hear; taste or smell. The employee must occasionally lift and/or move up to 25 pounds.
WORK ENVIRONMENT:
This job operates in a professional office environment. This role routinely uses standard office equipment such as computers, phones, photocopiers, filing cabinets, and fax machines. Various forms of technology will be used to ensure connectivity while officing remote.
Benefits
- Medical, Dental and Vision insurance
- Flexible Spending Account available
- Cellphone and Wellness reimbursement
- Onsite Fitness Center
- 401(k) with generous company match
- Tuition reimbursement program
- Dress for your Day Dress Code
