Senior Software Developer - Business Intelligence
PacificSource

Job Info

---

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, national origin, sex, sexual orientation, gender identity or age.

Diversity and Inclusion: PacificSource values the diversity of the people we hire and serve. We are committed to creating a diverse environment and fostering a workplace in which individual differences are appreciated, respected and responded to in ways that fully develop and utilize each person's talents and strengths.

Provide 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. 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.

Business Intelligence Developer

Provide meaningful, accurate, consistent and actionable information to various business constituents both internal and external.

Essential Responsibilities:

• Write complex extracts and develop integration processes between BI systems using T-SQL, Informatica, SSIS, and other tools.
• Design solutions to process data, and provide integration with other systems or applications.
• Develop and test systems, programs, workflows, reports, and databases. Build unit tests to highlight risk areas in our data processes.
• Assess user requirements and provide input to departments and other IT staff to improve user productivity.
• Develop standardized parameterized reports using T-SQL and Microsoft SQL Reporting Services from multiple data sources.
• Develop enterprise dashboards using Tableau in support of multiple teams and processes.
• Focus on efficiency and effectiveness. Prepare systems specifications, project plans, and other internal documents.
• Ensure users and partners understand nature of work being performed, as well as time frames and milestones.
• Provide regular status updates to management and stakeholders.
• Work closely with related staff to upgrade and maintain systems.
• Train users in technical aspects of systems.
• Leadership role in selection and recommendation of suppliers and vendors.
• Participate in management of those relationships.
• Develop and maintain metrics to provide visibility to system functions and company operational data. Educate stakeholders on metrics.
• Advocate for standard use of technology to improve company efficiency, system accuracy and correctness, and customer value.
• Advocate use of technology to empower stakeholders.
• Prioritize work effectively to ensure both success of projects and smooth operation of existing functions.

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.

Work Experience: Minimum of 7 years of systems development and analysis. Health Insurance industry and claims/billing systems experience preferred.

Education, Certificates, Licenses: BS in Computer Science or equivalent education. Project management certification, MS or MBA preferred.

Knowledge:

• Required technical experience includes Informatica, SQL Server, SSRS/SSAS, Tableau, MS Office suite, and Windows.
• Experience with databases, data warehouse design methodologies, ETL, and SQL stored procedures.
• Experience with multiple data formats including xml, json, etc.
• Ability to learn new concepts and languages quickly.
• Ability to work in a team as well as independently.

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 5% of the time.

Our Values

• 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.

This job has expired.