Data Engineer
Orennia
full-time
Posted on:
Location Type: Hybrid
Location: Calgary • 🇨🇦 Canada
Visit company websiteJob Level
Mid-LevelSenior
Tech Stack
AWSCloudGoogle Cloud PlatformHadoopPythonSQL
About the role
- Analyze, design, develop, test, review, document and troubleshoot data pipeline / ELT solutions against multiple structured and unstructured data sources
- Support our team of analysts through developing requirements and delivering solutions
- Develop code to scrape public websites for data and perform ELT processes
- Maintain, monitor, and support production ELT processes and respond to error and emergency issues
Requirements
- Excellent knowledge and experience with Big Data concepts like data lakes, data warehouses, ELT strategies, and best practices
- Strong understanding of relational and dimensional data modeling
- Strong analytical and problem-solving skills
- Experience with DBT and SQL, and proficient with Python
- Extensive experience with cloud-based data processing and warehousing technologies (Databricks, Snowflake, etc)
- Experience with Lean and Agile development methodologies (such as Kanban or SCRUM)
- Comfortable in entrepreneurial, self-starting, and fast-paced environment, working both independently and with highly skilled teams
- Experience with other Big Data processing technologies and cloud services (AWS, GCP, Snowflake, Hive, Hadoop, MS SQL, etc)
- Experience with JIRA and similar organizational tools
- Experience building web-scraping tools against publicly available datasets (considered an asset)
- Experience with GIS/geospatial data processing, integration, and analysis (considered an asset)
- Experience building or supporting data visualizations (considered an asset)
- Deep intellectual curiosity with a results-focused relentless pursuit of answers
- Ability to work in a fast-paced start-up environment, embrace change and ambiguity
- Hungry to learn and contribute
Benefits
- Competitive total rewards package
- Comprehensive health, dental and vision benefits
- Savings program with company matching
- Learning and development budget
- Generous time off including holidays, paid vacation days and paid sick days
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
Big Datadata lakesdata warehousesELT strategiesrelational data modelingdimensional data modelingDBTSQLPythonweb scraping
Soft skills
analytical skillsproblem-solving skillsself-startingability to work independentlyteam collaborationintellectual curiosityresults-focusedadaptabilityembrace changehunger to learn