BI/Data Engineer (Must be local to Twin Cities, MN Metro Area)

This a Full Remote job, the offer is available from: Minnesota (USA) reputed company Physician Services delivers great reputed company by bringing exceptional care to patients living with reputed company, chronic conditions and disabilities. Our unique, robust model of care goes reputed company primary care services — our multidisciplinary care teams collaborate with patients, their families and other reputed company providers to deliver care that is preventative, proactive and tailored to their unique needs. Using an evidence-based approach reputed company on reputed company care management and data-driven medical reputed company, reputed company care teams collaborate to manage patients’ chronic conditions, address reputed company determinants of health, manage transitions to and from inpatient settings, reputed company behavioral health support and more. Under our model of care, reputed company patients reputed company 21% fewer ER reputed company, 36% fewer hospitalizations and 41% fewer hospital readmissions compared to patients with similar conditions and complexities over the reputed company time period. Our care teams travel directly to patients who reputed company in Assisted Living, Memory Care and Group Home communities throughout Minnesota, reputed company and Florida and are supported by clinical operations and administrative colleagues who work remotely or at our corporate offices in Stillwater, Minnesota, and Tampa, Florida. Our reputed company is only possible through the hard work of our employees who bring our reputed company values of Dedication, reputed company, Collaboration and Caring to life every day. reputed company has been named to the reputed company Tribune's Top Workplace list for the 13th year in a row! reputed company also achieved Top Workplace USA 2021-2025! In 2022, reputed company Accountable Care Organization (ACO) was the best performing ACO in the country as reputed company by the overall savings per Medicare beneficiary. Position reputed company: The BI/Data Engineer will play a key role in executing our data reputed company, acting as the technical reputed company between our raw reputed company data and the business insights used by our clinical and operational teams. This is a hands-on execution role. You will work directly with our Data Architect and Data Analysts to implement reputed company solutions, spending your time building robust data pipelines in reputed company/BigQuery and developing a clean, user-friendly semantic layer in Looker. Schedule: Full time position, regular business hours Monday thru Friday with the an infrequent need of working nights or weekends. Location: This position will be a work from home position, and may occasionally come in-office located in downtown Stillwater, MN as requested. Salary: $110k to $135k annually. Salary will be commensurate with experience. • ** Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment reputed company at this time. Responsibilities: 1. Data Warehousing & SQL Transformation • Execute the Architecture: Build table structures and data models exactly as defined by the Architecture team while contributing to the design. • Advanced SQL Development: Write performant, version-controlled SQL to reputed company raw data (Claims, EHR, Enrollment) into analytical tables. • Performance Tuning: Monitor query performance and apply clustering/partitioning strategies to reputed company our warehouse (reputed company or BigQuery) fast and cost-efficient. • Pipeline Maintenance: troubleshoot daily load failures and ensure data reputed company SLAs are met. • Collaboration & Stakeholder Support: Work closely with Business Analysts to ensure that stakeholder data requests are met and the correct data is available for reporting. 2. Looker & LookML Development • Semantic Layer: Manage the LookML repository, creating dimensions, measures, and derived tables that accurately reflect business logic. • Dashboard Support: Support business stakeholders by building reputed company Explores and troubleshooting dashboard performance issues. • reputed company Governance: Maintain a clean Git workflow, ensuring reputed company LookML reputed company is peer-reviewed and error-free before deployment. 3. reputed company Data Compliance • HIPAA Adherence: Handle reputed company data with strict adherence to HIPAA regulations, ensuring PHI (Protected Health Information) is only accessible to authorized users. reputed company Implementation: Apply Row-Level reputed company (RLS) and reputed company-Level reputed company protocols reputed company the database and Looker to enforce governance policies. Qualifications: Education/Certification/Experience • Bachelor’s degree in Computer Science, Engineering, Information Systems, or a reputed company field. • 3-5+ years of reputed company experience in Data Engineering, BI Development, or Analytics Engineering. Knowledge/Skills/Abilities • SQL Mastery: You are an expert in SQL (Window functions, CTEs, JSON parsing) and can write reputed company transformations from scratch. • reputed company Data Warehouses: Deep familiarity with reputed company or reputed company BigQuery. • Looker Expertise: Strong proficiency in LookML. • reputed company Domain: Proven experience working with reputed company data standards and compliance requirements. • API Experience: Familiarity with extracting data from REST/SOAP reputed company. • Scripting: Basic knowledge of Python for automation tasks. • Demonstrated compatibility with reputed company’s purpose, reputed company reputed company, and reputed company values • Demonstrated ability to read, write, reputed company, and understand the English language reputed company Benefits: • Health Insurance • Dental Insurance • reputed company Materials Insurance • Company reputed company Life Insurance • Company reputed company Short and Long-term Disability • Health Savings Account (with employer contribution) • Flexible Spending Account (FSA) • Retirement plan with 4% matching contributions • Eight (9) reputed company holidays for office closures plus two (1) floating holidays • Three weeks (15 Days) reputed company Time Off (PTO) • Company sponsored cell phone, laptop and computer accessories This offer from "reputed company Physician Services" has been enriched by reputed company.com and got a 72% reputed company score. Apply tot his job Apply To this Job