Senior Program Analyst

DPP is seeking a Senior Program Analyst for an opportunity with our client in Bellaire, TX.
 
Work Location: Hybrid in Bellaire, TX; onsite 2-3 days/week
 
Position Summary:

• To organize and administer the configuration and development of information systems, and to devise and design technical requirements of systems, and is charged with the documentation and development of well-defined methods, procedures, programs and configurations in the delivery of systems.

Project Scope:

• This is for a Snowflake migration-looking for someone who can build Snowflake data marts and then develop/maintain the Qlik interfaces that consume that data.

Responsibilities:

• Analyzes and determines computerized solutions concerning compliance with regulatory agencies and the strategic plan.
• Appraises effectiveness of systems flow, data usage, and manual or automated processes to identify ineffectiveness or inefficiency of the system.
• Develops, designs, and modifies technical specifications for the Health Plan.
• Coordinates the design and analysis of the implementation of new systems and the modifications of existing systems.
• Controls system configuration and development process by establishing standards, measuring work in process, interpreting results, and taking corrective action.
• Develops and administers the system configuration and development plan.
• Delegates tasks and responsibilities to team members according to ability, priority, etc.
• Performs independent programming for segments of complex problems according to the technical specifications and standard system implementation techniques.
• Analyzes system performance and optimizes programs accordingly.
• Provides configuration, tuning, and upgrades to systems as needed.
• Initiates and implements new programming techniques, methods, procedures, approaches, and standards.
• Develop and administers data verification methods and plans as needed.
• Assures coded logic performs as required by testing and correcting programs via trial runs and combines individual programs into a job stream.
• Performs system integration testing to ensure system integrity.
• Develop documentation standards.
• Prepares program code documentation in compliance with standards.
• Prepares system configuration procedures in compliance with standards.
• Prepares documentation concerning program and configuration issues, bugs, and resolutions in compliance with standards.
• Controls system operations by finding and correcting errors in the system.
• Implements modifications to the system to accommodate new or changing requirements.
• Provides emergency support for malfunctioning systems.
• Coordinates development and maintenance programming activities with management, other Information Services personnel, users, or vendors during all phases of the system life cycle.
• Participates in meetings concerning user consulting, systems analysis, system design, and vendor contracts.
• Serves as Information Services department representative in meetings with other Integrated Delivery System components in developing data processing solutions designed to solve practical IDS problems.
• Participates in the development of a minimum data set for all information systems.
• Participates in the development of a defined and structured data dictionary for usage with all implementation efforts and to provide a uniform understanding enterprise-wide of the data between interacting systems.
• Provides expert consultation for strategic planning in the arena of data flow and analysis across various systems.

Required Qualifications:

• H.S. Diploma or GED in computer science or related field.
• 8 years of experience in major system design and implementation (bachelor’s degree will substitute for 4 years of experience).
• Knowledge at expert level of current application and system development techniques.
• Requires knowledge of relational databases, appropriate programming languages, data structures, associated computer hardware, computer networking, a variety of operating systems and client/server data processing techniques.
• Ability to demonstrate logic, analytical and verbal and written communication skills, team-oriented work habits, good interpersonal skills and the ability to adapt to different levels of technical experience.
• Specific skills required are as follows:
  • SQL Server 2005/2008 (T-SQL, functions, views, database design & configuration.
  • SQL Integration Services, SQL Server Analysis Services and SQL Server Reporting Services.
  • Visual Studio 2005/2010. C# strongly preferred with an emphasis on Object-oriented programming.
  • Preferably experience with ASP.NET or Silverlight.
  • Basic understanding of XML.
  • Core Snowflake Skills
  • Advanced SQL
  • Snowflake tables, views, tasks, streams
  • Data modeling (facts and dimensions)
  • Performance tuning
  • Security and access management
  • ELT development
  • Qlik Skills
  • Qlik Sense development
  • Data load scripts
  • Data modeling in Qlik
  • Dashboard and visualization design
  • Set analysis
  • Performance tuning
  • Publishing and security rules
  • Interface / Semantic Layer Skills
  • Understanding how Snowflake data is exposed to reporting tools
  • Building curated reporting views
  • Creating certified datasets
  • Designing reusable metrics and KPIs
  • Understanding business reporting requirements

Preferred Qualifications:

• Experience in Project Management or Project Leadership.
• Some manager care systems experience.

Authorized US Worker - US Citizens and those authorized to work in the US are encouraged to apply. We are unable to sponsor at this time.
 
Interested? Learn more:
Click the apply button to learn more about this position (#26-01329).