At a Glance
- Tasks: Design and develop scalable ETL applications for data warehousing and business intelligence.
- Company: Join Symbiotic Digital, a 100% Indigenous owned tech company making waves in IT solutions.
- Benefits: Competitive salary, full-time onsite role, and opportunities for professional growth.
- Other info: Collaborative environment with a focus on innovation and career advancement.
- Why this job: Be part of a dynamic team solving real-world data challenges with cutting-edge technology.
- Qualifications: Experience with Microsoft and AWS technologies, strong SQL skills, and a passion for data.
The predicted salary is between 121500 - 148500 $ per year.
We are seeking a Senior ETL Developer to design, develop, and maintain data warehouse and business intelligence solutions. The successful candidate will be responsible for building scalable ETL applications, developing high-quality code, managing data integrations, and supporting enterprise data platforms across cloud technologies. This position requires full-time onsite attendance, five days per week.
Key Responsibilities
- Design, implement, and expand data pipelines through extraction, transformation, and loading (ETL) activities.
- Translate technical system specifications into working, tested applications.
- Develop detailed programming specifications and application code.
- Compile, maintain, test, and debug data-driven programs.
- Troubleshoot technical issues related to software implementation, conversion, and migration activities.
- Design, develop, and maintain database backend and ETL applications for Data Warehouse and Business Intelligence environments.
- Build and enhance application functionality using ETL development techniques and coding best practices.
- Ensure solutions are scalable, maintainable, and aligned with development standards.
- Create and maintain technical documentation.
- Collaborate with development teams and business stakeholders to deliver high-quality solutions.
- Investigate ETL pipeline issues and recommend corrective actions.
- Support data integration, data quality, and analytics initiatives.
Mandatory Qualifications
- Experience with Microsoft technologies including Power BI.
- Experience with Databricks.
- Experience with AWS technologies including Amazon Aurora, Amazon Relational Database Service (RDS), AWS Glue, OpenSearch.
- Experience developing ETL solutions across structured and semi-structured data repositories.
- Experience implementing and maintaining ETL scheduling and dependency logic.
- Experience with data integration, data cleansing, and data analytics.
- Experience with data modeling and data warehouse design principles.
- Experience with database administration and management.
- Strong SQL development and performance tuning experience.
- Experience using Git and source control strategies.
- Experience creating technical documentation including source-to-target mappings and detailed design documents.
- Experience gathering, documenting, and validating business requirements.
- Experience working across the Software Development Lifecycle (SDLC), including development, testing, QA, and deployment.
- Strong verbal and written communication skills.
Nice-to-Have Qualifications
- Knowledge of Accessibility for Ontarians with Disabilities Act (AODA) standards and regulations.
- Experience designing dashboards, KPIs, and operational reporting solutions.
- Experience with C# development, APIs, and application functions.
- Experience with PowerShell and other scripting languages.
- Knowledge of rapid application development methodologies.
- Experience supporting production implementations and post-deployment activities.
About Symbiotic Digital: Symbiotic Digital provides the IT Experts you need that solve problems and get things done. We serve customers in two ways: Digital Experts - IT Consulting expertise and Recruitment - Find The Right People You Need. We are a 100% Indigenous owned company.
Senior ETL Developer in Toronto employer: Symbiotic Group
At Symbiotic Digital, we pride ourselves on fostering a collaborative and innovative work culture that empowers our employees to thrive. As a Lead Full Stack Developer in Toronto, you will enjoy competitive benefits, continuous learning opportunities, and the chance to work with cutting-edge technologies in a vibrant city known for its tech scene. Join us to make a meaningful impact while advancing your career in a supportive environment that values creativity and excellence.
