Choctaw Nation of Oklahoma
Data Engineer 2 Description Job Purpose or Objective(s): Establishes data management systems, standards, guidelines and quality assurance for database deliverables, such as conceptual design, logical database, capacity planning, external data interface specification, data loading plan, data maintenance plan and security policy. Participates in development of interfaces and design of user interface and business application prototypes. Primary Tasks Works on problems of moderate scope where analysis of situations or data requires a review of a variety of factors. Exercises judgment within defined procedures and practices to determine appropriate action and escalates to manager as needed Builds productive internal/external working relationships. Participates, and in some cases takes the lead on, formulating and monitoring data architecture policies, procedures and standards. Builds moderate level complexity data interfaces, both internal and external sources Participates in design of data architecture standards. Designs and implements database logical and physical models Provide development and production support to troubleshoot all data interfaces and data model related issues Performs other duties as may be assigned. Required Education, Skills And Experience MINIMUM Bachelors degree in computer science, computer information systems, electronic engineering or related field, and 3-4 years of equivalent experience Professional Database or ETL framework focused Certifications Preferred (MS SQL Server, Oracle, SSIS, SAP DS, Informatica, etc) 3-4 years exposure to database conceptual design, logical data modeling and capacity planning. Moderate level of hands-on experience developing internal and external data interfaces and data loading plans. Some experience with defining and managing data security policies 3-4 years of converting business requirements into data, database specifications and loading plans. Moderate level of hands on experience hands-on with data modeling tools (SSIS, Erwin, etc) Some experience working with development teams on data used in user based interfaces and backend data requirements. TARGET Bachelor’s degree in a computer information systems degree Professional ETL or data modeling focused Certifications 4 years experience with data modeling tools Working knowledge of Data Governance concepts 3-4 years exposure to database conceptual design, logical data modeling and capacity planning. Experience with managing multiple Service Requests and competing priorities4-7 years of data migration experience Moderate level of hands on experience hands-on with data modeling tools (SSIS, Erwin, etc) Some experience working with development teams on data used in user based interfaces and backend data requirements. 4 years experience with data modeling tools 5-7 years of converting business requirements into data, database specifications and loading plans Job Information Technology Primary Location OK-Durant Work Locations Durant HQ 1802 Chukka Hina Durant 74701 Organization Information Technology Schedule Regular Full-time Day Job Req ID: 20003508