RedRiver Systems - Arlington, TX

posted about 2 months ago

Full-time
Arlington, TX
Administrative and Support Services

About the position

Join a leading company in the industry as a SQL Developer focused on data conversion, playing a crucial role in the organization's digital transformation towards cloud and mobile products. In this position, you will collaborate closely with application development teams, Business Analysts, and various business units to integrate data from diverse sources into existing systems. Your contributions will also support multiple internal applications, including Commercial Off-The-Shelf (COTS) solutions, Enterprise Resource Planning (ERP) systems, and custom-built applications. Your primary responsibilities will include understanding the data needs of the business and developing tools that streamline internal processes. You will create dashboards and other analytical tools to enhance data-driven decision-making. Additionally, you will troubleshoot issues and determine resolutions for correcting defects in the data systems. You will be expected to provide estimates regarding the level of effort required for project tasks and perform analyses to identify the best solutions. Working closely with users and Business Analysts, you will gather requirements and design tools that facilitate informed, data-centric decisions. As part of your role, you will design and develop interfaces for importing and exporting data between disparate systems and perform Extract, Transform, Load (ETL) processes on data from multiple sources. Your solid experience with Microsoft SQL data tools will be essential in executing these tasks effectively.

Responsibilities

  • Understand the data needs of the business.
  • Develop tools that streamline internal business processes.
  • Create dashboards and other tools to enhance data-oriented decision making.
  • Troubleshoot and determine resolution for correcting defects.
  • Complete estimates as to level of effort involved for project tasks and perform analysis to determine how the solution can best be achieved.
  • Work with users and Business Analysts to determine requirements and design tools for more informed data centric decisions.
  • Design and develop interfaces for the import and export of data to and from disparate systems.
  • Perform ETL on data from multiple sources.

Requirements

  • Solid experience with the MS SQL data tools including solid SQL development.
  • Working knowledge of SSRS (SQL Server Reporting Services).
  • Strong Excel experience.
  • Working knowledge of SSIS (SQL Server Integration Services).
  • Working knowledge of SSMS (SQL Server Management Studio).
  • Working knowledge of Microsoft Visual Studio.
  • Understanding of CDC (Change Data Capture) mirroring and SQL replication.
  • Basic knowledge of SSAS (SQL Server Analysis Services).
  • Ability to design and implement conversion strategies to bring data from disparate databases into company databases.
  • Basic knowledge of Power BI.
  • Ability to work with end users to identify and troubleshoot problems.

Benefits

  • Major Medical
  • Dental
  • Vision
  • Long-Term Disability (LTD)
  • 401k
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service