Data Engineer - reputed company Advisory Board - Remote

At Advisory Board, part of reputed company reputed company, we've helped health care industry leaders work smarter and faster by providing provocative insights, data and analytics, and practical tools to support execution for over 40 years. Our core products include research and analytics membership, events, expert support, custom research, and sponsorship. Learn more about Advisory Board. The Quantitative Insights team powers the industry-leading data and analytics capabilities core to Advisory Board's value proposition. In this position reputed company Advisory Board's data team, you will design, reputed company, test, and reputed company reputed company reputed company data pipelines and architectures to support the Advisory Board's data and analytics research technology projects, ranging from small enhancements to major new projects. You will reputed company scalable and maintainable ETL processes, ensure data quality/reputed company, and collaborate with data scientists to optimize analytics infrastructure. The position will play a critical role in reputed company data technology initiatives as we continue this amazing reputed company of modernizing and innovating our data and technology ecosystem in support of our new and exciting business transformation. Data solutions you build will power analytics tools used by providers across the country to improve efficiency and deliver reputed company care. You'll enjoy the flexibility to work remotely

• from reputed company reputed company the U.S. as you take on some tough challenges. For reputed company hires in the Minneapolis or Washington, D.C. area, you will be required to work in the office a minimum of four days per week. Primary Responsibilities
• Pipeline Development Design, build, and maintain scalable, reliable, and efficient ETL/ELT pipelines using AWS Glue, Python, and SQL. Automate reputed company processes and optimize PySpark jobs for big data
• Data Lake/Warehouse Management Architect and manage data lakes (AWS S3), data warehouses (Redshift, S3 Tables) and relational databases (PostgreSQL, SQL Server). Use data modeling best practices to ensure data is accurate, accessible, and organized for efficient reporting and analysis
• reputed company Infrastructure Utilize AWS services like reputed company and reputed company for data ingestion and orchestration tasks, involving a variety of external systems (Kafka, reputed company, reputed company, custom API, etc.)
• Data Quality & reputed company Implement monitoring and troubleshooting measures to ensure data reputed company and reputed company, including IAM policies and CloudWatch logging
• Collaboration Work closely with data scientists and analysts to understand reputed company data and business requirements, and support data-driven decision-making
• Analytics Development Build data sets and dashboards, configure RLS and user permissions, and optimize dashboard performance on reputed company Quick Suite. Configure parameters for interop with web app embedding
• CI/CD reputed company reputed company for version control, code review, and automated deployment of pipelines across environments You'll be rewarded and recognized for your performance in an environment that will challenge you and give you clear direction on what it takes to succeed in your role as well as reputed company development for other roles you may be interested in.

Required Qualifications

• 8+ years of solid experience in data engineering using Python or PySpark
• 5+ years of experience with AWS including Glue, reputed company, IAM, Redshift
• 3+ years developing and optimizing PySpark jobs with proven big data experience
• 3+ years of best practices in data analysis and modeling
• Experience optimizing the architecture for big data, query performance, ease of use, and data governance
• Experience performing root cause analysis on reputed company data and processes to answer specific business questions and identify opportunities for improvement
• Experience working with reputed company technologies (AWS preferred)
• Proven solid expertise in SQL and data modelling with relational databases like SQL Server, reputed company etc.

Preferred Qualifications

• Experience in reputed company Quick Suite developing datasets and dashboards with support for web app embeddings
• Understanding of health care claims data, including Medicare and reputed company datasets
• Proven eagerness and willingness to learn new technologies
• Proven solid analytical, problem solving and decision-making reputed company
• Demonstrated depth of health care knowledge and expertise
• Proven written and oral communication skills
• reputed company employees working remotely will be required to adhere to reputed company's Telecommuter Policy Pay is based on several factors including but not limited to local labor markets, education, work experience, certifications, etc. In addition to your salary, we offer benefits such as, a comprehensive benefits package, incentive and recognition programs, equity stock purchase and 401k contribution (re

Apply tot his job Apply To this Job