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 • Sales • Security • Software • Cybersecurity • Data Privacy
The Account Executive will sell Identity Security solutions, manage customer relationships, develop business plans, and exceed revenue goals.
Top Skills:
Salesforce
Artificial Intelligence • Cloud • Sales • Security • Software • Cybersecurity • Data Privacy
The role involves selling SailPoint's Identity Security Solution, engaging with customers, developing business plans, and leading a team for successful sales outcomes. Responsibilities include exceeding revenue goals, providing tailored solutions, and maintaining high customer service standards.
Top Skills:
Salesforce
Artificial Intelligence • Cloud • Sales • Security • Software • Cybersecurity • Data Privacy
Seeking an Account Executive to drive sales of SailPoint's Identity Security Solutions, exceed revenue goals, and ensure superior customer experiences while collaborating with teams and partners.
Top Skills:
Salesforce
What you need to know about the Austin Tech Scene
Austin has a diverse and thriving tech ecosystem thanks to home-grown companies like Dell and major campuses for IBM, AMD and Apple. The state’s flagship university, the University of Texas at Austin, is known for its engineering school, and the city is known for its annual South by Southwest tech and media conference. Austin’s tech scene spans many verticals, but it’s particularly known for hardware, including semiconductors, as well as AI, biotechnology and cloud computing. And its food and music scene, low taxes and favorable climate has made the city a destination for tech workers from across the country.
Key Facts About Austin Tech
- Number of Tech Workers: 180,500; 13.7% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Dell, IBM, AMD, Apple, Alphabet
- Key Industries: Artificial intelligence, hardware, cloud computing, software, healthtech
- Funding Landscape: $4.5 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Live Oak Ventures, Austin Ventures, Hinge Capital, Gigafund, KdT Ventures, Next Coast Ventures, Silverton Partners
- Research Centers and Universities: University of Texas, Southwestern University, Texas State University, Center for Complex Quantum Systems, Oden Institute for Computational Engineering and Sciences, Texas Advanced Computing Center
