As a Business Intelligence Data Engineer in our growing Business Analytics & Data Platform teams, you will support the development and maturing of a data-driven organization by creating intuitive means of accessing analytics by transforming data and developing, constructing, and testing cloud-based data architectures.

Collaborating with data scientists, data engineers, business analytics stakeholders, and analytics developers, you will optimize the databases you work with using your knowledge of data warehouse solutions, data modeling, and ETL. Although not a data scientist, you’ll be fully integrated into our data science team and the modeling process. You will serve as an internal resource for all things data, advising on data quality issues, feature creation, and deployment best practices.

Responsibilities:

• Build and maintain data systems and pipelines to transform legacy data structures distributed across dozens of cloud databases, on-prem databases, and a data warehouse into cleaned, well-organized, and documented data structures and data features ready for use by business analytics consumers and analysts
• Develop and maintain the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using primarily SQL Server, Databricks, and Azure technologies
• Use Python, Scala and SQL to assist with data cleaning, profiling, and exploration
• Collaborate with cross-functional business teams in Marketing, Sales, Operations, etc.

Qualifications:

• 3+ years in a data engineer role supporting data science and analytics teams, preferably in a SaaS company or other environment with web-scale data (billions of rows) and cloud model deployments
• Ability to thrive in a fast-paced remote-first startup environment
• Proactive and self-directed; excels at identifying opportunities to add value and contribute to the overall success of the team
• MS-SQL and Python
• Performance optimization
• Data warehouse technologies such as Microsoft Synapse
• Building and maintaining Data pipelines
• Experience using Databricks
• Proficiency with Azure Data Factory
• Working knowledge of reporting tools such as Tableau, Power BI (using DAX), Domo, etc
• Experience with Apache Spark, Hadoop, or other parallel processing technologies
• Experience with data visualization libraries, ER diagrams or tools
• Strong understanding of data transformation techniques and cloud data platforms
• Familiar with Data Lake and best practices
• Experience with Kafka Streaming (highly desirable)
• High-level familiarity with machine learning techniques and processes (highly desirable)

Our Benefits

• We invest in our employees by offering them a diverse suite of benefits from best-in-class carriers, with enough choice and flexibility to keep them and their families healthy and happy today and tomorrow
• Comprehensive benefits plan, including medical, dental, and vision, covered up to 100%
• Discretionary Paid Time Off, giving you the flexibility to rest, relax and recharge away from work
• Regular manager check-ins to drive performance and career growth through Lattice
• Monthly company all-hands meetings

Scorpion is an equal opportunity employer and considers applicants for all positions without regard to race, color, religion or belief, sex, age, national origin, citizenship status, marital status, military/veteran status, genetic information, sexual orientation, gender identity, or physical or mental disability. We believe in creating a dynamic work environment that values diversity and inclusion.

#LI-SK1

Job Type: Full-time

Please Note :
apexdining.ca is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, apexdining.ca provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.