The Aspen Group (TAG) is seeking a Senior Data Engineer to design and build data structures to facilitate reporting, models, and monitor key performance metrics, and to create a new base infrastructure for emerging brands with nascent existing data infrastructure.
Requirements
- Experience with SQL
- Hands-on experience with Python and/or other programming languages
- Experience with best practices in automated testing for automated pipelines
- Experience with building out and maintaining metrics, alarms, and monitoring of services
- Experience with MS SQL, SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS) would be a plus
- Experience in GCP, AWS, Azure would be a plus
- AWS, GCP certifications (Solution Architect, Engineering, Big Data Specialty, etc.) would be a plus
Responsibilities
- Partner cross-functionally to understand data, reporting, and data asset requirements
- Work with engineering teams to collect required data from internal and external systems
- Design ELT and ETL strategy to build performant data solutions that are reliable and scalable in a fast-growing cloud-native data ecosystem using tools such as dbt
- Rebuilding and automating legacy reporting pipelines to a new platform
- Contribute toward evolving company’s analytical self-service/ ad hoc reporting/Data Analytics/Analytical Modeling/Data Visualization process and/or product
- Contribute to evolving Data platform engineering process utilizing open-source technologies like Apache Spark, Kafka
- Develop and conduct automated testing
Other
- Bachelor's Degree or equivalent combination of education, training, and experience; Master’s Degree preferred
- 5+ years of IT/ Analytics/ Data Science experience
- Outstanding written and verbal communication skills
- Onsite 4 days/week in our Chicago office (Fulton Market District)
- A generous benefits package that includes paid time off, health, dental, vision, and 401(k) savings plan with match