DP
Senior Program Analyst
DP Professionals
- 🇺🇸 United States
- Hybrid
- Senior
- 8 hours ago
- Snowflake
- Qlik
- Integration Testing
- System Design
- T-SQL
- SQL
- Visual Studio
- C#
- Object Oriented Programming
- XML
- Data Modeling
- ELT
8 hours ago
Â
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.
- 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.
- 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.
- 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 withASP.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
- Experience in Project Management or Project Leadership.
- Some manager care systems experience.
Â
Interested? Learn more:
Click theapplybutton 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
Senior Program Analyst · DP Professionals