Role: Data Programmer
Location: Remote (Canada)
Employment Type: Longterm Contract
Department: BCX Service Excellence - BI Customer Reporting Team
Role Overview
We are seeking a talented Data Programmer to join our dynamic Customer Reporting \& Analytics team. In this role, you'll work with large-scale datasets to create efficient, scalable reporting solutions that deliver on both quality and accuracy. This position will specifically support data requirements for both Enterprise and Public sector accounts, ensuring robust reporting capabilities for our diverse client base.
A key focus of this position will be supporting data transformation processes, including data conversion and data mapping. This involves changing the format, structure, or content of data to make it compatible with new data sources or systems, ensuring seamless integration across our data ecosystem.
Key Responsibilities
·
Data Pipeline Development
: Design and implement robust processes to extract, transform, and load data from various sources
·
Database Management
: Develop and optimize SQL queries, stored procedures, and database schemas for performance and scalability
·
Programming \& Automation:
Write clean, efficient code in Python, R, SQL, and other relevant languages to automate data processes
·
Data Quality Assurance
: Implement data validation, cleansing, and monitoring procedures to ensure data integrity
·
Collaboration
: Work closely with data scientists, analysts, and business stakeholders to understand requirements and deliver solutions
·
Performance Optimization
: Monitor and optimize data processing performance, troubleshoot issues, and implement improvements
·
Documentation:
Create and maintain comprehensive technical documentation for data processes and systems
Preferred Education
·
Education
: Bachelor's degree in Computer Science, Data Science, Mathematics, Statistics, or related field
Required Technical Skills
·
Data Analysis:
Demonstrate your ability to collect, analyze, and interpret data to identify trends, patterns, and insights.
·
Data Visualization:
Proficiency in tools like Tableau, Power BI, Looker Studio or similar to create visual representations of data, analysis \& reporting
·
Programming Skills:
Knowledge of SQL for querying and managing databases and familiarity with BigQuery
·
Excel:
Strong proficiency in using Excel for data manipulation, analysis, and reporting.
·
Statistical Analysis:
Understanding of statistical concepts and ability to apply them to analyze data.
·
Cloud Platforms
: Knowledge of cloud data services Google Cloud Platform
Required Soft Skills
·
Time Management
: Ability to prioritize tasks, meet deadlines, and manage time effectively to maximize productivity.
·
Adaptability
: Flexibility to adjust to changing business needs, priorities, and work environments.
·
Active Listening
: listening to and understanding stakeholder needs, concerns, and feedback.
·
Self-Management
: Highly organized and detail-oriented with strong initiative and accountability for personal work quality.