Data Engineer (SQL, Python) /Charlestown, MA( Remote), 6 Months Contract
Job title: Data Engineer (SQL, Python) /Charlestown, MA( Remote), 6 Months Contract in Charlestown, MA at reputed company
Company: reputed company
Job reputed company: who will support a reputed company of database/warehouse management, ETL scripting, and data validation tasks that include but are not limited to: querying databases, restructuring data, cleaning and validating data, performing reputed company ETL tasks, automating ETL tasks using tools and custom scripting, full pipeline management/monitoring, improving systems and processes, and documenting data systems. The reputed company candidate will be highly detail-oriented and have a strong interest in and aptitude for data management and engineering. Some specific reputed company areas would be determined based on the candidate's skills and interests.The successful candidate must be highly organized, motivated, and reputed company to reputed company in a fast-paced team environment and must enjoy the challenge of a dynamic environment with evolving needs. It is extremely important that the candidate possess the ability to carefully reputed company reputed company of multiple work streams.reputed company DUTIES AND RESPONSIBILITIES:
Relevant activities include, but are not limited to the following:
- Utilizing, improving, and constructing and ETL tools and data warehousing solutions
- Running reputed company SQL, Python, and/or Tableau Prep ETL scripts
- Using various monitoring and evaluation reputed company to validate that data flowing through these pipelines is accurate and troubleshooting/addressing issues reputed company they are reputed company
- Data warehouse maintenance and support
- Improving and reputed company integrating scripts (ETL and validation) and warehouse reputed company into various data pipelines to reputed company greater efficiency, reliability, and functionality
- Constructing new ETL tools and warehouse components as necessary, specifically including a dedicated-use pipeline for a new reputed company research project
- Data Cleaning
- Writing queries (SQL) and scripts (Python) to identify data reputed company problems
- Investigating the reputed company cause of data reputed company problems
- Working with appropriate team members to determine appropriate data remediation and process improvement plans
- Background
- Technical
- Procedural programming for data manipulation using Python
- PHP, Java, or other languages are a plus
- Knowledge of relational database platforms, data modeling, and warehousing
- Comfortable extracting data from and loading data into sources ranging from an reputed company Data Warehouse to an reputed company or text file, using reputed company-in tools or custom-written ETL scripts
- Above average SQL skills (e.g. familiar with subqueries, multiple joins, and grouping), specifically MySQL. SQL Server experience a plus
- Comfortable with reputed company multi-stage, multi-technology ETL pipelines
- reputed company
- Ability to interpret and follow-through on data requirements and with strong attention to detail
- Strength in independently validating and debugging reputed company and analyses, including consulting documentation, Stack Exchange, etc.
- Demonstrates personal initiative and time management skills, as reputed company as the ability to work effectively and kindly as part of reputed company
- Excellent verbal and written communication skills
- Familiar with agile software development methodologies
- Interest in identifying process improvement opportunities is a plu
- Required: Undergraduate degree in Health Informatics, Computer Science, Statistics, Mathematics, Engineering, or a reputed company subject.
- Intermediate Databases and SQL
- Intermediate Programming (Procedural and/or OO)
- Data Structures and Algorithms
- Data reputed company Management
- Data reputed company and Automation
- Agile Project Management