Careers

Data Engineer

We are seeking a motivated and detail-oriented Data Engineer to join our team based in Oak Brook, Illinois. As a Data Engineer, you will play a crucial role in designing, developing and maintaining scalable data pipelines and transformations for our client business-critical use cases. In addition, you may take on various Software Development and Data Science responsibilities as we frequently share responsibilities and knowledge across our growing team.

• Work Location: on site

Responsibilities:

• Design and implement data models, database schemas, and data structures in Snowflake to support efficient data storage, retrieval, and analytics.
• Optimize data models for performance and scalability by leveraging multiple patterns in snowflake features like caching, natural ordering, and clustering.
• Develop and maintain ETL (Extract, Transform, Load) or ELT (Extract, Load, Transform) processes to transform and cleanse data within Snowflake.
• Implement efficient data integration and transformation logic using Snowflake SQL, stored procedures, or external tools.
• Identify and address performance bottlenecks in data pipelines and data models. Optimize query performance, data loading, and data processing capabilities within Snowflake.
• Implement data governance practices, data privacy measures, and security controls within Snowflake. Ensure compliance with data governance policies and regulations.
• Integrate data from multiple systems and sources, ensuring data consistency, accuracy, and quality.
• Develop and maintain data connectors, APIs, and data ingestion processes.
• Maintain code in Azure Devops and develop pipelines to do continuous development and continuous integration (CD/CI).
• Monitor the health and performance of Snowflake data infrastructure, data pipelines, and data processing jobs. Troubleshoot issues and provide timely resolutions.
• Collaborate with cross-functional teams, including data scientists, data analysts, and business stakeholders, to understand data requirements, provide data engineering expertise, and support their data-related needs.

Requirements:

• 2 to 3 years of experience delivering data solutions, including data warehousing, data integration, data lake, reporting, and analytics
• Database and software development experience with SQL/T-SQL, Python, and PowerShell, and experience with MS-SQL Server/Azure, Snowflake, and/or AWS.
• Experience with API integration using Python and/or PowerShell.
• A self-starting mindset along with strong communication and collaboration skills
• Familiarity with business intelligent implementation methodologies and will have some understanding of Tableau Desktop and Tableau Server
• Experience with API integration using Python and/or PowerShell.
• Excellent analytical & troubleshooting and remediation capabilities
• Experience solving complex problems through data
• Experience translating complex problems into technical specifications
• Strong ability to multi-task and balance multiple priorities in a fast-paced environment
• Detail-oriented individual with the ability to organize tasks and work efficiently.
• A bachelor’s degree in Computer Science or closely related field