Data Engineer

iManage•Chicago, IL

19d•$87,000 - $135,000•Hybrid

About The Position

We offer a flexible working policy that supports a healthy balance between personal and professional well-being. This role requires in-office presence on Tuesdays & Thursdays to collaborate, connect, and learn from peers - while also maintaining the flexibility for meaningful work-life balance. Being a Data Engineer at iManage means… You get excited about data, and you believe in the democratization of data to support data-driven decision making and AI. As a Data Engineer on the Enterprise Data team, you implement, support, and extend our Enterprise Data Lake that is hosted on Microsoft Azure. You gather requirements from iManage business units and craft solutions which provide access to critical business data. You will become an in-house expert in the data models of multiple, disparate enterprise SaaS systems and provide recommendations and solutions for consolidation, transformation, and integration of the disparate data sources. You will develop schemas and data pipelines for our Enterprise Data Lake and provide integration with machine learning platforms and business intelligence tools. You are enthusiastic about Delta Lake architecture and understand concepts of Delta Lake and a medallion data lake design.

Requirements

A Bachelor’s degree or higher in Computer Science or equivalent field.
1-2 years of experience working with data in a business setting.
Proficiency with data extraction, manipulation and subsequent reporting with Transact-SQL, Spark, Python, and REST APIs.
Proficiency designing data pipelines with a cloud-native mindset.
Experience with relational databases and data warehouse design using star schemas.
A passion to understand data requirements and deliver scalable, robust solutions that meet those requirements.
A passion to be a thought leader and work collaboratively within a team.
A creative mindset with a desire to explore new technologies and create innovative solutions.

Nice To Haves

Experience with Delta Lake and medallion architecture for data storage.
Experience with one or more tools for real-time data streaming, such as Microsoft Event Hub or Apache Kafka.
Experience architecting data models.

Responsibilities

Using Python and PySpark to extract, transform, and load data into our Enterprise Data Lake using a medallion architecture.
Learning and using system-specific APIs to extract data from a wide-variety enterprise SaaS applications, including Totango, Salesforce, and Zendesk.
Defining data pipelines to write data with a high degree of accuracy to enterprise SaaS applications such as Totango, Salesforce, and Zendesk.
Developing semantic models to support business intelligence tools like Power BI.
Migration of pipelines, Spark notebooks, triggers, semantic models, and Power BI dashboards from Microsoft Synapse to Microsoft Fabric.
Gathering data requirements from various business stakeholders and translating these requirements into deliverables which provide value to the business.
Working in an agile fashion aligned with our team Agile Methodologies.
Adhering to team standards for secrets management and change control.
Applying best practices to ensure the security and privacy of the data repositories.

Benefits

Join a rapidly evolving, industry-leading SaaS company on an exciting journey of growth and scalability!
Take on meaningful, high-impact challenges by leveraging cutting-edge technologies and best-in-class protocols to drive innovation.
Own my career path with our internal development framework. Ask us more about this!
Expand my skill set and earn certifications with unlimited access to LinkedIn Learning courses and interactive Microsoft courses & training.
Be part of a supportive and experienced team within a dynamic, inclusive, and encouraging culture.
Enjoy flexible work hours that empower me to balance personal time with professional commitments.
Collaborate in a modern, open-plan workspace featuring a gaming area, free snacks and drinks, and regular social events.
Creating an inclusive environment where I can help shape the culture not just by fitting in, but by adding to it.
Providing a market competitive salary that is applied through a consistent process, equitable for all our employees, and regularly reviewed based on industry data.
Rewarding me with an annual performance-based bonus.
Offering comprehensive Health/Vision/Dental/Life Insurance, and a 401k Retirement Savings Plan with a company match up to 4%.
Granting enhanced leave for expecting parents; 20 weeks 100% paid for primary leave, and 10 weeks 100% paid for secondary leave.
Providing me with a flexible time off policy to take the time off that I need. Be it for vacation, volunteering, celebrating holidays, spending time with family, or simply taking time to recharge and reset.
Having multiple company wellness days each year to prioritize mental health and well-being.
Providing access to RethinkCare, a global behavioral health platform that enhances personal well-being, strengthens professional resilience, and empowers parental success through expert-led training and resources.