Local to Houston only===Need Data Modeler/Architect: Hybrid

To organize and administer the configuration and development of Client 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, * Analyzes and determines computerized solutions for Client concerning compliance with regulatory agencies and the client 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 Client.
• 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.
• Develops 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.
• Develops 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 of 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.

• 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, * H.S. Diploma or GED in computer science or related field.

Preferred Education:

• Bachelor’s degree will substitute for four (4) years of experience