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
.png)
Consumer Web • eCommerce • Machine Learning • Software • Sports • Analytics
The PSA Hobby Concierge Representative assists customers at submission centers, facilitates submission intake, provides customer care, and looks to enhance submission processes.
eCommerce • Mobile • Payments
Lead the Strategic Partnerships team, managing relationships with major retailers and publishers, optimizing processes, achieving growth targets, and ensuring partner retention while developing innovative solutions.
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
The role involves managing Privileged Access Management systems, ensuring secure credential management, and integrating PAM solutions with existing infrastructures while supporting audit and compliance initiatives.
Top Skills:
1PasswordActive DirectoryAWSAzureAzure AdBashConfluenceDelinea Secret ServerDevOpsGCPJIRALogscaleNeo4JPowershellPythonRest ApisSIEM
What you need to know about the Colorado Tech Scene
With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.
Key Facts About Colorado Tech
- Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
- Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
- Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
- Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute
