Posted on: March 14, 2019
Primary Purpose of Position Design, develop or implement integration processes from various sources into Structure Query Languages (SQL) databases and analytical procedures necessary to satisfy the needs of the agency as outlined by policies and procedures and to meet the requirements of North Carolina State and Federal law. Certifies accuracy and completeness of applications by preparing data and testing features, functionality, and results. Prepares documentation of all procedures, changes or maintenance in integration processes. Responsibilities Role and Responsibilities 70 Integration Analysis and Development. Develop, modify and managed integration packages which process data into existing databases and database management systems to meet the evolving requirements of the LMEMCO. Work as part of a project team to coordinate automated and manual data integration and exchange processes. Coordinate activities with data source owners to ensure integration, data integrity and data quality. Assist IT staff with the development of automated processes as required in completion of the current and long-range goals set forth by the Applications Support Manager. Works with Project Teams and business resources to gather business requirements and drive functional and technical designs for IT systems solutions Care Management platform and Business Intelligence - (Data Warehouse, ETL, Metadata, OperationalTacticalStrategic Reporting, and Dashboards) Assist with the design and development of data schemas and definitions to support Business Intelligence and Data Warehousing architecture requirements. Develop data models describing data elements and how they are used and accessed by other applications and reporting subsystems. Develop and maintain relational data mappings for use by other agency analysts and report writers. Review project requests, develop specifications and estimate effort required to accomplish project. Review procedures in database management system manuals for making changes to database. Identify and evaluate industry trends in database systems to serve as a source of information and advice for the Applications Support Manager. Write and code logical and physical database descriptions and specify identifiers of database to management system or direct others in coding descriptions. Review workflow charts developed by system analyst to understand tasks computer will perform, such as updating records. Revise agency definition of data as defined in data dictionary 30 Data Analysis and reporting. Developing reports as requested by LMEMCO staff in accordance with agency standards. Creates complex reports and Data Cubes using various software tools such as structured query language (SQL), Microsoft (SSRS), (SSAS), SSIS, and Microsoft Excel. Independently audit and verify system information from both systems generated and user produced reports for consistency and accuracy. Review reports to determine basic characteristics, such as origin and report flow, format, frequency, distribution and purpose or function of report. Confer with persons originating, handling, processing, or receiving reports to identify problems and to gather suggestions for improvements. Evaluate findings, using knowledge of workflow, operating practices, records retention schedules, and office equipment layout. Researches complex data issues examine data in various source systems for inconsistencies, review transformation logic and propose corrective alternatives. Deliver projects on time and within budget with a high degree of quality Work with multiple cross-functional project teams to accomplish development activities that will include (but not be limited to) logical and physical data modeling leveraging BI design principles, semantic layer modeling and design, universe design and development, report design, development, testing and deployment, dashboard design, development, testing and deployment Create complex technical reports and reporting infrastructure including data definitions and views. Conduct comprehensive analysis to produce complex documents that clearly define quality assurance, testing criteria, prototypes and mock-ups measure results in sufficient detail utilize version control for requirements. Compile and integrate data from outside sources analyzes errors in digital file exchange and makes corrections Review requests for special database applications, data, maps and data layer estimates time of completion and creates solutions to meet needs Obtains, analyzes, queries and manipulates data Performs other job-related tasks as required. Knowledge, Skills and Abilities Considerable knowledge of computers and related information technology devices Considerable knowledge of the software packages utilized by the agency Considerable knowledge of programming techniques, the appropriate programming language(s), operating systems, and the capabilities and limitations of computer and peripheral equipment Demonstrated technical aptitude through strong analytical skills, problem identification and resolution, organizational skills, creativity, and critical thinking Excellent customer service and written and oral communication skills required in working with users and team members Ability to communicate effectively with users who may not be coherent in clarifying problem situations Ability to understand operations and organize component parts into a logical system Ability to work under time constraints and other demands Ability to display a positive attitude and show initiative to meet departmental goals and customer expectations Ability to communicate well with staff at various levels throughout the agency to understand their needs and communicate how they can leverage technology to successfully complete their assigned tasks Demonstrated strong work ethic by contributing high quality work to a number of projects, a willingness to be available as required outside standard hours, personal motivation, and the ability to meet or exceed deadlines Qualifications EducationExperience Required Bachelor's Degree in Information Technology or Computer Science and five (5) years of progressively responsible development and implementation of automation of internal and external data integration and exchange using Structure Query Languages (SQL), SSRS, SSAS, SSIS or an equivalent combination of training and experience. Must have ability to travel.
Keywords: Corus360, Gastonia , Integration Developer, IT / Software / Systems , Gastonia, North Carolina
Didn't find what you're looking for? Search again!