Job Url: https://huron.wd1.myworkdayjobs.com/en-US/huroncareers/job/Chicago---550-Van-Buren/Data-Engineer---Market-Insights---Remote_JR-0011954?source=Indeed Job Description: Careers English Sign In Search for Jobs Introduce Yourself Data Engineer - Market Insights - Remote page is loaded Data Engineer - Market Insights - Remote Apply remote type Remote locations Chicago - 550 Van Buren time type Full time posted on Posted Yesterday job requisition id JR-0011954 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 Similar Jobs (1) Oracle Health Senior Data Analytics Engineer remote type Hybrid locations Chicago - 550 Van Buren posted on Posted 5 Days Ago About Us At Huron, we’re redefining what a consulting organization can be. We go beyond advice to deliver results that last. We inherit our client’s challenges as if they were our own. We help them transform for the future. We advocate. We make a difference. And we intelligently, passionately, relentlessly do great work…together. Are you the kind of person who stands ready to jump in, roll up your sleeves and transform ideas into action? Then come discover Huron. Whether you have years of experience or come right out of college, we invite you to explore our many opportunities. Find out how you can use your talents and develop your skills to make an impact immediately. Learn about how our culture and values provide you with the kind of environment that invites new ideas and innovation. Come see how we collaborate with each other in a culture of learning, coaching, diversity and inclusion. And hear about our unwavering commitment to make a difference in partnership with our clients, shareholders, communities and colleagues. Huron Consulting Group offers a competitive compensation and benefits package including medical, dental, and vision coverage to employees and dependents; a 401(k) plan with a generous employer match; an employee stock purchase plan; a generous Paid Time Off policy; and paid parental leave and adoption assistance. Our Wellness Program supports employee total well-being by providing free annual health screenings and coaching, bank at work, and on-site workshops, as well as ongoing programs recognizing major events in the lives of our employees throughout the year. All benefits and programs are subject to applicable eligibility requirements. Huron is fully committed to providing equal employment opportunity to job applicants and employees in recruitment, hiring, employment, compensation, benefits, promotions, transfers, training, and all other terms and conditions of employment. Huron will not discriminate on the basis of age, race, color, gender, marital status, sexual orientation, gender identity, pregnancy, national origin, religion, veteran status, physical or mental disability, genetic information, creed, citizenship or any other status protected by laws or regulations in the locations where we do business. We endeavor to maintain a drug-free workplace. Read More Get Started Follow Us