Enterprise Data Engineer
Colorado Springs, CO, United States
Job Summary:
The Data Engineer will be responsible for developing, optimizing, testing, and creating extracts, integrations, and migrations of data to new and existing databases to help users retrieve data effectively. This role involves working with technologies in the data field to support advanced analytics and data processing capabilities. The ideal candidate will have a strong background in software development, database management, and a solid understanding of data mapping and transformation, extraction, and loading.
Essential Duties and Responsibilities:
Development:
The Developer candidate must have the following experience:
Proficient with Structured Query Language (SQL).
Proficient in creating, modifying, and querying relational databases.
Proficient in the creation of SQL queries to retrieve specific data from Needles by specifying various search criteria.
At least 5 years of experience with interpreting database tables and data to understand correct extraction and mapping.
Experience formatting, running totals, summaries, custom formulas, and custom Functions (SQL Queries).
Experience with PLSQL Developer, SQL Plus, SQL Navigator, and AWS Glue.
Strong ability to research and manage complex data requests.
Sound oral and written communication skills.
Migration experience a plus.
High evaluative and interpretative skills.
Qualifications:
Bachelor's or Master's degree in Computer Science, Information Technology, or a related field.
Proven work experience as a Data Engineer , Database Developer, or similar role.
Experience with database-backed web applications.
Proficiency in SQL and experience with database management systems (e.g., MySQL, PostgreSQL, MongoDB).
Familiarity with data manipulation languages and the principles of database design.
Knowledge of software development and user interface web applications.
Excellent organizational and analytical abilities.
Outstanding problem solver.
Preferences:
Background with both structured and unstructured data.
Experience with both SQL and NoSQL databases.
Familiarity with columnar databases.
Experience with Salesforce, AWS Redshift, and Snowflake.