Primary Responsibilities

• Architect, build, and maintain the solution of data integration or ETL pipeline
• Design and develop data models, data transformation processes, and metadata that converts raw data to formats suitable for consumption in BI platforms, including reporting, data mining, machine learning, forecasting, advanced analytics, etc.
• Design, implement and support data provisioning to meet the analytics needs of various business units while following and enhancing BI standards and best practices across the organization
• Continuously improve data reliability, efficiency, and quality.
• Work with stakeholders including Program Manager, Executive, Finance, Operation, and Quality Control teams to support their data infrastructure needs.
• Develop analytical tools and programs
• Build and maintain reusable data tools for data integration and ETL
• Custom script development, data migration, or manipulation to support the BI team
• Propose and maintain data solution strategies and roadmaps

Requirements

• 3+ years of experience developing data integration or ETL using MySQL databases
• Advanced working knowledge of relational databases, query authoring (SQL), and SQL optimization
• Strong solution design experience including data modeling, data presentation, data visualization, the definition of key performance indicators, and ETL processing
• Good knowledge of relational databases and SQL language
• Experience integrating data from different sources (API, Databases, files, etc.)
• Experience performing root cause analysis on data and processes to answer specific business questions and identify opportunities for improvement.
• Physical and logical design of database architecture for relational databases, data warehouses, and data lakes Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
• Strong analytic skills related to working with structured or unstructured datasets.
• Experience supporting and working with cross-functional teams in a dynamic environment.
• Strong communication for working with internal and external stakeholders

Benefits

• Health Care Plan (Medical, Dental & Vision)
• Paid Time Off (Vacation, Sick & Public Holidays)
• Training & Development
• Free Food & Snacks