Fractional Senior Data Analytics Contractor
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. $80 - $100 an hour Midpoint: $90/hour Comprehensive Benefits: We've got you covered with 100% of health insurance monthly premiums for employees, and 50% for dependents. Performance Bonus: Because exceptional work deserves exceptional rewards. Eligibility begins after 90 days. Equity Stake: Join us in shaping the future and be rewarded for your dedication with stock options. Continuous Growth: Up to $500 annual learning reimbursement because investing in your development is investing in our success. Committed to Parity: We place candidates within the band based on professional experience, not negotiating skills, as part of our overall effort to avoid gender pay discrepancy. Apply tot his job