SQL/Report Developer

3 weeks ago

Palatine, United States Optum Full time

Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best. Here, you will find a culture guided by diversity and inclusion, talented peers, comprehensive benefits and career development opportunities. Come make an impact on the communities we serve as you help us advance health equity on a global scale. Join us to start Caring. Connecting. Growing together. 
 
You’ll enjoy the flexibility to work remotely * from anywhere within the U.S. as you take on some tough challenges. 
 
Primary Responsibilities: 

Develop and maintain complex SQL queries and scripts used to create data marts in Teradata
Gather business requirements and prepare analyses based on information from internal and external sources to evaluate and demonstrate program effectiveness and efficiency supporting projects and change requests
Design, develop, implement, and maintain Business Intelligence reports using healthcare claims data
Develop complex business intelligence solution and supporting data strategy leveraging acquired subject matter expertise to identify/inform opportunities/risks
Develop complex dashboards, scorecards, reports, and data analysis using X12/EDI pre-adjudicated data including 835, 277, and 837 transitions
Maintain effective communication and relationships with all individuals involved with the project
Improve the delivery and management of health and human services programs by utilizing advanced analytics, including but not limited to advanced algorithms, data visualizations, and maps
Participate in project discussions to document and recommend alternative technical solutions or requirements
Participating in unit, integration, and system testing
Perform peer-reviews and provide technical support/guidance to the project team
Support the project manager and leadership in project planning and executing activities, including presentations, risks/issues, and status reporting
Demonstrate deliverables to the team or the customers for approvals and gain buy-in to implement solutions or adapt to new products/services/programs
Work with the DBAs, data modelers, and application/system admins to support maintaining the Teradata and application server hardware and software (including patches, fixes, and upgrades) and leading industry level standards or best practices
Learn new technologies as needed to be able to perform job duties effectively
Research and consult with resources and/or industry experts to ensure the effectiveness and efficiency of systems and applications
Perform additional duties that are normally associated with this position, as assigned

 
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 provide development for other roles you may be interested in. Required Qualifications: 

5+ years Teradata version 14+ experience, including SQL Assistant/Teradata Studio
5+ years of experience developing, implementing, and maintaining complex Tableau or MS Power BI dashboards, visualizations, and analytics 
5+ years developing complex business intelligence solutions
5+ years of data warehouse project experience
5 years of experience developing complex SQL scripts (Teradata/DB2/Oracle Load Utilities) AND stored procedures
3+ years of experience using x12/EDI data including 835, 277, and 837
Experience with healthcare claims

 
Preferred Qualifications: 

5+ years of experience analyzing and delivering complex analytics using Medicaid or Managed Care claims.
3+ years of Tableau Server Administrative experience
Experience with State Medicaid / Medicare / Healthcare industry
Experience in SAP Business Objects or SAS 
Experience in Tableau or BO version upgrades
Experience in Agile
Located in Springfield, IL

 
*All employees working remotely will be required to adhere to UnitedHealth Group’s Telecommuter Policy

California, Colorado, Connecticut, Hawaii, Nevada, New Jersey, New York, Rhode Island, Washington, or Washington, D.C. Residents Only: The salary range for this role is $88,000 to $173,200 annually. Pay is based on several factors including but not limited to local labor markets, education, work experience, certifications, etc. UnitedHealth Group complies with all minimum wage laws as applicable. In addition to your salary, UnitedHealth Group offers benefits such as, a comprehensive benefits package, incentive and recognition programs, equity stock purchase and 401k contribution (all benefits are subject to eligibility requirements). No matter where or when you begin a career with UnitedHealth Group, you’ll find a far-reaching choice of benefits and incentives.
  
Application Deadline: This will be posted for a minimum of 2 business days or until a sufficient candidate pool has been collected. Job posting may come down early due to volume of applicants.
 
At UnitedHealth Group, our mission is to help people live healthier lives and make the health system work better for everyone. We believe everyone–of every race, gender, sexuality, age, location and income–deserves the opportunity to live their healthiest life. Today, however, there are still far too many barriers to good health which are disproportionately experienced by people of color, historically marginalized groups and those with lower incomes. We are committed to mitigating our impact on the environment and enabling and delivering equitable care that addresses health disparities and improves health outcomes — an enterprise priority reflected in our mission.   
 
 
Diversity creates a healthier atmosphere: UnitedHealth Group is an Equal Employment Opportunity/Affirmative Action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, national origin, protected veteran status, disability status, sexual orientation, gender identity or expression, marital status, genetic information, or any other characteristic protected by law. 
 
UnitedHealth Group is a drug - free workplace. Candidates are required to pass a drug test before beginning employment.  

  • PowerBI Developer

    2 weeks ago

    Palatine, Illinois, United States ARFA Solutions, LLC Full time

    Job OverviewARFA Solutions, LLC is seeking a skilled PowerBI Developer to design, develop, and maintain Power BI reports and dashboards for our clients. As a PowerBI Developer, you will collaborate with cross-functional teams to gather requirements, analyze data, and create visualizations that provide valuable insights to the business.Key...

  • PowerBI Data Analyst

    3 days ago

    Palatine, Illinois, United States ARFA Solutions, LLC Full time

    Job Title: PowerBI DeveloperAbout the Role:ARFA Solutions, LLC is seeking a skilled PowerBI Developer to join our team. As a PowerBI Developer, you will be responsible for designing, developing, and maintaining Power BI reports and dashboards for our clients.Responsibilities:* Design and develop Power BI reports, dashboards, and data models.* Gather and...

  • PowerBI Data Analyst

    4 days ago

    Palatine, Illinois, United States ARFA Solutions, LLC Full time

    PowerBI Developer Job DescriptionARFA Solutions, LLC is seeking a skilled PowerBI Developer to contribute to our team's success.Key Responsibilities:Design and develop Power BI reports, dashboards, and data models that meet business requirements.Analyze data to create meaningful visualizations that provide valuable insights to the business.Collaborate with...

  • PowerBI Data Analyst

    4 weeks ago

    Palatine, Illinois, United States ARFA Solutions, LLC Full time

    Job OpportunityARFA Solutions, LLC is seeking a skilled PowerBI Developer to contribute to our team's success. As a PowerBI Developer, you will be responsible for designing, developing, and maintaining Power BI reports and dashboards for our clients. You will collaborate with cross-functional teams to gather requirements, analyze data, and create...

  • Analyst - Compliance

    3 months ago

    Palatine, United States Harper College Full time

    Analyzes datasets of information using Excel, Access, and/or Statistical software.  Prepares and validates compliance reports and data submissions.  Prepares standard and custom reports for grant applications, grant evaluations, accreditation, and departments undergoing program review.  Retrieves and analyzes data from a variety of data sources...

  • Salesforce Marketing Cloud Developer

    4 weeks ago

    Palatine, Illinois, United States Weber-Stephen Products LLC Full time

    Job Title: Salesforce Marketing Cloud DeveloperWe are seeking a highly skilled Salesforce Marketing Cloud Developer to join our team at Weber-Stephen Products LLC. As a key member of our marketing team, you will be responsible for designing, developing, and implementing email campaigns that drive engagement and conversion.Responsibilities:Design and develop...

  • Compliance Data Analyst

    1 month ago

    Palatine, Illinois, United States Harper College Full time

    Job Summary: We are seeking a highly skilled Data Analyst - Compliance Specialist to join our team at Harper College. The successful candidate will be responsible for analyzing datasets of information using Excel, Access, and/or Statistical software.Key Responsibilities:Analyzes datasets of information using Excel, Access, and/or Statistical...

  • Business Development Manager

    4 weeks ago

    Palatine, Illinois, United States HOH Water Technology Full time

    Job OpportunityWe are seeking a highly skilled Business Development Manager to join our team at HOH Water Technology. As a key member of our sales team, you will be responsible for driving sales growth and identifying new business opportunities in the water treatment industry.Main Responsibilities:Prospect new business opportunities and develop key...

  • Salesforce Marketing Cloud Developer

    2 months ago

    Palatine, United States Weber-Stephen Products LLC Full time

    Responsibilities: · Build and maintain modular campaign template(s) that are responsive and incorporate brand standards and best practices. · Own development of email campaigns. Including automated campaigns, newsletters, and product recommendations. Build highly dynamic campaigns using HTML and AMPscript. · Develop and optimize email template...

  • Youth Development Professional

    3 days ago

    Palatine, Illinois, United States Boys and Girls' Club of Dundee Township Inc. Full time

    Job DescriptionJob Overview:We are seeking a dedicated and passionate Youth Development Professional to join our team at the Boys and Girls' Club of Dundee Township Inc. in Palatine Elementary After-School Enrichment. As a key member of our team, you will be responsible for planning, delivering, and overseeing fun and engaging program experiences for...

  • Assistant Director of Nursing

    2 months ago

    Palatine, United States Aperion Care Plum Grove Full time

    SUMMARY: The primary purpose of the Assistant Director of Nursing is to assist the Director of Nursing in planning, organizing, developing, and directing the day-to-day functions of the Nursing Department in accordance with current federal, state, and local standards, guidelines, and regulations that govern our facility, and as may be directed by the...

  • Project Manager/Estimator

    5 days ago

    Palatine, Illinois, United States RABINE AMERICA MAINTENANCE LLC Full time

    Job Title: Project Manager/EstimatorWe are seeking a highly skilled Project Manager/Estimator to lead our construction projects and develop strong relationships with customers.Job Responsibilities:Project Management: Manage field personnel, schedule tasks, and order supplies.Estimating: Develop and maintain estimates, proposals, and scopes of work.Client...

  • Administrative Support Specialist to Assistant Principals

    4 days ago

    Palatine, Illinois, United States Township High School District 211 Full time

    Job SummaryWe are seeking a highly organized and detail-oriented Administrative Assistant to provide administrative support to the Assistant Principals in our school district.Key ResponsibilitiesOperate the Intervention office, serving as the first point of contact for students, parents, and staff.Schedule appointments and manage calendars for the Assistant...

  • Recreation Therapist for Children

    4 weeks ago

    Palatine, Illinois, United States Little City Foundation Full time

    Job SummaryWe are seeking a highly motivated and experienced Recreation Therapist to join our team at Little City Foundation. The successful candidate will be responsible for developing and implementing recreation and fitness programs for children with autism, intellectual and developmental disabilities.Key ResponsibilitiesDevelop and facilitate recreation...

  • Corporate Engineering Internship Opportunity

    3 weeks ago

    Palatine, Illinois, United States Primient Full time

    About PrimientPrimient is a leading producer of food and industrial products from plant-based, renewable resources. We are committed to progress through investments in our operations and in your communities, our dedication to sustainability, and seamlessly integrating into and enriching people's daily lives through plant-based solutions.Our ValuesWe...

  • Youth Enrichment Instructor

    4 weeks ago

    Palatine, Illinois, United States YMCA of Metropolitan Chicago Full time

    Job Title: Before & After School - Youth Enrichment InstructorAbout the Role:We are seeking a dedicated and passionate Youth Enrichment Instructor to join our team at the Buehler YMCA. As a Youth Enrichment Instructor, you will play a vital role in creating a safe, supportive, and engaging environment for children in grades K-8. Your primary responsibility...

  • Social Worker

    1 month ago

    Palatine, Illinois, United States Little City Foundation Full time

    Job Title: Social WorkerJoin Little City Foundation as a Social Worker and make a meaningful impact in the lives of students with special needs. As a key member of our team, you will provide essential social work services to support the emotional and behavioral well-being of our students.Job Summary:We are seeking a highly skilled and compassionate Social...

  • Transportation Professional

    3 days ago

    Palatine, Illinois, United States YMCA of Metropolitan Chicago Full time

    Job SummaryAs a Transportation Professional with the YMCA of Metropolitan Chicago, you will play a vital role in ensuring the safe and efficient transportation of children and adults to and from program activities and sites. This is a unique opportunity to make a difference in your community while developing your skills in supervision, safety inspection, and...

  • Childrens Recreation Therapist

    3 months ago

    Palatine, United States Little City Foundation Full time

    Job DetailsJob Location Main Campus - Palatine, IL DescriptionPURPOSE: Provides individual and group recreation and fitness programming for the individuals served by Little City. Each Little City Recreation Therapist will have the responsibility of leading the coordination of program activities on-campus and the community to provide youth the necessary...

  • Early Childhood Education Lead

    3 weeks ago

    Palatine, Illinois, United States YMCA of Metropolitan Chicago Full time

    Job Title: Infant/Toddler Lead TeacherWe are seeking a highly skilled and dedicated Infant/Toddler Lead Teacher to join our team at the Buehler YMCA in Palatine, IL. As a key member of our Early Learning program, you will play a vital role in creating a nurturing and engaging environment for infants and toddlers, promoting their social, emotional, physical,...