Link Technologies
Data Services Systems Integration Specialist
Link Technologies, Las Vegas, Nevada, us, 89105
JOB-7107Data Services Systems Integration SpecialistLas Vegas, NVContractLink Technologies (LinkTechConsulting.com), a Las Vegas-based IT consulting firm, is currently seeking a Data Services Systems Integration Specialist to join our team.
REQUIREMENTS
High school diploma or equivalent, e.g., General Educational Development (GED), foreign equivalency, etc.Bachelor of Science degree from an accredited institution in mathematics, computer science, management/business information systems, or a related field; and minimum of four (4) years of progressively responsible experience in enterprise database and SQL environments, including the creation and maintenance of views, stored procedures, reports, and data extracts for integrating data across various data sources and targets.
Alternatively, an Associate degree (or two (2) years of college coursework) from an accredited institution in a related field, and six (6) years of relevant experience; or, eight (8) years of experience as outlined above.
Minimum of two (2) years of recent experience working with common data development, analysis, integration, and reporting tools such as SQL Developer, Visual Studio/Code, SQL Server Integration Services (SSIS), BusinessObjects, or Tableau for integrating data between applications or data sources.Proficient in writing complex SQL queries, views, and procedures across Relational Online Analytical Processing (ROLAP) and various data sources, including the use of aggregate functions, GROUP BY/HAVING clauses, pivot/un-pivot structures, and sub-queries to create, manipulate, transform, store, integrate, and report data.Strong understanding of project management principles and practices.Familiarity with techniques and best practices for utilizing common database, spreadsheet, reporting, visualization, and word processing tools to streamline cross-functional business processes.Knowledgeable in service-oriented architecture and the principles, practices, and methods used in developing parameter-driven, self-service reporting interfaces and dashboards.Skilled in developing stored procedures using SQL, with proficiency in Procedural Language (PL)/SQL or Transact-SQL (T-SQL).Experienced in using modern SQL development tools and environments, including data connectors such as Open Database Connectivity (ODBC), Java Database Connectivity (JDBC), ActiveX Data Objects (ADO.NET), and Open Data Protocol (OData).Proficient in programming languages and technologies such as JavaScript, JSON, HTML, XML, web services, and APIs, with the ability to apply these technologies as needed.Capable of developing detailed programming specifications and writing complex software solutions.Strong ability to prepare clear, concise reports and documentation, maintain accurate records of work, and assist in the creation of training materials and programs.Ability to apply independent judgment while adhering to established procedural guidelines.Competent in supervising, training, and evaluating assigned staff members.Committed to staying current with evolving technology and applications.Skilled in coordinating multiple projects simultaneously while meeting established deadlines.Flexible in working hours and shifts to accommodate the demands of the role.Capable of developing and maintaining effective working relationships with district staff, vendors, and other agencies.Ability to identify and report hazards, applying safe work practices as required.Possesses the physical and mental stamina required to perform the responsibilities of the position effectively.PREFERRED QUALIFICATIONS
Industry certification(s) in the data standards, frameworks, or toolsets mentioned above.Ability to develop flow diagrams using Microsoft Visio.Experience with Microsoft Power BIRESPONSIBILITIES
Plans, schedules, reviews and maintains programs/processes to ensure data integrations interact appropriately.Identifies functional data stores needed to fulfill data integration needs; coordinates with technical teams to determine the extract, transform, and load (ETL) procedures necessary for integration/interoperability needs using appropriate toolsets.Designs, optimizes, and maintains data stores, including data structure, normalization, and indexing, in coordination with Application System Database, Business Intelligence, and other technical teams.Designs, optimizes, and maintains Structured Query Language (SQL) functions, queries, and views to access and integrate data; creates and executes test plans/scripts, documents results, and retests, as necessary.Implements process/report designs for schools, departments, administrators, Nevada Department of Education (NDE), and the public based on specifications to digitize/integrate business processes.Creates and maintains system documentation, including process design specifications, data dictionaries, self-documenting code, and user procedures according to standards.Maintains data integrity and integration, including associated business rules, to ensure consistency across systems; maintains compliance with Clark County School District data management/governance policies and procedures.Defines and creates trouble tickets with software vendors to address system-related problems, as required.Manages assigned Problem Management tickets for support areas; documents resolutions/workarounds in a Knowledge Base and communicates with Service Desk personnel.Performs root-cause analyses to identify and resolve complex data-/integration-related issues; may result in software modifications or vendor support tickets.Tracks project statuses and reviews works-in-progress to ensure conformance with plans and programming standards.Provides input into the evaluation of assigned staff.Conforms to safety standards, as prescribed.Performs other tasks related to the position, as assigned.
Link Technologies is an equal opportunity employer. All qualified applicants will receive consideration for employment without discrimination based on race, color, religion, sex, gender identity/expression, sexual orientation, national origin, protected veteran status, disability, or any other factors protected by law.Click to Apply
REQUIREMENTS
High school diploma or equivalent, e.g., General Educational Development (GED), foreign equivalency, etc.Bachelor of Science degree from an accredited institution in mathematics, computer science, management/business information systems, or a related field; and minimum of four (4) years of progressively responsible experience in enterprise database and SQL environments, including the creation and maintenance of views, stored procedures, reports, and data extracts for integrating data across various data sources and targets.
Alternatively, an Associate degree (or two (2) years of college coursework) from an accredited institution in a related field, and six (6) years of relevant experience; or, eight (8) years of experience as outlined above.
Minimum of two (2) years of recent experience working with common data development, analysis, integration, and reporting tools such as SQL Developer, Visual Studio/Code, SQL Server Integration Services (SSIS), BusinessObjects, or Tableau for integrating data between applications or data sources.Proficient in writing complex SQL queries, views, and procedures across Relational Online Analytical Processing (ROLAP) and various data sources, including the use of aggregate functions, GROUP BY/HAVING clauses, pivot/un-pivot structures, and sub-queries to create, manipulate, transform, store, integrate, and report data.Strong understanding of project management principles and practices.Familiarity with techniques and best practices for utilizing common database, spreadsheet, reporting, visualization, and word processing tools to streamline cross-functional business processes.Knowledgeable in service-oriented architecture and the principles, practices, and methods used in developing parameter-driven, self-service reporting interfaces and dashboards.Skilled in developing stored procedures using SQL, with proficiency in Procedural Language (PL)/SQL or Transact-SQL (T-SQL).Experienced in using modern SQL development tools and environments, including data connectors such as Open Database Connectivity (ODBC), Java Database Connectivity (JDBC), ActiveX Data Objects (ADO.NET), and Open Data Protocol (OData).Proficient in programming languages and technologies such as JavaScript, JSON, HTML, XML, web services, and APIs, with the ability to apply these technologies as needed.Capable of developing detailed programming specifications and writing complex software solutions.Strong ability to prepare clear, concise reports and documentation, maintain accurate records of work, and assist in the creation of training materials and programs.Ability to apply independent judgment while adhering to established procedural guidelines.Competent in supervising, training, and evaluating assigned staff members.Committed to staying current with evolving technology and applications.Skilled in coordinating multiple projects simultaneously while meeting established deadlines.Flexible in working hours and shifts to accommodate the demands of the role.Capable of developing and maintaining effective working relationships with district staff, vendors, and other agencies.Ability to identify and report hazards, applying safe work practices as required.Possesses the physical and mental stamina required to perform the responsibilities of the position effectively.PREFERRED QUALIFICATIONS
Industry certification(s) in the data standards, frameworks, or toolsets mentioned above.Ability to develop flow diagrams using Microsoft Visio.Experience with Microsoft Power BIRESPONSIBILITIES
Plans, schedules, reviews and maintains programs/processes to ensure data integrations interact appropriately.Identifies functional data stores needed to fulfill data integration needs; coordinates with technical teams to determine the extract, transform, and load (ETL) procedures necessary for integration/interoperability needs using appropriate toolsets.Designs, optimizes, and maintains data stores, including data structure, normalization, and indexing, in coordination with Application System Database, Business Intelligence, and other technical teams.Designs, optimizes, and maintains Structured Query Language (SQL) functions, queries, and views to access and integrate data; creates and executes test plans/scripts, documents results, and retests, as necessary.Implements process/report designs for schools, departments, administrators, Nevada Department of Education (NDE), and the public based on specifications to digitize/integrate business processes.Creates and maintains system documentation, including process design specifications, data dictionaries, self-documenting code, and user procedures according to standards.Maintains data integrity and integration, including associated business rules, to ensure consistency across systems; maintains compliance with Clark County School District data management/governance policies and procedures.Defines and creates trouble tickets with software vendors to address system-related problems, as required.Manages assigned Problem Management tickets for support areas; documents resolutions/workarounds in a Knowledge Base and communicates with Service Desk personnel.Performs root-cause analyses to identify and resolve complex data-/integration-related issues; may result in software modifications or vendor support tickets.Tracks project statuses and reviews works-in-progress to ensure conformance with plans and programming standards.Provides input into the evaluation of assigned staff.Conforms to safety standards, as prescribed.Performs other tasks related to the position, as assigned.
Link Technologies is an equal opportunity employer. All qualified applicants will receive consideration for employment without discrimination based on race, color, religion, sex, gender identity/expression, sexual orientation, national origin, protected veteran status, disability, or any other factors protected by law.Click to Apply