Data Analytics Engineering - Tableau/Alteryx

NO SPONSORSHIPAssociate Principal, Data Analytics EngineeringSALARY: $110k flex plus 10% bonusLOCATION: Chicago, ILHybrid 3 days in office and 2 days remoteYou 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 plusThis 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 queriesAutomate data processes to reduce manual interventions, improve data processing efficiency and optimize data workflow for performance scalabilityIntegrate data form multiple sources and ensure data consistency and qualityBuild 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 insightsMaintain performance requirements of our analytics warehouse by tuning optimizations and processesCreate documentation and testing to ensure data is accurate and easily understandablePromote self-service capabilities and data literacy for business users leveraging the platform through development of training presentations and resourcesDiscover and share best practices for data and analytics engineering with members of the teamInvest in your continued learning on data and analytics engineering best practices and evaluate them for fit in improving maintainability and reliability of analytics infrastructureQualifications: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 standardsAbility to communicate technical concepts to audiences with varying levels of technical background and synthesize non-technical requests into technical outputComfortable supporting business analysts on high-priority projects.High attention to detail and ability to think structurally about a solutionExperience working within an agile environmentTechnical Skills & BackgroundAbility to write and optimize complex analytical (SELECT) SQL queriesExperience 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 conceptsBachelor's degree in quantitative discipline (eg, Statistics, Computer Science, Mathematics, Physics, Electrical Engineering, Industrial Engineering) or equivalent professional experience5+ 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