Sr. ETL Engineer
Beaverton, OR
Applications have closed
Lucid Motors
With extraordinary design, performance, range, convenience, and utility, Lucid Gravity is the future of sustainable mobility, reimagining the luxury electric SUV.We are currently seeking an ETL Engineer who will design and develop enterprise data using pipeline technologies such as SQL, Python, Redshift, and Airflow. You will create and implement a Master Data Management strategy to ensure data standardization, quality, and governance, and provide a single source of truth for the domains. Our ideal candidate exhibits a can-do attitude and approaches his or her work with vigor and determination. Candidates will be expected to demonstrate excellence in their respective fields, to possess the ability to learn quickly and to strive for perfection within a fast-paced environment.
The Role
- ETL Design and Development of enterprise data using pipeline technologies such as SQL, Python, Redshift, and Airflow
- Design Data Marts, Fact, and Dimension tables.
- Create and implement a Master Data Management strategy to ensure data standardization, quality, and governance, and provide a single source of truth for the domains.
- Demonstrates proven success performing in one or more MDM applications: Customer, Product, or Supplier with multiple full-lifecycle implementation projects.
- Design, develop and automate, Self-serviced and Executive dashboards with Tableau and Grafana.
- Expert in normalization/de-normalization techniques for data analysis and optimum performance in big data environment using Presto, Redshift.
- Expert in data warehousing, data lake design, data modeling, and data management
- Interface with business customers, gathering requirements and delivering complete reporting solutions.
- Own the design, development, and maintenance of ongoing metrics, reports, analyses, dashboards, etc. to drive key business decisions.
- Deliver near-real-time and batch-processed data and applications to a team of analysts and data scientists who create insights and analytics applications for our stakeholders.
- Participate in data strategy and road map exercises, business intelligence/data warehouse product selection, design, and implementation
Qualifications
- Bachelor's or Master's degree in Computer Science, or related degree
- 7+ years of work experience with ETL, data modeling, and business intelligence data architectures.
- Expert in at least one SQL language such as ANSI SQL, T-SQL, or PL/SQL.
- Extensive experience with data analysis and Business Intelligence.
- Proven experience and expertise with Tableau and Similar tools.
- Experience with Scheduling and orchestration tools such as Airflow, Informatica, or Similar
- Experience developing and managing data warehouses.
- Experience in distributed and columnar databases.
- Advanced ability to draw insights from data and communicate them to the stakeholders and senior management as required
- Familiarity with AWS solutions such as S3, Parquet/ORC, Redshift
- Working with unstructured or semi-structured datasets
- Experience working directly with business users and executives to build reports.
- Familiar with, Spark, Kafka, and streaming applications.
- Familiar with Manufacturing, Sales, and Finance data.
Notice regarding COVID-19 protocols At Lucid, we prioritize the health and wellbeing of our employees, families, and friends above all else. In response to the novel Coronavirus all new Lucid employees, whose job will be based in the United States may or may not be required to provide original documentation confirming status as having received the prescribed inoculation (doses). Vaccination requirements are dependent upon location and position, please refer to the job description for more details. Individuals in positions requiring vaccinations may seek a medical and/or religious exemption from this requirement and may be granted such an accommodation after submitting a formal request to and the subsequent review and approval thereof by our dedicated Covid-19 Response team. To all recruitment agencies: Lucid Motors does not accept agency resumes. Please do not forward resumes to our careers alias or other Lucid Motors employees. Lucid Motors is not responsible for any fees related to unsolicited resumes.
Tags: Airflow Architecture AWS Big Data Business Intelligence Computer Science Data analysis Data management Data strategy Data warehouse Data Warehousing ETL Finance Grafana Informatica Kafka Parquet Python Redshift Spark SQL Streaming Tableau T-SQL
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Data Science Manager jobs
- Open Lead Data Analyst jobs
- Open MLOps Engineer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Data Engineer II jobs
- Open Data Manager jobs
- Open Principal Data Engineer jobs
- Open Power BI Developer jobs
- Open Data Scientist II jobs
- Open Junior Data Scientist jobs
- Open Sr Data Engineer jobs
- Open Data Analytics Engineer jobs
- Open Product Data Analyst jobs
- Open Business Intelligence Developer jobs
- Open Business Data Analyst jobs
- Open Data Analyst Intern jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Big Data Engineer jobs
- Open Principal Data Scientist jobs
- Open Azure Data Engineer jobs
- Open Data Quality Analyst jobs
- Open Manager, Data Engineering jobs
- Open Junior Data Engineer jobs
- Open Data Product Manager jobs
- Open Data quality-related jobs
- Open GCP-related jobs
- Open Business Intelligence-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open PhD-related jobs
- Open Deep Learning-related jobs
- Open Data visualization-related jobs
- Open Finance-related jobs
- Open PyTorch-related jobs
- Open APIs-related jobs
- Open TensorFlow-related jobs
- Open NLP-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open LLMs-related jobs
- Open CI/CD-related jobs
- Open Generative AI-related jobs
- Open Kubernetes-related jobs
- Open Hadoop-related jobs
- Open Data governance-related jobs
- Open Airflow-related jobs
- Open Docker-related jobs