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.
Primary Focus: ETL
Design dimensional data models using Kimball data warehouse design techniques.
Develop ETL/ELT processes using Informatica.
Design and implement multi-dimensional models or "Cubes" to meet specific business requirements.
Participate in on-call rotation in support of the ETL/ELT nightly schedule.
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.
Identify opportunities for operational improvements and reduce waste using the LEAN methodology.
Troubleshoot and resolve reporting issues; data inconsistencies, scheduling, query performance.
Keep current on current trends, best practices and technologies in BI and make appropriate recommendations to technology planning team.
Analyze and evaluate existing or proposed systems. Develop, program, and configure mission-critical applications and/or web portals. Assess user requirements and provide input to departments. Liaise with other IT staff to improve system efficiency, security, and functionality.
Design and apply new methods and procedures. Develop and test systems, programs, and database structure for 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 timeframes and milestones. Provide regular status updates to supervisors and stakeholders.
Train users in technical aspects of systems.
Participate in selection and recommendation of suppliers and vendors. Assist in management of those relationships.
Balance high-priority work with lower priority maintenance work to ensure both success of projects and smooth operation of existing functions.
Proactively identify opportunities for system and process improvement. Work with management and stakeholders to prioritize and implement solutions accordingly.
Meet department and company performance and attendance expectations.
Perform other duties as assigned.
Work Experience: Minimum of 2 years of software development and analysis in a business environment. Health care insurance industry systems experience preferred.
Additional desired experience includes TriZetto Facets, technical integration and implementation, database administration, EDI (ANSI x12 formats), 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: Bachelor's in Computer Science or equivalent degree, licensure, or experience required.
Knowledge:Required technical experience may include: Debugging, software installation, programming development tools, Transact-SQL, basic knowledge and use of MS-Office suite, flowcharting, documentation, MS Visual Studio, and MS SQL Server Management Studio
Microsoft SQL Reporting Services/BI DS
Microsoft SQL Analysis Services/BI DS
Microsoft Master Data Services and Data Quality Services
Microsoft SQL Server Integration Services
Building Customer Loyalty
Building Strategic Work Relationships
Contributing to Team Success
Planning and Organizing
We are committed to doing the right thing.
We are one team working toward a common goal.
We are each responsible for our customers' experience.
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-internal and external.
We encourage creativity, innovation, continuous improvement and the pursuit of excellence.
Environment: Work inside in a general office setting with ergonomically configured equipment. Travel is required approximately 10% of the time.
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.
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.