Sr Data Analyst(ETL,Data Warehousing) - Remote
Software Technology · Slaton, TX
Job description
Sr Data Analyst 100% Telecommute 9am-5pm Top Responsibilities: • Develop and manage effective working relationships with other departments, groups, and personnel with whom work must be coordinated or interfaced • Efficiently communicate with ETL architectwhile understanding the requirements and business process knowledge in order to transform the data in a way thats geared towards the needs of end users • Assist in the overall architecture of the ETL Design, and proactively provide inputs in designing, implementing, and automating the ETL flows • Investigate and mine data to identify potential issues within ETL pipelines, notify end-users and propose adequate solutions • Developing ETL pipelines and data flows in and out of the data warehouse using a combination of Azure Data Factory and Snowflake toolsets • Developing idempotent ETL process design so that interrupted, incomplete, or failed processes can be rerun without errors using ADF dataflows and Pipelines • Ability to work in Snowflake Virtual Warehouses as needed in Snowflake and automate data pipelines using Snowpipe for tedious ETL problems • Capturing changes in data dimensions and maintaining versions of them using Stream sets in snowflake and scheduling them using Tasks • Optimize every step of the data movement not only limited to source and during travel but also when it's at rest in the database for accelerated responses • Must have the ability to build a highly efficient orchestrator that can schedule jobs, execute workflows, perform Data quality checks, and coordinate dependencies among tasks • Responsible for testing of ETL system code, data design, and pipelines and data flows. Root cause analysis on all processes and resolving production issues are also a part of the process and routine tests on databases and data flow and pipeline testing • Responsible for documenting the implementations, and test cases as well as responsible for building deployment documents needed for CI/CD Required Skills: • 5+ years of Data engineering experience with a focus on Data Warehousing • 2+ years of experience creating pipelines in Azure Data Factory (ADF) • 5+ years developing ETL using Informatica PowerCenter, SSIS, Azure Data Factory, or similar tools. • 5+ years of experience with Relational Databases, such as Oracle, Snowflake, SQL Server, etc. • 3+ years of experience creating stored procedures with Oracle PL/SQL, SQL Server T-SQL, or Snowflake SQL • 2+ years of experience with GitHub, SVN, or similar source control systems • 2+ years of experience processing structured and un-structured data. • Experience with HL7 and FHIR standards, and processing files in these formats. • 3+ years analyzing project requirements and developing detailed specifications for ETL requirements. • Excellent problem-solving and analytical skills, with the ability to troubleshoot and optimize data pipelines. • Ability to adapt to evolving technologies and changing business requirements. • Bachelors or Advanced Degree in a related field such as Information Technology/Computer Science, Mathematics/Statistics, Analytics, Business Preferred Skills: • 2+ years of batch or PowerShell scripting • 2+ years of experience with Python scripting. • 3+ years of data modeling experience in a data warehouse environment • Experience or familiarity with Informatica Intelligent Cloud Services (specifically Data Integration) • Experience designing and building APIs in Snowflake and ADF (e.g. REST, RPC) • Experience with State Medicaid / Medicare / Healthcare applications • Azure certifications related to data engineering or data analytics. Team Structure: • 1 Data Manager • 1 Data Modeller • 1 Data Engineering Lead • 4 Data Engineers • Business Analyst QA Testers DBA This is a high PRIORITY requisition.
More jobs in Slaton, TX
Dedicated CDL-A Truck Drivers CDL-A Dedicated runs offer high earnings, weekly home time, unique benefits, and more! It's an exciting time for CDL-A truck drivers to join USA Truck's Dedicated division because we offer high earning potential and weekly home time plus unique benefits when you join the USA Truck team. Learn more and apply today! Why choose USA Truck CDL-A dedicated truck driver jobs? • Earn up to $114,000 per year • Earn up to $2,190 per week • 1st year earnings $80,000 - $90,000 average • Dedicated account; weekly home time • 5.5-day work schedule Benefits • Paid time off (PTO) • Paid orientation • 7 paid holiday opportunities annually • Comprehensive healthcare coverage including Medical, Dental, and Vision • Company-paid Life and AD&D insurance • Access to a wide range of voluntary benefits • CDL Defender, Family Defender, and Identity Defender coverage options • 401(k) retirement plan • HSA and FSA benefit options • Rider and pet policy • Parking reimbursement program Bonus Opportunities • Long Haul Tenure Reward • Quarterly bonus - earn an additional $0.05 CPM every quarter! • Earn up to $3,000 in driver referral bonuses for qualified referrals Equipment & Technology • Late-model trucks equipped with 1500-1800 watt inverters and 100% automatic transmissions • Advanced in-cab technology including electronic logging and GPS navigation systems CDL-A Dedicated Truck Driver Job Requirements: • Must be at least 21 years of age • 6+ months CDL A driving experience required • No DUI, DWI, or moving violations involving drugs or alcohol in the last 3 years • Stable work history • Valid CDL-A and Medical Card A more positive driver experience starts at USA Truck. Fill out our short form today! Call 844-579-0850 or Apply Online!
$83k/yr
Truck Driver Company - 1-5mo EXP Required - OTR - Dry Van - $1.2k - $1.73k per week - U.S. Xpress - OTR
U.S. Xpress - OTR · Slaton, TX
Solo OTR CDL-A Truck Drivers: $7,500 Sign On Bonus!. Solo OTR Drivers: 2,000+ Miles Per Week On Average $7,500 SIGN ON BONUS Guaranteed Weekly Minimum Pay of $1,200 Available** Top 20% of our OTR Drivers earn $1,725+ Weekly Earn $83,200 per year on average. Team Drivers: $10,000 Sign On Bonus/split...
Remote Position This position is national remote. You'll enjoy the flexibility to telecommute* from anywhere within the U.S. as you take on some tough challenges. 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 inclusion, talented peers, comprehensive benefits and career development opportunities. Come make an impact on the communities we serve as you help us advance health optimization on a global scale. Join us to start Caring. Connecting. Growing together. This position is full time, Monday - Friday. Employees are required to have flexibility to work any of our 8-hour shift schedules during our normal business hours of 8:00 am - 5:00 pm PST. It may be necessary, given the business need, to work occasional overtime. We offer weeks of on-the-job training. The hours of the training will be aligned with your schedule or will be discussed on your first day of employment. Primary Responsibilities: • Demonstrate understanding of internal / external factors that may drive caller questions / issues (e.g., recent plan changes, mass mailings, call directing / rerouting, weather emergencies) • Ask appropriate questions and listen actively to identify underlying questions / issues (e.g., root cause analysis) • Gather appropriate data / information and perform initial investigation to determine scope and depth of question / issue • Identify and coordinate internal resources across multiple departments to address client situations, and escalate to appropriate resources as needed • Proactively contact external resources as needed to address caller questions / issues (e.g., providers, labs, brokers) • Utilize appropriate knowledge resources to drive resolution of applicable questions / issues (e.g., websites, CRM tools, Onyx, Siebel, knowledge bases, product manuals, SharePoint) • Identify and communicate steps / solutions to caller questions / issues, using appropriate problem-solving skills and established guidelines, where available (e.g., workarounds, descriptions of relevant processes) • Offer additional options to provide solutions / positive outcomes for callers (e.g., online access to relevant information, additional plan benefits, workarounds for prescription delays) • Make outbound calls to resolve caller questions / issues (e.g., to callers, providers, brokers, pharmacies) • Drive resolution of caller questions / issues on the first call whenever possible (e.g., first-call resolution, one-and-done) • Ensure proper documentation of caller questions / issues (e.g., research conducted, steps required, final resolution) 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: • High School Diploma / GED OR equivalent work experience • Must be 18 years of age OR older • 1+ years of experience in a related environment (i.e., office, administrative, clerical, customer service, etc.) using phones and computers as the primary job tools • Health care experience with primary / specialty appointments OR health plans • Familiarity with computer and Windows PC applications, which includes the ability to navigate and learn new and complex computer system applications • Ability to work any of our full time, 8-hour shift schedules during our normal business hours of 8:00 am - 5:00 pm PST from Monday - Friday, including the flexibility to work occasional overtime given the business need Preferred Qualifications: • Bilingual fluency in English and Spanish • Experience with working in EPIC system • Experience with working in a remote position Telecommuting Requirements: • Ability to keep all company sensitive documents secure (if applicable) • Required to have a dedicated work area established that is separated from other living areas and provides information privacy • Must live in a location that can receive a UnitedHealth Group approved high-speed internet connection or leverage an existing high-speed internet service (UHG requires a wired internet connection: cable, DSL or fiber internet service with Minimum speed standard of 25 Mb download/10-15 Mb upload. Wireless services such as satellite, hot spot, line of sight antenna cannot be used for telecommuting.) • Ability to connect directly into internet - via hard wire (either directly to modem or router) *All employees working remotely will be required to adhere to UnitedHealth Group'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 (all benefits are subject to eligibility requirements). No matter where or when you begin a career with us, you'll find a far-reaching choice of benefits and incentives. The hourly pay for this role will range from $16 - $29 per hour based on full-time employment. We comply with all minimum wage laws as applicable. 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. UnitedHealth Group is an Equal Employment Opportunity employer under applicable law and qualified applicants will receive consideration for employment without regard to race, national origin, religion, age, color, sex, sexual orientation, gender identity, disability, or protected veteran status, or any other characteristic protected by local, state, or federal laws, rules, or regulations. UnitedHealth Group is a drug - free workplace. Candidates are required to pass a drug test before beginning employment.
Case Management Coordinator Telephonic & Community
CVS Health · Slaton, TX
Case Management Coordinator We're building a world of health around every individual — shaping a more connected, convenient and compassionate health experience. At CVS Health®, you'll be surrounded by passionate colleagues who care deeply, innovate with purpose, hold ourselves accountable and prioritize safety and quality in everything we do. Join us and be part of something bigger – helping to simplify health care one person, one family and one community at a time. Program Overview: Help us elevate our patient care to a whole new level! Join our Aetna team as an industry leader in serving dual eligible populations by utilizing best-in-class operating and clinical models. You can have life-changing impact on our members who are enrolled in Medicare and Medicaid and present with a wide range of complex health and social challenges. With compassionate attention and excellent communication, we collaborate with members, providers, and community organizations to address the full continuum of our members' health care and social determinant needs. Join us in this exciting opportunity as we grow and expand to change lives in new markets across the country. Position Summary/Mission: The Case Management Coordinator utilizes critical thinking and judgment to collaborate and inform the case management process, The Case Management Coordinator facilitates appropriate healthcare outcomes for members by aiding with appointment scheduling, identifying and assisting with accessing benefits and education for members through the use of care management tools and resources. Key Responsibilities • Evaluation of Members: Through the use of care management tools and information/data review, conducts comprehensive evaluation of referred member's needs/eligibility and recommends an approach to case resolution and/or meeting needs by evaluating member's benefit plan and available internal and external programs/services. • Identifies high risk factors and service needs that may impact member outcomes and care planning components with appropriate referral to clinical case management or crisis intervention as appropriate. • Coordinates and implements assigned care plan activities and monitors care plan progress. • Enhancement of Medical Appropriateness and Quality of Care: Using holistic approach consults with case managers, supervisors, Medical Directors and/or other health programs to overcome barriers to meeting goals and objectives; presents cases at case conferences to obtain multidisciplinary review in order to achieve optimal outcomes. • Identifies and escalates quality of care issues through established channels. • Utilizes negotiation skills to secure appropriate options and services necessary to meet the member's benefits and/or healthcare needs. • Utilizes influencing/motivational interviewing skills to ensure maximum member engagement and promote lifestyle/behavior changes to achieve optimum level of health. • Provides coaching, information and support to empower the member to make ongoing independent medical and/or healthy lifestyle choices. • Helps member actively and knowledgably participate with their provider in healthcare decision-making. • Monitoring, Evaluation and Documentation of Care: Utilizes case management and quality management processes in compliance with regulatory and accreditation guidelines and company policies and procedures. • Remote Work Expectations • Candidates must have a dedicated workspace free of interruptions • Dependents must have separate care arrangements during work hours, as continuous care responsibilities during shift times are not permitted. • Interacts with members/clients telephonically or in person. May be required to meet with members/clients in their homes, worksites, or physician's office to provide ongoing case management services. • Colleague may be required to travel up to 25-50% of the time based on member/customer-specific needs. • Ability to travel within a designated geographic area for in-person case management activities as directed by Leadership and/or as business needs arise Required Qualifications • Bachelor's degree or non-licensed master level clinician required, with either degree being in behavioral health or human services required (nursing, psychology, social work, marriage and family therapy, counseling). • Must have computer literacy in order to navigate through internal/external computer systems, including Excel and Microsoft Word. Preferred Qualifications • Case management and discharge planning experience preferred • 2 years' experience in behavioral health, social services or appropriate related field equivalent to program focus • Managed Care experience preferred • Effective communication, telephonic and organization skills • Excellent analytical and problem-solving skills • Ability to work independently • Ability to effectively participate in a multi-disciplinary team including internal and external participants. Anticipated Weekly Hours 40 Time Type Full time Pay Range The typical pay range for this role is: $21.10 - $44.99 This pay range represents the base hourly rate or base annual full-time salary for all positions in the job grade within which this position falls. The actual base salary offer will depend on a variety of factors including experience, education, geography and other relevant factors. This position is eligible for a CVS Health bonus, commission or short-term incentive program in addition to the base pay range listed above. Our people fuel our future. Our teams reflect the customers, patients, members and communities we serve and we are committed to fostering a workplace where every colleague feels valued and that they belong. Great benefits for great people We take pride in offering a comprehensive and competitive mix of pay and benefits that reflects our commitment to our colleagues and their families. The benefits for this position include medical, dental, and vision coverage, paid time off, retirement savings options, wellness programs, and other resources, based on eligibility. Additional details about available benefits are provided during the application process and on Benefits Moments.