Job summary:
This role is expected to have excellent technical abilities, adaptability to new technology, decision making, leadership, and strong communication skills.
This position exists to evolve architecture, data design standards, best practices, developments, optimizations, tests, and deployments for the Trails database.
Primary (70%) job responsibility:
- Prototype and develop re-usable data solutions and patterns to enable faster access to data assets for the support of Trails application and all related interfaces
- Design logical and physical data models, create metadata definitions, and source-to-target mapping
- Analyze & profile business data on relational and Big Data Environment
- Identify technology risks early and establish mitigation plans
- Leverage, practice and support Agile software development practices
- Work in a cross-functional environment and ability to work with minimal supervision
- Point of contact for requirements coordination and data solution delivery
- Work with the business teams, SMEs, and developers to facilitate speedy response and delivery
- Responsible for mentoring and training junior data developer in the team
- Work exp, 8+ years demonstrated real world experience in:
- Advance knowledge and experience in all aspects of data systems (traditional, a plus for Big Data) including database design, ETL, aggregation strategy, performance optimization
- Hands-on development experience with OracleStrong SQL experience with the ability to develop, tune and debug complex SQL applications is required
- Understanding of best practices for building and designing ETL code
- Expertise in schema design, developing data models and proven ability to work with complex data is required
- Data Governance / Data Management covering topics such as Data Quality, Data Stewardship, Data Security, Metadata, Data Retention
- Skills, advance knowledge and experience in all aspects of data systems:
- OracleSQL, PL/SQLDatabase design/modeling/development/analysis/reportingETLAggregation strategy
- Database performance optimization
Nice to have:
Experience in Human Services sector is preferredSQL ServerERwinMongoDB.NETGKEExperience with Human Services Experience developing applications on Big Data platform for both batch and real time ingestion
Education:- BS of STEM major (science, technology, engineering and mathematics) from an accredited school by U.S. Department of Education Background Verification Minimum Verification Requirements Please complete the following verifications with Info Cubic upon candidate's selection. Additional verifications may be identified by the agency. State Criminal Record verification (past 7 years covering each State in which the candidate has resided) County Criminal Records (past 7 Year Address History) Federal Criminal Records Verification (past 7 years)SSN Name SearchGlobal Monitor Check (formerly Patriot/OFAC/Terrorist)(Suppliers Only) To order, click on the link to the right: Order Standard Background Verification Type Qualification Description Competency Experience Required
