Data Analytics Engineer

Request Technology - Chicago, IL

Full-time

Chicago, IL

Administrative and Support Services

About the position

The Data Analytics Engineer will play a crucial role in enhancing the analytics capabilities of a prestigious financial company by making internal corporate data accessible and usable for analysts across the organization. This position involves designing and building the internal analytics data warehouse, maintaining extract, load, and transform processes, and supporting teams in leveraging corporate data for data-driven decision-making. The role requires collaboration with business users and technical teams to facilitate exploration and analysis of data using both on-premise and cloud-based tools.

Responsibilities

• Work closely with data analysts and business stakeholders to understand their data needs and provide support in data access, data preparation, and ad hoc queries.
• Automate data processes to reduce manual interventions, improve data processing efficiency, and optimize data workflow for performance scalability.
• Integrate data from multiple sources and ensure data consistency and quality.
• Build data models to ensure information is available in the analytics warehouse for downstream uses, such as analysis and creating dashboards or visualizations using Tableau and Power BI.
• Maintain performance requirements of the analytics warehouse by tuning optimizations and processes.
• Create documentation and testing to ensure data is accurate and easily understandable.
• Promote self-service capabilities and data literacy for business users leveraging the platform through development of training presentations and resources.
• Discover and share best practices for data and analytics engineering with team members.
• Invest in continued learning on data and analytics engineering best practices and evaluate them for fit in improving maintainability and reliability of analytics infrastructure.

Requirements

• Ability to collaborate with multiple partners (e.g., Corporate Risk, Compliance, Audit, Production Operations, DBAs, Data Architecture, Security) to craft solutions that align business goals with internal security and development standards.
• Ability to communicate technical concepts to audiences with varying levels of technical background and synthesize non-technical requests into technical output.
• Comfortable supporting business analysts on high-priority projects.
• High attention to detail and ability to think structurally about a solution.
• Experience working within an agile environment.
• Ability to write and optimize complex analytical (SELECT) SQL queries.
• Experience with data visualization/preparation tools (preferably Tableau and Alteryx).
• Bachelor's degree in a quantitative discipline (e.g., Statistics, Computer Science, Mathematics, Physics, Electrical Engineering, Industrial Engineering) or equivalent professional experience.
• 5+ years of experience as a business analyst, data analyst, data engineer, research analyst, analytics engineer, Business Intelligence analyst, or data scientist.

Nice-to-haves

• Experience with SaaS tools and their backends, such as Jira and ServiceNow.
• Applied knowledge of Python for writing custom pipeline code (virtual environments, functional programming, and unit testing).
• Experience with a source code repository system (preferably Git).
• Familiarity with at least one cloud data platform, such as AWS or GCP.
• Experience creating and/or maintaining a cloud data warehouse or database.
• Exposure to data orchestration tools, such as Airflow.
• Understanding of applied statistics and hands-on experience applying these concepts.
• Master's degree.

Benefits

• Bonus eligibility