ETL Developer

<p>We are committed to expanding our use of integration with Salesforce. Working closely with the Director, an expert in Salesforce coding, you will be mentored and given a chance to build out your experience in Salesforce Development. Your career opportunities will grow exponentially both internally and externally with this exposure.</p>

Toronto, ON

Altus Group

<p><span style="font-weight: 400;">In 2005, we started with 400 employees and have grown exponentially to over 2300 around the globe today. Altus Group employees don&rsquo;t see boundaries, they see opportunity. They deliver results for our clients and our company and are recognized and rewarded for the value they create. This is an opportunity to in depth on multiple projects that encompass many industries, geographic reach and high profile design.</span></p> <p><span style="font-weight: 400;">At Altus, we want you to realize your potential. We value collaboration and knowledge sharing of best practices. We support professional growth and we actively seek out ideas. This is the place to present the newest research, to introduce the coolest tech and see it come to fruition and be applied. Your work will make a difference.</span></p> <p>&nbsp;</p> http://www.altusgroup.com

keywords: who we are,what we do,who we need,what's in it for you,collaborate,architect,implement,develop quality standards,the education,the knowledge,the communication skills,the drive

Mid Level

Overview: <p><strong>Opportunity Awaits at Altus Group!</strong></p> <p dir="LTR"><strong>Who we are</strong></p> <p dir="LTR">Altus Group is a leading provider of independent advisory services, software and data solutions to the global commercial real estate industry. Our businesses, Altus Analytics, and Altus Expert Services reflect decades of experience, a range of expertise and technology-enabled capabilities. Our solutions empower clients to analyze, gain market insight and recognize value on their real estate investments.</p> <p dir="LTR">Headquartered in Canada, we have approximately 2,500 employees around the world, with operations in North America, Europe, and Asia Pacific.</p> <p dir="LTR">We are at the centre of what drives the real estate industry and continue to break ground every day with innovative solutions and best practices that touch every aspect of the real estate life cycle.&nbsp;</p> <p dir="LTR"><strong>Who we need</strong></p> <p dir="LTR">Reporting to the Director, Enterprise Architecture, we are adding an ETL Developer to the team. This is an opportunity to architect integration solutions that will manage data analysis and data integration of various corporate systems (Salesforce, NetSuite, Workday and Deltek Vision) across our growing global organization.</p> <p dir="LTR"><strong>What&rsquo;s in it for you?</strong>&nbsp;</p> <p dir="LTR"><em>Development of in-demand skills.</em> We are committed to expanding our use of integration with Salesforce. Working closely with the Director, an expert in Salesforce coding, you will be mentored and given a chance to build out your experience in Salesforce Development. Your career opportunities will grow exponentially both internally and externally with this exposure.</p> <p dir="LTR"><em>Unique integration challenges. </em>We are adding a web store to our platform and enabling B2B use of Shopify. You will be one of the first to use this new technology and gain an opportunity to help build out our e-commerce offering.&nbsp;</p> <p dir="LTR"><em>Global reach.</em> We are a global organization, often acquiring new businesses. With these acquisitions comes the need for specialized integrations or migrating data into our systems.</p> <p dir="DEFAULT"><em>Exposure. </em>The Application Services team at Altus group play an essential piece in Altus&rsquo; new vision to move towards a software solutions company. &nbsp;With fewer than a dozen key team members, we operate like a start-up within a larger organization. This translates to incredible exposure, a collaborative atmosphere, and hands-on challenges.</p>
Responsibilities: <p dir="LTR"><strong>Our new ETL Developer will:</strong></p> <ul> <li> <p dir="LTR">Collaborate. You will work with Analysts and Business Users to translate functional specifications into technical designs for implementation and deployment.</p> </li> <li> <p dir="LTR">Architect. You will build extensible data acquisition and integration solutions to meet the functional and non-functional requirements as defined by the business. You will optimize data integration to provide the best performance under increasing data volumes.</p> </li> <li> <p dir="LTR">Implement. You will introduce processes and logic to extract, transform, and distribute data across one or more systems.</p> </li> <li> <p dir="LTR">Develop quality standards. You will ensure data quality and integrity across various database systems. You will review other integration efforts to ensure consistency and make recommendations.</p> </li> </ul>
Requirements: <p dir="LTR"><strong>Our new ETL Developer has:</strong></p> <ul> <li> <p dir="LTR">The education. A degree or diploma in Computer Science or a related field.</p> </li> <li> <p dir="LTR">The knowledge. 3-5 years of hands-on experience and a depth of understanding of:</p> <ul> <li> <p dir="LTR">Data mapping and incremental data loading (including staging).</p> </li> <li> <p dir="LTR">SQL and modern database design.</p> </li> <li> <p dir="LTR">Salesforce ERD.</p> </li> <li> <p dir="LTR">Integration tools such as Jitterbit, Mule, or similar.</p> </li> <li> <p dir="LTR">Designing, developing, and performance tuning ETL/ELT programs using SSIS.</p> </li> </ul> </li> <li> <p dir="LTR">The communication skills. Professional documentation and excellent verbal communication skills. You can communicate technical details with patience, in a concise, clear manner.</p> </li> <li> <p dir="LTR">The drive. You have proven problem-solving and analytical skills, with a willingness to dig into details.</p> </li> </ul> <p dir="LTR"><strong><br />Need any more reasons to join Altus?</strong></p> <p dir="DEFAULT">In 2005, we started with 400 employees and have grown exponentially to over 2300 around the globe today. Altus Group employees don&rsquo;t see boundaries; they see opportunity. They deliver results for our clients and our company and are recognized and rewarded for the value they create. This is an opportunity to work in depth on multiple projects that encompass many industries, geographic reach, and high profile design.</p> <p dir="LTR">At Altus, we want you to realize your potential. We value collaboration and knowledge sharing of best practices. We support professional growth, and we actively seek out ideas. This is the place to present the newest research, to introduce the coolest tech and see it come to fruition and be applied. Your work will make a difference.</p> <p dir="LTR">Altus Group isn&rsquo;t just about the amazing work we do. We work hard to create a dynamic company culture that reflects the values of our employees and what motivates them individually and as a team:&nbsp;</p> <p dir="LTR"><em>Altus Cares</em> - We are always seeking ways to give back to our communities and support causes important to our employees. We are actively involved in local charity work, and we believe in laying the groundwork for a more prosperous future. Our personal highlight is our involvement with Ronald McDonald house in four different countries where we volunteer every September as a company.</p> <p dir="LTR"><em>Education</em> - We believe our employees represent the best this industry has to offer and we want to reflect their commitment to education and continued learning.</p> <p dir="LTR"><em>Team Spirit</em> - We host an annual hockey tournament and an annual client party. We play badminton in the winter and pick up soccer in the summer. There&rsquo;s surprise treats, seasonal events, and Friday lunches too.</p> <p dir="LTR">At Altus Group, we are proud to say that many of our teams are comprised of members who have been here five years or longer. We think that speaks volumes about our atmosphere and our people.<br /><br /></p> <p><em>Come realize your potential at Altus Group!</em></p> <p>Altus Group is committed to fostering an inclusive and accessible environment where employees feel valued and respected, and where every employee has the opportunity to realize their potential. We are committed to providing reasonable accommodations, if required, and will work with you to meet your needs. If you are a person with a disability and require assistance during the application process, please contact us at <span class=" WJD1 ">accessibility@altusgroup.com</span> or 416-641-9500.</p>