Req I D
Client is looking for a Sr. Data Engineer, a motivated data expert with experience in Python, SQL, Power BI and variety of Database technology. Position will be in Carlsbad, CA.
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:
Must have SQL knowledge and experience working with relational databases, query authoring (SQL) as well as familiarity with a variety of databases including Redshift
Must have 3 years' experience with Python language
Experience with Databricks, Spark or similar tools
Experience with at least one data pipeline and ETL tool like Databricks, Informatica, AWS Glue, Talend.
Experience working with AWS cloud services: EC2, S3, RDS, Redshift.
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.