Please paste the following URL into a browser to view the entire job posting in the CAPPS Career Section: https://capps.taleo.net/careersection/ex/jobdetail.ftl?job=00056008
You may apply to the job directly through the CAPPS Career Section. It is not necessary to apply both through Work In Texas and CAPPS Career Section
PLEASE NOTE: All applications must contain complete job histories, which includes job title, dates of employment, name of employer, supervisor's name and phone number and a description of duties performed. If this information is not submitted, your application may be rejected because it is incomplete. Resumes do not take the place of this required information.SUBMITTED THROUGH WORK IN TEXAS: Work In Texas (WIT) applicants must complete the supplemental questions to be considered for the posting. In order to complete the supplemental questions please go to CAPPS Recruit to register or login and access your profile. Go to CAPPS Recruit to Sign In https://capps.taleo.net/careersection/ex/jobsearch.ftl?lang=enGENERAL DESCRIPTION: Perform highly complex computer programming technical work for the Enterprise Data Office Work involves building systems that collect, manage, and convert raw data into usable information for data scientists, data analysts and business analysts to interpret. This requires the ability to access data stored in a variety of database management systems (such as DB2, SQL Server, and Oracle) which satisfy customer business requirements. Work under limited supervision, with considerable latitude for the use of initiative and independent judgment.The following Military Occupational Specialty codes are generally applicable to this position.https://hr.sao.texas.gov/Compensation/MilitaryCrosswalk/MOSC_InformationTechnology.pdfApplicants must fully complete the summary of experience to determine if minimum qualifications are met.ESSENTIAL DUTIES / RESPONSIBILITIES:Communicate with internal and external customers to analyze and identify all relevant details of highly complex systems that involve interchange of large volumes of data (frequently stored in disparate or geographically dispersed databases).
Communicate with division or department subject matter experts, and with representatives of federal, state and various interacting agencies to analyze and identify all relevant details of highly complex systems that involve interchange of large volumes of data.
Design complex tables, schemas, data marts, or related data designs that provide for effective and efficient access for data found among disparate, geographically dispersed systems such that entry, retrieval and manipulation of data may be accomplished simply from a single location while preserving data security.Create, maintain, and manage data asset catalogs and complete inventory of organizational data.Provide colleagues the opportunity to examine, analyze and contribute to the refining of the designed input and output of refined data.
Present training sessions for colleagues as appropriate to accomplish scheduled development, testing, implementation, and utilization of the developed system(s).
Develop appropriate documentation and ensure established standards and best practices are applied at all stages of the development process.
Attend work regularly and observe approved work hours in accordance with agency leave and attendance policies.
Perform other duties as assigned
Qualifications: GENERAL QUALIFICATIONS and REQUIREMENTS:Education and#8211; High School Diploma/equivalent is required. Graduation from an accredited four-year college or university with a major in Computer Science, Statistics, Management Information Systems (MIS), Information Sciences Technology (IST), Information Technology, or a related field is preferredExperience and#8211;and#8226;Minimum of four (4) yearsand#8217; experience writing SQL and accessing data stored in databases such as SQL Server, DB2, and Oracle databases is required.and#8226;Familiarity withdatabase fundamentals such as snowflake schema, normalized/denormalized data is required. Minimum of two (2) years designing databases is required.Substitution Note: Additional work experience of the @type described, or other related education may be substituted for one another on a year-for-year basis.Licensure and/or Certification and#8211; Must possess a valid driver license from state of residence.Critical Organizational Infrastructure requirements and#8211; This job may be responsible for conducting research on, working on, or having the ability to access critical organizational infrastructure; must be able to maintain the security and integrity of the infrastructure related to this role. Additionally, and more specifically, must not be employed by nor have any connection or continuous connections to any governmental entity or political apparatus of a country listed in 15 C.F.R. and#167;791.4.Regulatory Knowledge and#8211; Working knowledge of, or the ability to rapidly assimilate information related to TXDPS, State and Federal regulations, legislation, guidelines, policies and procedures.Supervisory/Managerial/Leadership Skills and#8211; Able to develop plans, policies, and procedures for efficient workflow and overall effectiveness. Must exhibit integrity; promote teamwork and be able to motivate others to accomplish goals.Interpersonal Skills and#8211; Must demonstrate an ability to exercise poise, tact, diplomacy and an ability to establish and maintain positive, working/professional relationships with internal/external customers.Organizational and Prioritization Skills and#8211; Must be organized, flexible, and able to effectively prioritize in a multi-demand and constantly changing environment; able to meet multiple and sometimes conflicting deadlines without sacrificing accuracy, timeliness or professionalism.Presentation/Communication Skills and#8211; Must be able to construct and deliver clear, concise, and professional presentations to a variety of audiences and/or individuals.Research and Comprehension and#8211; Must demonstrate ability to quickly and efficiently access relevant information and be able to utilize and/or present research and conclusions in a clear and concise manner.Analytical Reasoning/Attention to Detail and#8211; Must demonstrate an ability to examine data/information, discern variations/similarities, and be able identify trends, relationships and causal factors, as well as grasp issues, draw accurate conclusions, and solve problems.Technology and#8211; Must possess appropriate levels of proficiency with utilized software and systems and be able to learn new software/systems. Demonstrated proficiency with Microsoft Office Suite (Word, Excel, PowerPoint, Outlook).and#8226;Experience creating conceptual, logical, and physical data models for databases, data warehouses, and big data platforms.and#8226;Considerable knowledge of the Software Development Life Cycle (SDLC).and#8226;Extensive knowledge of database concepts and relational database management systems such as DB2, Microsoft SQL Server, and Oracle.and#8226;Considerable skill in the use of SQL as a tool for retrieving, updating, inserting, deleting, manipulating, and managing data stored in enterprise databases.and#8226;Ability to work within an agile development cycle.and#8226;Experience with Snowflake or similar platform is preferred.and#8226;Experience working with ETL tools such as AWS DMS.and#8226;An understanding of AWS Cloud technologies preferred.and#8226;Skill in oral and written communication in technical and non-technical terminologyConfidentiality and Protected Information and#8211; Must demonstrate an ability to responsibly handle sensitive and confidential information and situations and adhere to applicable laws/statutes/policies related to access, maintenance and dissemination of information.Safety and#8211; Must be able to work in safe manner at all tim
