Looking for a way to make an impact and help people?
Join PacificSource and help our members access quality, affordable care!
PacificSource is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to status as a protected veteran or a qualified individual with a disability, or other protected status, such as race, religion, color, sex, sexual orientation, gender identity, national origin, genetic information or age. PacificSource values the diversity of our community, including those we hire and serve. We are committed to creating and fostering a work environment in which individual differences and diversity are appreciated, respected and responded to in ways that fully develop and utilize each person’s talents and strengths.
Deliver, support and take ownership of information system solutions to internal departments and external customers and partners. Responsibilities include analyzing requirements, understanding business processes and needs, and recommending solutions to achieve the business goals. Act as the point of contact for internal and external partners in support of the solutions. Solutions will include implementation and integration of purchased applications and development of applications and integrations where appropriate. Projects are completed with cross-functional teams of IT peers and business partners. Manage time and expectations to ensure a high degree of stakeholder and user satisfaction.

Essential Responsibilities:

• Design dimensional data models using Kimball data warehouse design techniques.
• Develop ETL/ELT processes using Python and SQL on our Databricks data lake house platform.
• Design, implement and maintain multi-dimensional models or “Cubes” to meet specific business requirements.
• Participate in on-call rotation in support of the ETL/ELT nightly schedule.
• Periodically, develop standardized parameterized reports using Microsoft SQL Reporting Services from multiple data sources.
• Actively participate in the data quality improvement process by making recommendations to simplify data structures and improve information quality.
• Troubleshoot and resolve reporting issues, data inconsistencies, scheduling, query performance.

Supporting Responsibilities:

• Meet department and company performance and attendance expectations.
• Follow the PacificSource privacy policy and HIPAA laws and regulations concerning confidentiality and security of protected health information.
• Perform other duties as assigned.

SUCCESS PROFILE

Work Experience: Relevant real-world experience in software development and analysis, preferably in a business environment. Additional desired experience includes TriZetto Facets, Dynamics CRM, technical integration and implementation, database administration, EDI (ANSI x12 formats), FHIR, dashboard development, project management experience, and integration of enterprise-wide applications. Programming in VB.NET, ASP.NET, C#. Advanced experience with databases, Informatica and SQL stored procedures.
Education, Certificates, Licenses: BS in Computer Science or equivalent degree, licensure, or experience. Primary technologies/knowledge: Databricks, Python / T-SQL, Microsoft Master Data Services, Informatica MDM, Power BI, Microsoft SQL Reporting Services/BI DS, Microsoft SQL Analysis Services/BI DS, Tableau.
Competencies:
Adaptability
Building Customer Loyalty
Building Strategic Work Relationships
Building Trust
Continuous Improvement
Contributing to Team Success
Planning and Organizing
Work Standards
Environment: Work inside in a general office setting with ergonomically configured equipment. Travel is required approximately 10% of the time.
Skills:
Accountability, Collaboration, Communication (written/verbal), Flexibility, Listening (active), Organizational skills/Planning and Organization, Problem Solving, Teamwork
Our Values

We live and breathe our values. In fact, our culture is driven by these seven core values which guide us in how we do business:

• We are committed to doing the right thing.
• We are one team working toward a common goal.
• We are each responsible for customer service.
• We practice open communication at all levels of the company to foster individual, team and company growth.
• We actively participate in efforts to improve our many communities-internally and externally.
• We actively work to advance social justice, equity, diversity and inclusion in our workplace, the healthcare system and community.
• We encourage creativity, innovation, and the pursuit of excellence.

Physical Requirements: Stoop and bend. Sit and/or stand for extended periods of time while performing core job functions. Repetitive motions to include typing, sorting and filing. Light lifting and carrying of files and business materials. Ability to read and comprehend both written and spoken English. Communicate clearly and effectively.
Disclaimer: This job description indicates the general nature and level of work performed by employees within this position and is subject to change. It is not designed to contain or be interpreted as a comprehensive list of all duties, responsibilities, and qualifications required of employees assigned to this position. Employment remains AT-WILL at all times

Essential Responsibilities:

• Design dimensional data models using Kimball data warehouse design techniques.
• Develop ETL/ELT processes using Python and SQL on our Databricks data lake house platform.
• Design, implement and maintain multi-dimensional models or “Cubes” to meet specific business requirements.
• Participate in on-call rotation in support of the ETL/ELT nightly schedule.
• Periodically, develop standardized parameterized reports using Microsoft SQL Reporting Services from multiple data sources.
• Actively participate in the data quality improvement process by making recommendations to simplify data structures and improve information quality.
• Troubleshoot and resolve reporting issues, data inconsistencies, scheduling, query performance

Supporting Responsibilities:

• Meet department and company performance and attendance expectations.
• Follow the PacificSource privacy policy and HIPAA laws and regulations concerning confidentiality and security of protected health information.
• Perform other duties as assigned