Title | Data Engineer |
Posting Date: | 11/06/2020 |
Location: | Texas |
Job Type | Full Time |
EQUINOX IT SOLUTIONS is looking for a Data Engineer to join our growing team to complement the current multitude and wide variety of team skills to support organization needs for data driven analytics. we work in an environment where collaboration, teamwork, respect, and openness are highly valued.
Essential Duties & Responsibilities:
Data modeling and dimensional schema design
Design and develop data ingestion, pipeline, processing, and transformation frameworks to automate high-volume, and real-time data delivery
Build the data infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources
Create, enhance, and optimize data visualizations
Identify, design, and implement internal process improvements to automate manual processes, and optimize data delivery
Build processes to support data transformation, data structures, metadata, dependency and workload management.
Define and maintain target data architectures and master data management strategies
Collaborate with various Business, Operations, Applications and Analytics teams to ensure adherence to enterprise data standards and data architecture principles
Monitor compliance of development work against established standards and principles and work to resolve discrepancies and issues
Optimizing high-performing SQL for efficient data transformation
Production release and operation of data services
Requirements:
Bachelor’s degree in Computer Science, Engineering, or related field
4+ years of experience building data pipelines and using ETL tools
2+ years of experience leading data Engineering efforts
2+ years of experience creating data visualizations
Knowledge of data management, data integration and database development technologies and processes
Up-to-date specialized knowledge of data wrangling, manipulation and management
Demonstrated mastery in one or more SQL variants: T-SQL or PL/SQL
In-depth knowledge of Microsoft SQL Server or Oracle
Demonstrated mastery in database concepts and large-scale database implementations and design
Excellent analytic and troubleshooting skills
Proficiency with data profiling and data migration
Knowledge of real-time data acquisition and/or automation/controls
Working knowledge of application development and data modeling to support implementation and development of analytics
Demonstrated success in technical proficiency, creativity, collaboration, and independent thought
Experience in migrating ETL processes (not just data) from relational databases to cloud based solutions
Strong interpersonal skills to resolve issues in a professional manner, lead working groups, negotiate and create consensus
Experience architecting and implementing data solutions, and working with unstructured datasets in a cloud environment, a plus
Java / R/ Python, Data science/machine learning, a plus