Analyst - Data Management

Who We Are Oncourse Home Solutions, also operated as American Water Resources, is a trusted home protection provider helping homeowners across the country protect what matters most. We are a $500 million organization backed by private equity firm Apax Partners, serving 2 million customers across 43 states. We partner with 25+ utilities and municipalities (and growing!) to provide customized solutions tailored to any community - delivering real value where people live. We help homeowners protect the essential systems that keep their homes running - from HVAC, appliances, and electrical to water, sewer, gas lines, and more - so they can avoid the stress and financial impact of unexpected repairs. Our work helps homeowners stay safe, comfortable, and confident in their homes every day. Who We Are Oncourse Home Solutions, also operated as American Water Resources, is a trusted home protection provider helping homeowners across the country protect what matters most. We are a $500 million organization backed by private equity firm Apax Partners, serving 2 million customers across 43 states. We partner with 25+ utilities and municipalities (and growing!) to provide customized solutions tailored to any community - delivering real value where people live. We help homeowners protect the essential systems that keep their homes running - from HVAC, appliances, and electrical to water, sewer, gas lines, and more - so they can avoid the stress and financial impact of unexpected repairs. Our work helps homeowners stay safe, comfortable, and confident in their homes every day. At Oncourse, our people are what makes that possible. We call ourselves SUPERs - Successful, United, Progressive, Empathetic, and Reliable - because that’s how we show up for our customers and for each other. We invest in our employees through competitive benefits, an inclusive culture, and employee-led resource groups that strengthen connection, community, and belonging across the company. As an equal opportunity employer, our employment decisions are based on business needs, job requirements and individual qualifications without regard to race, color, religion, age, sex (including pregnancy), sexual orientation, gender identity, national origin, ancestry, marital status, parental status, mental or physical disability, military or veteran status, or any other basis protected by federal, state, or local law. Oncourse Home Solutions is committed to recruiting and retaining talented applicants and to providing all employees with a workplace free from discrimination and/or harassment. Position Summary The Data Management Analyst leverages AI, advanced analytics, and modern data engineering practices to transform business and customer data into actionable insights, scalable data products, and reliable decision-support capabilities while partnering across Finance, Marketing, Contact Center, SPG, Data Science, and BI teams. Located at our office in Naperville, our office environment is a key driver of our company culture and employee experience, so a regular in-office hybrid model (T-TH in office and M & F remote) is required. Responsibilities Include But Are Not Limited To Develop and maintain dbt pipelines (dbt Core) and metadata-driven SQL frameworks. Develop and maintain LookML models, explores, and dashboards to deliver governed, analytics-ready data products and scalable self-service reporting capabilities. Build analytics-ready datasets and data products in partnership with Data Science and BI teams. Apply software engineering best practices including Python, object-oriented design, GitHub, and CI/CD automation. Author tests, monitoring, and alerting to ensure data quality, platform reliability, and operational excellence. Investigate and resolve data incidents and support ongoing platform maintenance and optimization. We're Excited if this is You! Experience And Qualifications Of The Role 2+ years of experience in analytics engineering, business intelligence, data engineering, or related data-focused roles. Proven ability to translate business requirements into scalable data products, analytics solutions, and actionable insights. Strong SQL, data modeling, and data transformation skills. Experience building and maintaining analytics-ready datasets, semantic data models, and data warehouse solutions. Experience developing and supporting data pipelines using modern data stack technologies such as dbt, Snowflake, and Git. Demonstrated ability to implement code versioning standards, participate in peer code reviews, and work within CI/CD development processes. Strong analytical and problem-solving skills with a focus on automation, data quality, observability, and platform reliability. Experience partnering with business stakeholders and technical teams to deliver data-driven solutions. Excellent written and verbal communication skills, including the ability to explain complex technical concepts to non-technical audiences. Effective in both independent and collaborative environments with working knowledge of Agile/Scrum methodologies. Experience leveraging AI-assisted development tools and modern automation techniques is a plus. Computer Skills Needed To Perform The Job Advanced SQL proficiency for data transformation, analysis, and optimization. Experience with Snowflake or other modern cloud data warehouse platforms. Experience with dbt (preferred) or similar data transformation frameworks. Experience with Git, GitHub, and CI/CD workflows. Proficiency in Python for data processing, automation, and troubleshooting. Experience developing and supporting business intelligence solutions using Looker, including LookML modeling and dashboard development. Understanding of ETL/ELT architectures, data pipeline orchestration, and data quality practices. Experience working with large-scale datasets and relational databases. Familiarity with AI-assisted development and productivity tools is a plus. Proficiency in Microsoft Office Suite (Excel, Word, Outlook, PowerPoint). Education Bachelor’s degree in computer science, information technology, or equivalent experience. Certificates, Licenses, Registrations Certification in Snowflake, Certification in Tableau or any other BI Tool We offer a compelling total rewards package that includes a competitive base salary and comprehensive benefits to support your total wellbeing. The base pay range for this position is $79,475 - $111,250 USD Annual. The specific pay offered will depend on qualifications, experience, education and skill set. The compensation offered may also include an annual performance-based bonus, sales incentive plan or commission target. Our benefits include, but are not limited to, healthcare, life insurance, paid time off, retirement, commuter benefits, and education reimbursement. Exact compensation may vary based on skills, experience, and location. Join our SUPER Team and Enjoy Amazing Benefits! Competitive Compensation: We value your hard work and are proud of our competitive pay for performance philosophy. Comprehensive Health Coverage: Medical, dental, and vision insurance options, plus paid short-term and long-term disability coverage. 401(k) Plan with 4% Company Match: Secure your future with our robust retirement plan. Generous Paid Time Off: Take the time you need to recharge and relax. Education Assistance Program: Invest in your growth and development with our support. FSA/HSA Options: Flexible spending and health savings accounts to manage your transportation and dependent care expenses. Employee Wellness: Access to EAP, health, legal, and financial resources to support your overall well‑being. Vibrant Company Culture: Monthly Townhalls, employee recognition programs, and Employee Business Resource Groups (EBRGs) to keep you engaged and connected. Competencies Decision Quality - Makes good decisions (without considering how much time it takes) based upon a mixture of analysis, wisdom, experience, and judgment; most of his/her solutions and suggestions turn out to be correct and accurate when judged over time; sought out by others for advice and solutions. Communicate Effectively - Is able to clearly and succinctly communicate verbally and in writing in a variety of settings and styles; can get messages across that have the desired effect. Strategic Agility - Sees ahead clearly; can anticipate future consequences and trends accurately; has broad knowledge and perspective; is future oriented; can articulately paint credible pictures and visions of possibilities and likelihoods; can create competitive and breakthrough strategies and plans. Presentation Skills - Is effective in a variety of formal presentation settings: one- on - one, small and large groups, with peers, direct reports, and bosses; is effective both inside and outside the organization, on both cool data and controversial topics; commands attention and can manage group process during the presentation; can change tactics midstream when something isn't working. Problem Solving - Is tolerant with people and processes; listens and checks before acting; tries to understand the people and the data before making judgments and acting; waits for others to catch up before acting; sensitive to due process and proper pacing; follows established process. Drive for Results - Can be counted on to exceed goals successfully; is constantly and consistently one of the top performers; very bottom-line oriented; steadfastly pushes self and others for results. #J-18808-Ljbffr Oncourse Home Solutions