Sql dba Offres d'emploi - Calgary, AB

Putting people first, every day

BDO is a firm built on a foundation of positive relationships with our people and our clients. Each day, our professionals provide exceptional service, helping clients with advice and insight they can trust. In turn, we offer an award-winning environment that fosters a with a high priority on your personal and professional growth.

Your Opportunity

BDO Digitalis looking for aData Analytics/ DataEngineerNew Gradto join our growing client-facing team on a full-time permanent basis.This is a net new role and responsibilities will include:

• Play an integral role in our delivery practice as we execute on enterprise level client engagements through our various industry specializations

• Engage directly with clients and drive the implementation and successful end user experience of analytics solutions; execute on engagements and collaborate with the client and delivery team to ensure that any applicable milestones and deliverables are met on time and on budget

• Design and develop industry-specific data models for client projects in industries such as Natural Resources, Finance, Manufacturing and Distribution, and Retail

• Work with other engineers to enhance data models and improve data query efficiency; create complex data queries tofacilitatead hoc and exploratory analytics

• Build real-time data capture and transformation functionality across all products and build out technology stack for Business Intelligence and Data Warehouse

• Clean data: review for data inconsistencies andidentifyopportunities to improve data collection process; Wrangle/Munge data: transform or map data from one raw data form into another format with the intent of making it moreappropriateand valuable for analytics

• Develop, construct, test andmaintainarchitectures such as databases and large-scale data processing systems; design, construct, install, test andmaintainhighly scalable data management systems

• Employ a variety of languages and tools (e.g. scripting languages) to marry systems together

• Build or recommend data visualization tools and business intelligence tools such as interactive dashboards and automated reports, to enable leaders to make swift, fact-based decisions

• Remain up to date of development technologies, both current and futurein order todeliverstate-of-the-artAnalytics solutions for our customers

How do we define success for your role?

• You demonstrate BDO's core values through all aspect of your work: Integrity, Respect and Collaboration

• You understand your client’s industry, challenges, and opportunities; client describe you as positive, professional, and deliveringhigh qualitywork

• Youidentify, recommend, and are focused on effective service delivery to your clients

• You share in an inclusive and engaging work environment that develops,retains& attracts talent

• You activelyparticipatein the adoption of digital tools and strategies to drive an innovative workplace

• You grow yourexpertisethrough learning and professional development.

Your experience and education

• Post-secondary education in engineering or computer science or equivalent work experience

• Good experienceworking with Azure Databricks, Azure Data Factory and Azure Data Lake

• Programming experience in Python

• Strong attention to the quality of work delivered (attention to detail)

• Able to adapt quickly to changing client requirements

• The following are considered and asset:

• Experience using the Apache Hadoop ecosystem (Spark, Data Lake, Hive, HDFS, Impala) to tackle "big data" problems

• Knowledge of ETL, ELT, Lambda and Kappa data architectures

• Experience with the Microsoft SQL Server Analytics stackincluding:Core SQL, SSIS, SSRS, SSAS

• Experience working with SQL and NoSQL databases

• Knowledge of Continuous Integration and Source Control systems (e.g. Gradle, Maven, Bamboo, TeamCity, Git)

• Data Visualization experience in Power BI, Tableau, or similar

• Exposure to data science, machinelearningor statistics

• Some experience using Docker