Job Description

Role: Data Modeler/Architect

Location: Houston, TX 77401 (2-3 days/week)

Duration: 6+ month with possible extension

Job Summary:

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

Requirements:

• 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

Job Responsibilities:

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

Required Education:

• H.S. Diploma or GED in computer science or related field.

Preferred Education:

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

Job Tags

Similar Jobs