Job Description :
Purpose of the Job:
Creates and implements business intelligence and extract, transform, and load (ETL) solutions using programming, performance tuning, data modeling, based on BCBSAZ SQL database design and implementation standards, corporate policies, industry best practices, and customer-based business requirements.
Essential Job Functions and Responsibilities:
LEVEL 1 - Performs job functions under close supervision or peer review
Learn area''s direct flow; and how it affects surrounding systems and operational areas.
Design, maintain, develop, and enhance basic-level business intelligence systems and programs.
Design & Implement Extract, Transform, and Load (ETL) solutions including SSIS & DTS programming based on BCBSAZ SQL database design and implementation standards
Apply data mining rules
Design and code basic-level systems, programs, and interfaces, using the appropriate structured programming techniques and programming languages.
Participate in the development, review, and creation of documentation used to support associated systems.
Create logic, system, and program flows for complex systems, including interfaces and metadata
Write and execute unit test plans. Track and resolve any processing issues.
Implement and maintain operational and disaster-recovery procedures.
Participate in small to medium projects.
Participate in the review of code and/or systems for proper design standards, content and functionality.
Assist with development and delivery of presentations to staff and management
Participate in all aspects of the Systems Development Life Cycle
Analyze files and map data from one system to another
Adhere to established source control versioning policies and procedures
Develop programs, time estimates and project schedules based on prioritization and business requirements.
Use sound project management methodology and demonstrate solid time management skills.
Monitor and create priority list(s) that are agreed to by user management
Meet timeliness and accuracy goals.
Communicate status of work assignments to stakeholders and management.
LEVEL 2 - Performs job functions with general supervision
Design, maintain and develop moderately complex systems and programs
Participate or lead medium projects.
Track and resolve processing problems, coordinating with all appropriate areas
Assist Users/Analysts with the development of system interface specifications
Develop, write and implement processing requirements and post implementation review
Develop time and cost estimates and system modification schedules.
Create and deliver presentations to staff and management.
ALL LEVELS:
Responsible for technical and production support documentation in accordance with department standards and industry best practices.
Each progressive level includes the ability to perform the essential functions of any lower levels and mentor employees in those levels.
Maintain current knowledge on new developments in technology-related industries
Participate in corporate quality and data governance programs
Participate in on-call rotation
The position requires a full-time work schedule. Full-time is defined as working at least 40 hours per week, plus any additional hours as requested or as needed to meet business requirements.
Perform all other duties as assigned
Required Work Experience:
1 year of experience in computer programming, query design, and databases (Applies to Level 2)
Required Education:
High-School Diploma or GED in general field of study
Preferred Work Experience:
2 years of experience in working with healthcare systems as a programmer
2 years of experience managing projects
1 year of supervisory experience
Preferred Education:
Associate''s Degree in Computer Science or Business Administration
Bachelor''s Degree in Computer Science or Business Administration
Preferred Certifications:
MS SQL Certification or other certification in current programming languages
Required Job Skills:
Intermediate skill in use of office equipment, including copiers, fax machines, scanner and telephones
Intermediate PC proficiency
Intermediate proficiency in spreadsheet, database and word processing software
Advanced knowledge of business intelligence, programming, and data analysis software
Intermediate knowledge of Microsoft SQL databases.
Intermediate proficiency in SSIS, DTS, T-SQL, ActiveBatch, Redgate, stored procedure development, tuning, enterprise data modeling and schema change management.
Required Professional Competencies:
Strong analytical skills to support independent and effective decisions
Ability to prioritize tasks and work with multiple priorities, sometimes under limited time constraints.
Perseverance in the face of resistance or setbacks.
Effective interpersonal skills and ability to maintain positive working relationship with others.
Verbal and written communication skills and the ability to interact professionally with a diverse group, executives, managers, and subject matter experts.
Systems research and analysis. Ability to write and present business intelligence documentation
Demonstrate the ability to stay current on global threats and vulnerabilities.
Experience working with and managing third parties
Knowledge of business requirements development and user acceptance testing.
Maintain confidentiality and privacy
Analytical knowledge necessary to generate reports based on available data and then make decisions based on reported data
Required Leadership Experience and Competencies:
Facilitate and resolve customer requests and inquiries for all levels of management in Corporation
Preferred Job Skills:
Advanced skill in use of office equipment, including copiers, fax machines, scanner and telephones
Advanced PC proficiency
Advanced knowledge of Business Objects
Advanced knowledge of Microsoft Applications and Suites, Windows Server, and Microsoft SQL databases.
Advanced knowledge of decision support systems
Advanced proficiency with relational technologies that supplement RDBMS tool sets
Advanced proficiency in Infomatica Power Center and Profisee Maestro Enterprise Data Warehouse (EDW) tools.
Preferred Professional Competencies:
Advanced systems research and analysis expertise
Impeccable project management skills
Solid technical ability and problem-solving skills
knowledge of internal departments and operations