Apply

Associate Data Engineer

Posted about 9 hours agoViewed

View full description

💎 Seniority level: Junior, 1+ years

📍 Location: USA

🔍 Industry: Digital Media Agency

🏢 Company: Spring & Bond👥 11-50Digital MarketingAdvertisingDigital MediaConsulting

⏳ Experience: 1+ years

🪄 Skills: AWSPythonSQLData AnalysisETLGitData engineeringPandas

Requirements:
  • 1+ years of experience in a data engineering or related role.
  • Strong SQL skills, including the ability to write complex queries using JOINs and aggregate functions.
  • Proficiency in Python and data manipulation libraries such as Pandas.
  • Experience with data validation techniques and tools.
  • Familiarity with AWS cloud services, particularly S3 and Lambda.
  • Experience with Git for code version control.
  • Detail-oriented with a focus on data accuracy and quality.
  • Organized with a systematic approach to managing data workflows.
  • Comfortable working in an ambiguous environment and able to independently drive projects forward.
  • Nimble and able to adapt to changing priorities.
Responsibilities:
  • Design, develop, and maintain ETL pipelines to ingest and transform data from various sources.
  • Implement data validation processes to ensure data accuracy and consistency throughout the data lifecycle, using tools like Regex.
  • Write and optimize SQL queries for data extraction, aggregation, and analysis.
  • Develop and maintain Python scripts and Pandas dataframes for data manipulation and analysis.
  • Utilize AWS Lambda functions to automate data processing tasks.
  • Manage code using Git for version control and collaborative development.
  • Collaborate with data analysts, media strategists, and other stakeholders to understand their data requirements and provide solutions.
  • Communicate technical concepts to non-technical stakeholders and translate business needs into technical specifications.
  • Troubleshoot and resolve data-related issues, identifying areas for improvement and efficiency gains.
  • Document data processes, pipelines, and transformations for knowledge sharing and maintainability.
  • Work with vendors to ensure seamless data integration and resolve any data delivery issues.
  • Apply critical thinking skills to analyze complex data problems and develop innovative solutions.
Apply

Related Jobs

Apply

📍 United States

💸 65000.0 - 100000.0 USD per year

🔍 Data Analytics

🏢 Company: DAS42👥 51-100💰 almost 4 years agoCloud Data ServicesBusiness IntelligenceBig DataData IntegrationAnalytics

  • 1-3 years of work experience in a data analytics or data engineering role.
  • Advanced proficiency with Python and SQL.
  • Previously worked within a consulting/professional services environment (preferred)
  • Experience with business visualization tools (e.g. Looker, Tableau, Microsoft PowerBI).
  • Ability to explain technical concepts to non-technical people.
  • Experience with data warehousing and using Snowflake.
  • Experience with the AWS or Google Cloud ecosystem (e.g. BigQuery, Redshift).
  • Worked with or for Media & Entertainment or Telecom companies (preferred).
  • Bachelor's or Master’s degree in a quantitative field (i.e. Statistics or Operations Research) or technical field (i.e. Computer Science or Engineering) (preferred).
  • Implement data warehouse solutions, ETL pipelines, and business intelligence reporting tools.
  • Develop data models around stated use cases to capture clients' KPIs, data transformations, and data requirements; validation and testing of data models.
  • Support, maintain, and document clients’ data environments.
  • Contribute to and collaborate on project deliverables, either independently or as part of a larger consulting team.
  • Work within a project management framework (i.e., Agile) to meet objectives, understand scope, and impact of your work across an organization.
  • Guide clients on optimizing their data environment to operate most effectively and efficiently for them. Clarify management objectives through data solutions.
  • Work with the Sales and Marketing teams to develop Thought Leadership and workable POCs and support our sellers by talking to clients about DAS42’s go-to-market capabilities.

AWSPythonSQLBusiness IntelligenceCloud ComputingETLGCPSnowflakeData engineeringREST APIData visualizationData modeling

Posted 9 days ago
Apply
Apply
🔥 Sr. Associate, Data Engineer
Posted about 1 month ago

📍 United States

💸 95000.0 - 110000.0 USD per year

🔍 Hair wellness

🏢 Company: Nutrafol👥 201-500💰 $35,000,000 Series B almost 6 years agoBiotechnologyNutraceuticalConsumer GoodsWellnessHealth Care

  • 2-3 years of experience in a relevant Data & Analytics role within an eCommerce environment; DTC experience is a plus.
  • Familiarity with data ETL process and data transfer capabilities as well as database design.
  • Experience with Data Management and Data Quality concepts and practices.
  • Strong working knowledge of SQL and pulling data out of multiple systems.
  • Experience in Snowflake or other similar data warehouse technology.
  • Experience with DBT (strongly preferred) and/or other programming languages.
  • Experience in Data Visualization & related BI Tools (Tableau, Power BI) preferred.
  • Ability to contribute meaningfully to stakeholder conversations.
  • Strong analytical and problem-solving skills.
  • Transform business requirements into thoughtful technical solutions around schema design and database object development that support data integration across multiple sourcing paths.
  • Assist with the development of new data schemas to support a robust data ETL process for various projects like ad hoc analysis and data visualization.
  • Monitor and maintain data quality and define/implement corrective actions when required.
  • Support troubleshooting potential bugs within the database.
  • Develop procedures to document key processes and queries.

SQLETLSnowflakeTableauData management

Posted about 1 month ago
Apply