Etl Developer

FloWorks is a leading specialty industrial supplier of pipe, valves, fittings and related products and a provider of technical solutions to the energy and industrial sectors. Privately held company located in Pasadena, Texas.
Summary of Responsibilities
As an ETL Developer/Database Administrator you will be in charge of designing, creating, and implementing data pipelines as well as maintaining data warehouse. Job will also include data management support activities, for monitoring space usage, starting up and shutting down databases, diagnosing errors, administering distributed databases, and developing automated backup procedures.
Data modeling, process documentation, and ad hoc reporting, as necessary. Lastly, daily database administrator duties will include, monitoring, optimizing, scheduling & general management of our SQL Database environment.
Provide testing, quality control, and performance tune services that will ensure integrity and reliability. Confer with business unit and technical staff regarding extracting data for particular reports.
Major Tasks, Responsibilities and Key Accountabilities

• Maintain structure, tables, access to and efficient operation of one or more large or databases in use for systems or applications in current use by clients, business units, or corporate offices.
• Confer with application staff or project management staff regarding project planning, resource allocation, task definitions and schedules for substantial projects involving database(s).
• Manage the environment in which a database functions by testing or restoring data, code builds, capacity planning, and assessing systems interfaces.
• Develop and document database models, data dictionaries, data flow diagrams for use by developers or database users.
• Confer on troubleshooting problems of database(s) in production. Assess root causes for bug or production problem or provide technical input to developers or less senior DBAs.
• Use specific software utilities and tools to tune, troubleshoot, or refine database(s) and make their operation more efficient.
• Become familiar with these tools and instruct others in their use.
• Use ETL tools like SSIS to perform basic data loading and testing.

Team/Department Responsibilities

• Develops solutions and resolves a wide range of data and technical issues, as necessary. Work may be performed without direction. Typically participates in determining objectives of and approaches to assignments.

Preferred QualificationsEducation and Experience Requirements

• Bachelor's degree or Equivalent Area of Study Computer Science or Engineering
• Experience: 4-6 years of related experience Specialized Knowledge & Skills Knowledge of relevant DB platform software.

This information indicates the general nature and level of work performed by associates in this role. It is not designed to contain a comprehensive inventory of all duties, responsibilities, and qualifications required of associates assigned to this role. This description supersedes any previous or undated descriptions for this role. Management retains the right to add or change the duties of the position at any time. Questions about the duties and responsibilities of this position should be directed to the reporting Manager or Human Resources.
FloWorks is an equal opportunity employer and gives consideration for employment to qualified applicants without regard to race, color, religion, gender, gender identity, sexual orientation, national origin, genetics, disability, age, or protected veteran status.
FloWorks participates in the US Government's E-Verify program.