200+ applicants

Company

Sunnova Energy · 1 week ago

Data Architect

United States

Full-time

Remote

Mid, Senior Level

5+ years exp

Maximize your interview chances

Clean EnergyEnergy

No H1B

Insider Connection @Sunnova Energy

Discover valuable connections within the company who might provide insights and potential referrals.
Get 3x more responses when you reach out via email instead of LinkedIn.

Responsibilities

Design, build, and maintain data pipelines that seamlessly integrate data from Salesforce, OEM data streams, and other sources, utilizing tools like Informatica, Fivetran and dbt.

Manage Snowflake data warehouses, optimize data storage and retrieval, and implement best practices for performance, Security, and scalability.

Build and manage scalable, high-performance data solutions using AWS services (S3, Lambda, EC2, Redshift, etc.), ensuring security, reliability, and efficiency.

Extract, transform, and load (ETL) data from Salesforce and OEM data streams into Snowflake, implementing data consistency and accuracy for analytics and reporting purposes.

Work closely with data analysts, data scientists, and cross-functional teams to understand data needs, gather requirements, and implement solutions that support data-driven decision-making.

Maintain high-quality data standards and apply governance practices to ensure data integrity, compliance, and security.

Continuously monitor and enhance pipeline performance, reducing downtime and optimizing data flow from diverse data sources. Examines and identifies database structural needs by evaluating application and query performance, operational patterns, and various data use cases.

Researches and rigorously evaluates sources of information to determine limitations in reliability or usability.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Data ArchitectureSnowflakeAWSData Pipeline DevelopmentSalesforce IntegrationInformaticaPythonData WarehousingData QualityData GovernanceAgile PracticesData Science ConceptsVersion Control (Git)

Required

Bachelor's degree or equivalent.

5+ years in data architecture, data engineering, data warehousing, 3+ years of experience in Snowflake or related Cloud Databases

Expertise in pulling data from Salesforce and OEM data sources and building complex data pipelines for ingesting large volumes of data at various frequencies.

Strong experience with Snowflake and orchestration tools like Fivetran and dbt for efficient data integration, transformation, and orchestration.

Proficient with the company's data model and how it fits into various organizational functions. Ability to analyze substantial amounts of data and draw meaningful trends and conclusions.

Hands-on experience with AWS services, especially as they pertain to data storage, transformation, and pipeline management. In-depth knowledge of AWS architecture and services, especially Lambda functions, to manage serverless operations.

Extensive experience with Salesforce data integration (APIs, SOQL) and familiarity with OEM data streams and associated integration challenges.

Legally authorized to work in the US for ANY employer.

Preferred

Relevant certification around AWS, Snowflake, Python, Data Ware/Lake/Lake House background or experience with edge computing telemetry data, and Salesforce.

Proficient with software development using cloud-based infrastructure and database services from AWS and Snowflake.

Familiar with data catalog, data quality, master data management (MDM), and data governance best practices.

Familiar with agile software development practices, test-driven development, and story point estimations.

Familiar with data science concepts such as time-series forecasting, stochastic optimization, classification, and regression analysis.

Familiar with renewable energy concepts such as solar energy production modeling, battery dispatch, and optimal dispatch modeling.

Familiarity with version control systems (e.g., Git) and CI/CD practices in data projects.