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