Data Engineer

Advantage Resourcing
Advantage Resourcing

Job Overview

Advantage Resourcing is seeking a Data Engineer for our client in Carlsbad, CA. We are looking for a motivated data expert with experience in Python, SQL, Power BI and variety of Database technology.This is a W2 position (no C2C candidates please).The Data Engineer will support the business intelligence and data science strategies and related initiatives that deliver comprehensive data model for actionable data reporting and analysis for commercial, functional, business leadership and team members. Reporting to the Sr. Manager, Business Analytics and working within a highly matrixed organization, this position will be part of a global team of Business Analysts that contribute to the overall growth of the Global Services & Support business within the Life Sciences Solutions Group.What will you do?Work in collaboration with infrastructure and IT team to design, create and maintain optimal data pipeline architecture and data structures for Commercial Data Lake/Data Warehouse. Assemble large, complex data sets from business and reporting systems such as SAP, Business Objects, CRM, Cognos/EDW that meet functional / non-functional business requirements. Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc. Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL, Databricks, and AWS technology. Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data analytics needs. Work with data and analytics experts to strive for greater functionality in our data systems. Streamline existing and introduce enhanced reporting and analysis solutions that leverage complex data sources derived from multiple internal systems. Collaborate across regions and functional teams to provide data and reporting support for recurring business operating mechanisms, as well as ad-hoc, time sensitive requests to advance key initiatives.How will you get here? Minimum of 5 years with 3 years of experience in a Data Engineer role, who has attained a degree in Computer Science, Statistics, Informatics, Information Systems or another quantitative field. They should also have experience using the following software/tools:o Must have SQL knowledge and experience working with relational databases, query authoring (SQL) as well as familiarity with a variety of databases including Redshifto Must have 3 years experience with Python languageo Experience with Databricks, Spark or similar toolso Experience with at least one data pipeline and ETL tool like Databricks, Informatica, AWS Glue, Talend.o Experience working with AWS cloud services: EC2, S3, RDS, Redshift.o Experience creating Logical and Physical data model and documenting ERD Experience with Data mining, Data science and Predictive analytics is a plus. Experience with visualization tools like Power BI, Tableau. A successful history of manipulating, processing and extracting value from large disconnected datasets. Experience performing root cause analysis on data and processes to answer specific business questions and identify opportunities for improvement.Adv. Ref. #: 1027154 About Advantage Resourcing Advantage Resourcing makes all employment decisions without regard to race, color, religion, sex, sexual orientation, gender identity, gender expression, ancestry, medical condition, age, marital status, national origin, citizen status, political affiliation, union membership, genetic information, physical or mental disability, veteran status, denial of medical or family leave, pregnancy or pregnancy disability leave or any other protected group status as defined by federal, state or local law. We will provide reasonable accommodations throughout the application or interviewing process. If you require a reasonable accommodation, contact us. Advantage Resourcing is an E-verify employer.

View More
Job Detail
Shortlist Never pay anyone for job application test or interview.