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
Cloud • Information Technology • Security • Software • Cybersecurity
Lead product management efforts for data search and investigation products, ensuring alignment with customer needs and driving product success metrics.
Top Skills:
Data AnalyticsSaaSSecurity OperationsSIEMUx/Ui
Artificial Intelligence • Marketing Tech • Software
The Director of Strategic Sourcing will enhance procurement processes, drive technology sourcing strategies, lead system consolidation, and manage vendor relationships for optimal performance.
Top Skills:
AIDocusignIroncladProductiv
Cloud • Information Technology • Security • Software • Cybersecurity
As an Account Executive for Zscaler, you will build relationships with key stakeholders, create long-term account strategies, and act as a trusted advisor to clients by aligning technical solutions with their strategic goals.
Top Skills:
AICloud Security
What you need to know about the Charlotte Tech Scene
Ranked among the hottest tech cities in 2024 by CompTIA, Charlotte is quickly cementing its place as a major U.S. tech hub. Home to more than 90,000 tech workers, the city’s ecosystem is primed for continued growth, fueled by billions in annual funding from heavyweights like Microsoft and RevTech Labs, which has created thousands of fintech jobs and made the city a go-to for tech pros looking for their next big opportunity.
Key Facts About Charlotte Tech
- Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
- Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
- Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
- Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus
