Job Url: https://www.glassdoor.com/Job/united-states-python-jobs-SRCH_IL.0,13_IN1_KO14,20.htm?remoteWorkType=1&fromAge=1 Job Description: Huron Consulting Group Inc. 4.1 Data Engineer - Market Insights - Remote Apply on employer site Chicago, IL · $80K - $142K (Employer provided) Apply on employer site Your qualifications for this job Do you have any of these qualifications? Computer science SQL Analytics Data transformation Show more Huron helps its clients drive growth, enhance performance and sustain leadership in the markets they serve. We help healthcare organizations build innovation capabilities and accelerate key growth initiatives, enabling organizations to own the future, instead of being disrupted by it. Together, we empower clients to create sustainable growth, optimize internal processes and deliver better consumer outcomes. Health systems, hospitals and medical clinics are under immense pressure to improve clinical outcomes and reduce the cost of providing patient care. Investing in new partnerships, clinical services and technology is not enough to create meaningful and substantive change. To succeed long-term, healthcare organizations must empower leaders, clinicians, employees, affiliates and communities to build cultures that foster innovation to achieve the best outcomes for patients. Joining the Huron team means you’ll help our clients evolve and adapt to the rapidly changing healthcare environment and optimize existing business operations, improve clinical outcomes, create a more consumer-centric healthcare experience, and drive physician, patient and employee engagement across the enterprise. Join our team as the expert you are now and create your future. As a Data Engineer at Huron, you will be building data pipeline solutions by designing, adopting, and applying big data strategies and architectures. You must have knowledge of scalable system implementations with a focus on complex data processing and analytics pipelines. You must demonstrate an understanding of data integration, data transformation, data modeling, and data cleansing. The Data Engineer must be able to demonstrate innovative approaches to complex problems which deliver industry-leading experiences for business stakeholders. We are looking for those with a strong computer science background and the ability to quickly get up to speed with technologies they may not be familiar with. RESPONSIBILITIES Design and develop a logical data model for a large multi-tenant application with intent to facilitate consistency and efficiency. Collaborate with analysts and internal clients to understand the goals of the overall system data architecture, and further develop on business needs/issues. Test/troubleshoot problems and conduct root cause analysis. Own communications with technical contacts at software vendors to escalate software issues, recommend enhancements, and find sustainable workarounds to issues. Work in tandem with analysts and other stakeholders to develop and execute necessary processes and controls around the flow of data to meet data governance standards. Verify accuracy of table changes and data transformation processes Deliver fully tested code prior to prod-deployment when appropriate. Recommend and implement enhancements that address system performance requirements, streamline processes and improve data integrity. Create sound technical documentation and train peer developers on this documentation as development completes. Additional duties as assigned to ensure company success. QUALIFICATIONS Strong data modeling experience in DBT (Data Build Tool) for data transformations and applying best ELT (Extract, Load, Transform) practices Hands-on experience with Cloud ecosystems (preferably AWS) Strong experience with AWS Services: Redshift, Athena, S3, SNS, SQS, Lambda, Glue, DMS, EMR, EC2, Batch, CloudFormation, Step Function, CloudWatch. Strong experience with Database Platforms: AWS Redshift, MySQL or Snowflake Deep understanding of Data Lake/Lakehouse principles and technologies: Athena, Redshift, and Glue Catalog. Strong in SQL with experience in writing advanced SQL queries, SQL tuning, and Query Optimization. Proficiency in Python/PySpark for custom data processing, validation & automation tasks within data pipelines. Experience in designing and implementing innovative data integration solutions, utilizing Python with Spark clusters. Ability to optimize performance through advanced modeling, query tuning, and infrastructure optimization techniques. Familiarity with architectural patterns for data-intensive solutions Experience with batch-style data processing and familiarity with real time data processing is good to have. Ability to collaborate with business partners to understand and implement their requirements. Excellent interpersonal skills and be able to build consensus across teams. Strong critical thinking and ability to think out-of-the box. Excellent written and verbal communication skills Able to manage your own time and work well both independently and as part of a team. AWS certification is an added advantage. TECHNOLOGIES WE USE Cloud (AWS) / Data Warehouse (Redshift / Athena) / SQL/ DBT/ Python / PySpark/ Data extraction and Integration Tools (AWS DMS, Glue/Lambda/ECS) /AWS SDK / Visualization Tools (AWS QuickSight) / DevOps Tools (Azure DevOps/AWS CDK/CloudFormation) EDUCATION & EXPERIENCE 4+ years of industry experience. B.E., B. Tech or MCA preferably in Computer Science, Engineering or Science/Technology-based discipline If this sounds like the kind of challenge you would be up for every day, we would love to hear from you. The estimated base salary range for this job is $80,000 - $120,000. The range represents a good faith estimate of the range that Huron reasonably expects to pay for this job at the time of the job posting. The actual salary paid to an individual will vary based on multiple factors, including but not limited to specific skills or certifications, years of experience, market changes, and required travel. This job is also eligible to participate in Huron’s annual incentive compensation program, which reflects Huron’s pay for performance philosophy. Inclusive of annual incentive compensation opportunity, the total estimated compensation range for this job is $89,600 - $141,600. The job is also eligible to participate in Huron’s benefit plans which include medical, dental and vision coverage and other wellness programs. The salary range information provided is in accordance with applicable state and local laws regarding salary transparency that are currently in effect and may be implemented in the future. Position Level Associate Country United States of America Show less Base pay range The minimum salary is $80K and the max salary is $142K. $80K – $142K/yr (Employer provided) $111K /yr Median Chicago, IL If an employer includes a salary or salary range on their job, we display it as "Employer Provided". If a job has no salary data, Glassdoor displays a "Glassdoor Estimate" if available. To learn more about "Glassdoor Estimates," see our FAQ page. Related community posts Huron Consulting Group Inc. data engineer SR. Oracle Consultant 1w Pwc or Huron for consulting as a senior associate role? 10 Comments SR. Oracle Consultant 4d PWC or Huron for Oracle EPM? They offered me as a strong senior associate not sure what’s better. For reference i have 5 years experience at a small firm so would need to adjust to larger scopes