Database Administrator - ETL Specialist
8 months ago
Employment Information
Database Administrator - ETL Specialist - WidePoint Integrated Solutions Corp. - Columbus, OH
WidePoint Corporation (WYY) is a leading provider of wireless mobility management and cybersecurity solutions. We offer secure, cloud-based, enterprise-wide information technology-based solutions that enable enterprises and government agencies to deploy fully compliant IT services in accordance with government-mandated regulations and advanced system requirements.
We are looking for a highly motivated Database Administrator - ETL Specialist located in Columbus, OH that can operate in a fast-paced and demanding start-up like environment of a micro-cap publicly-traded company.
Position Summary
The Database Administrator (DBA) - Extract, Transform, and Load (ETL) Specialist plays a crucial role in designing, developing, and optimizing ETL workflows, ensuring seamless data flow within the organization. In addition, the DBA - ETL Specialist is responsible for assisting with designing, implementing, maintaining, and repairing the database. At times, they plan, develop, and troubleshoot the database.
WidePoint Corporation (WYY) is a leading provider of wireless mobility management and cybersecurity solutions. We offer secure, cloud-based, enterprise-wide information technology-based solutions that enable enterprises and government agencies to deploy fully compliant IT services in accordance with government-mandated regulations and advanced system requirements.
We are looking for a highly motivated Database Administrator - ETL Specialist located in Columbus, OH that can operate in a fast-paced and demanding start-up like environment of a micro-cap publicly-traded company.
Position Summary
The Database Administrator (DBA) - Extract, Transform, and Load (ETL) Specialist plays a crucial role in designing, developing, and optimizing ETL workflows, ensuring seamless data flow within the organization. In addition, the DBA - ETL Specialist is responsible for assisting with designing, implementing, maintaining, and repairing the database. At times, they plan, develop, and troubleshoot the database.
Essential Duties and Responsibilities
The essential functions include, but are not limited to the following:
The essential functions include, but are not limited to the following:
- Design, develop, and maintain robust ETL processes to support data integration needs.
- Extract and transform data from diverse sources into formats suitable for analysis and reporting.
- Collaborate with cross-functional teams to understand business requirements and translate them into effective ETL solutions.
- Monitor and optimize the performance of ETL processes to ensure efficiency and scalability.
- Troubleshoot and resolve issues related to data integration and ETL workflows.
- Work closely with data architects and other database team members to design data models that support ETL processes.
- Create and maintain documentation for ETL processes, data mappings, and transformations.
- Maintaining WidePoint's databases but can also specialize in developing databases.
- Establish the necessity of the user access and monitor their security and access.
- Monitoring the performance and managing the parameters to give fast responses to users.
- Mapping out the conceptual design for a database.
- Processing the logical design in a way that can be converted to a specific data model.
- Refining the physical design to meet the requirements of system storage.
- Installing and testing the new version of the database management system.
- Writing documentation for a database, including data standards, procedures, and metadata.
- Performs other related duties as assigned.
Minimum Qualifications (Knowledge, Skills, and Abilities)
The minimum qualifications include:
The minimum qualifications include:
- Bachelor's degree in computer science and other related fields.
- Proven experience as a Database Administrator with a strong emphasis on ETL processes.
- Proficiency in SQL and scripting languages; experience with ETL tools such as SSIS, Informatica, or AWS Glue.
- Solid understanding of data warehousing concepts, dimensional modeling, and data quality principles.
- At least two (2) years of related experience are required.
- Excellent verbal and written communication skills.
- Excellent organizational skills and attention to detail.
- Excellent time management skills with a proven ability to meet deadlines.
- Strong analytical and problem-solving skills.
- Ability to function well in a high-paced and, at times, stressful environment.
Physical Demands and Work Environment
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the functions.
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the functions.
- Prolonged periods of sitting at a desk and working on a computer.
- Must be able to lift up to fifteen (15) pounds at times.
Note: This position description in no way states or implies that these are the only duties to be performed by the employee(s) incumbent in this position. Employees will be required to follow any other position-related instructions and to perform any other position-related duties requested by any person authorized to give instructions or assignments. All duties and responsibilities are essential functions and requirements and are subject to possible modification to reasonably accommodate individuals with disabilities. To perform this position successfully, the incumbents will possess the skills, aptitudes, and abilities to perform each duty proficiently. Some requirements may exclude individuals who pose a direct threat or significant risk to the health or safety of themselves or others. The requirements listed in this document are the minimum levels of knowledge, skills, or abilities. This document does not create an employment contract, implied or otherwise, other than an "at will" relationship.
The company is an Equal Opportunity Employer, drug free workplace, and complies with ADA regulations as applicable.
Share this
