Aarete - Chicago, IL
posted 3 months ago
The Consultant, Data Architecture & Engineering at AArete plays a pivotal role in leading and executing data architecture and engineering initiatives for a diverse range of clients. This position requires a collaborative approach, working closely with cross-functional teams to design, build, and maintain scalable data solutions that ensure the highest levels of data quality and availability. The consultant will be responsible for developing advanced data engineering solutions using Snowflake SQL, applying data modeling principles to maintain data integrity, and optimizing data structures. In this role, you will build scalable ETL/ELT pipelines utilizing Apache Airflow and develop clean, efficient Python scripts for data transformation and analysis. You will also collaborate with business stakeholders to translate their requirements into effective technical solutions, ensuring that the technical processes and solutions are documented comprehensively in Confluence. Additionally, you will create and maintain data visualization dashboards and reports using Power BI, facilitating collaboration through Microsoft Teams and managing code versioning with BitBucket Git repositories. Maintaining foundational AWS infrastructure components and utilizing Jira for task tracking and service ticket management will also be key responsibilities of this position.