Senior Program Analyst

Summary

Senior Program AnalystDPP 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/weekPosition SummaryTo 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 ScopeThis 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.ResponsibilitiesAnalyzes 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 QualificationsH.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 SkillsAdvanced SQLSnowflake tables, views, tasks, streamsData modeling (facts and dimensions)Performance tuningSecurity and access managementELT developmentQlik SkillsQlik Sense developmentData load scriptsData modeling in QlikDashboard and visualization designSet analysisPerformance tuningPublishing and security rulesInterface / Semantic Layer SkillsUnderstanding how Snowflake data is exposed to reporting toolsBuilding curated reporting viewsCreating certified datasetsDesigning reusable metrics and KPIsUnderstanding business reporting requirementsPreferred QualificationsExperience 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). DP Professionals (DPP) offers a range of compensation and benefits packages to our employees and their eligible dependents. DPP is a certified Woman-owned Small Business Enterprise (WBE and WOSB) with more than 25 years in the staffing industry. EOE/AA/V/D

Job Description

Senior Program AnalystDPP 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/weekPosition SummaryTo 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 ScopeThis 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.ResponsibilitiesAnalyzes 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 QualificationsH.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 SkillsAdvanced SQLSnowflake tables, views, tasks, streamsData modeling (facts and dimensions)Performance tuningSecurity and access managementELT developmentQlik SkillsQlik Sense developmentData load scriptsData modeling in QlikDashboard and visualization designSet analysisPerformance tuningPublishing and security rulesInterface / Semantic Layer SkillsUnderstanding how Snowflake data is exposed to reporting toolsBuilding curated reporting viewsCreating certified datasetsDesigning reusable metrics and KPIsUnderstanding business reporting requirementsPreferred QualificationsExperience 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). DP Professionals (DPP) offers a range of compensation and benefits packages to our employees and their eligible dependents. DPP is a certified Woman-owned Small Business Enterprise (WBE and WOSB) with more than 25 years in the staffing industry. EOE/AA/V/D