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