As a Senior Data Engineer Contractor, you'll design and optimize data pipelines in Databricks, implementing Medallion Architecture while collaborating with stakeholders to ensure data quality and efficient ETL processes.
About Omnidian
Omnidian, Inc. is a fast-growing Series C tech-enabled service company revolutionizing performance assurance for the distributed solar and energy storage industries. Omnidian is building a more sustainable future for the planet through our passionate teams, our innovative technology, and by creating an amazing customer experience. We are headquartered in Seattle, WA
The Job
As a Senior Data Analytics Contractor, you will use technology such as Python and SQL to perform exploratory analysis of raw data. Your primary focus will be to dive into our Databricks environment to summarize and profile data, including translation, mapping to destination systems and data cleansing. We need a high-level analytical thinker who can rapidly absorb our business logic, relieve internal resource strain, and deliver sophisticated data products that empower stakeholders to make informed decisions.
What You'll Do
- At Omnidian we believe in trust and autonomy. How you create an impact is ultimately up to you. Here is an outline of some of the things you’ll be doing:
- Synthesize complex raw data from a databricks landing area.
- Perform deep-dive analysis to map raw data to appropriate systems of record, identify and document quality issues and work with internal and external business partners on mitigations for data availability or quality challenges.
- Partner with business leaders to document data needs for their workstreams and map to raw incoming data as well as to internal source systems.
- Translate business requirements into technical specifications for the engineering team.
Who You Are
- An analytical storyteller who doesn't just provide numbers but explains what they mean for the business.
- A fast learner capable of mastering specific data landscape and business model with minimal ramp-up time.
- A proactive communicator who can bridge the gap between technical data structures and executive-level summaries.
- Rigorous and detail-oriented, with a "trust but verify" mindset regarding data quality and consistency.
Experience You’ll Need
- 5+ years of experience in Data Analytics, Business Intelligence, or Insights Engineering.
- Expert-level SQL skills, specifically for data transformation, window functions, and complex joins within a data warehouse environment.
- Strong proficiency with Databricks, including experience navigating notebooks and querying Delta Tables.
- Experience working within a Medallion Architecture, specifically focusing on the consumption of Silver and Gold layers.
- Advanced Data Visualization experience (e.g., Power BI, Tableau, or Databricks SQL Dashboards).Proven track record of delivering insights in a fast-paced, contract-based environment.
Experience That’s a Plus
- Familiarity with Python (PySpark) for data manipulation beyond standard SQL.
- Background in the solar, utility, or renewable energy industries.
Work-Life & Culture
- Most of our roles offer the opportunity to work remotely
- If you are in the Seattle area, we offer a vibrant office space in the historic and beautiful Smith Tower, in the heart of Pioneer Square
- We love to lift each other up through company-wide slack channels such as #puppiesandpets, #omnidian-wellness, #praiseandbooms and #sustainablefuture
- We have affinity groups to help employees feel seen and supported, such as Rainbow Array, BIPOC, Thriving Survivors, Vets at Omnidian, Black Lights Matter and Neurospicy R Us
- We are a passionate, mission driven team that believes in collaboration, mutual respect and trust. For examples, come Discover our Story!
Grow with Us
- We mentor and invest in our employees and prioritize them for future opportunities. Check out our Instagram reels to see a few career journey examples
- Internal candidates: Check out our advice on Internal Transfer: Job Application Process
- We’re a fast-growing startup, which means we’re constantly reinventing processes, adding new products, and asking people to use all of their skills and talents. That means there’s gonna be a lot of opportunities for you to grow, which also means you will likely be stretched in ways you’ve never experienced in a job before. If you are resilient, determined, and not afraid of a big challenge, come apply.
Privacy
California-based candidates: To understand more about the data we collect and process as part of your application, please view our California Job Candidate Privacy Policy. https://www.omnidian.com/privacy-policy-ca-candidates/
Diversity and Inclusion
We strongly believe that diversity of experience, perspectives, and background will lead to a better environment for our employees and a better product for our customers. We are committed to the principle of equal employment opportunity for all employees and to providing employees with a work environment free of discrimination and harassment. We value diversity and inclusion and are committed to ensuring our hiring and retention practices, as well as our office culture, reflects this value.
We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.
Omnidian is an equal opportunity employer. We are committed to diversity in the workplace. We make employment decisions on the basis of merit and business need. We hire without consideration to age, ancestry, citizenship, disability, gender expression, gender identity, marital status, national origin, political activity or affiliation, race, religion, sexual orientation, veteran status, or any other basis protected by law.
We invite you to be part of our mission to create a workplace that is inclusive and welcoming to all.
Top Skills
Airflow
Spark
AWS
Azure
Azure Data Factory
Azure Devops
Databricks
Dbt
Delta Lake
GCP
Git
Pyspark
Scala
SQL
Terraform
Similar Jobs
Artificial Intelligence • Cloud • Machine Learning • Mobile • Software • Virtual Reality • App development
As a Machine Learning Engineer, you'll build and deploy models for core products, apply ML techniques to solve problems, and collaborate on features.
Top Skills:
Caffe2PyTorchScikit-LearnSpark MlTensorFlow
Cloud • Fintech • Information Technology • Machine Learning • Software • App development • Generative AI
The Strategic Account Manager at BlackLine will drive sales in top-tier accounts, manage client relationships, and achieve sales targets. Responsibilities include leading sales processes, understanding business priorities, and collaborating across teams.
Top Skills:
Cloud SoftwareCRMErpHcmSaaS
Cloud • Fintech • Information Technology • Machine Learning • Software • App development • Generative AI
The Account Manager retains and grows business within a portfolio of large corporation accounts, collaborating with internal teams to maximize customer value and drive sales.
Top Skills:
SaaSSalesforce
What you need to know about the San Francisco Tech Scene
San Francisco and the surrounding Bay Area attracts more startup funding than any other region in the world. Home to Stanford University and UC Berkeley, leading VC firms and several of the world’s most valuable companies, the Bay Area is the place to go for anyone looking to make it big in the tech industry. That said, San Francisco has a lot to offer beyond technology thanks to a thriving art and music scene, excellent food and a short drive to several of the country’s most beautiful recreational areas.
Key Facts About San Francisco Tech
- Number of Tech Workers: 365,500; 13.9% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Google, Apple, Salesforce, Meta
- Key Industries: Artificial intelligence, cloud computing, fintech, consumer technology, software
- Funding Landscape: $50.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Sequoia Capital, Andreessen Horowitz, Bessemer Venture Partners, Greylock Partners, Khosla Ventures, Kleiner Perkins
- Research Centers and Universities: Stanford University; University of California, Berkeley; University of San Francisco; Santa Clara University; Ames Research Center; Center for AI Safety; California Institute for Regenerative Medicine
