NO SPONSORSHIP

Associate Principal, Data Analytics Engineering

SALARY: $110k flex plus 10% bonus

LOCATION: Chicago, IL

Hybrid 3 days in office and 2 days remote

You will be expanding analytics capabilities to design and build internal analytics within data warehouse using on-premises and cloud-based tools. You will create dashboards or visualization using the tools tableau powerBI SQL Queries Alteryx Jira services now. GIT a big plus, AWS or loud data warehouse airflow bs degree masters preferred this is working for operational risk 5 years experience building dashboards any audit risk knowledge is a plus

This role will drive a team responsible for expanding analytics capabilities by making internal corporate data accessible and usable to analysts throughout the organization.

Primary Duties and Responsibilities:

• Work closely with data analyst 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 form multiple sources and ensure data consistency and quality
• Build data models to ensure information is available in our analytics warehouse for downstream uses, such as analysis and create dashboards or visualizations using Tableau, Power BI to present insights
• Maintain performance requirements of our 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 members of the team
• Invest in your continued learning on data and analytics engineering best practices and evaluate them for fit in improving maintainability and reliability of analytics infrastructure

Qualifications:

• Ability to collaborate with multiple partners (eg, 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

Technical Skills & Background

• Ability to write and optimize complex analytical (SELECT) SQL queries
• Experience with data viz/prep tools Tableau and Alteryx
• [Preferred] Experience with SaaS tools and their backends, such as Jira and ServiceNow
• [Preferred] Applied knowledge of Python for writing custom pipeline code (virtual environments, functional programming, and unit testing)
• [Preferred] Experience with a source code repository system (preferably Git)
• [Preferred] Familiarity with at least one cloud data platform, such as AWS or GCP
• [Preferred] Experience creating and/or maintaining a cloud data warehouse or database
• [Preferred] Exposure to data orchestration tools, such as Airflow
• [Preferred] Understanding of applied statistics and hands-on experience applying these concepts
• Bachelor's degree in quantitative discipline (eg, 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, data engineer, analytics engineer, Business Intelligence analyst, data analyst, data scientist, or research analyst