Solutions Architect

At Project X, we take on massive data analytics projects, building customized solutions using tech like big data, MicroStrategy and Teradata.&nbsp;This is Big Data with all of the challenges and rewards that comes with it.&nbsp;<br />We need a Solutions Architect who wants to&nbsp;have hands-on database architecting responsibilities and function in a consulting capacity with our clients.

Toronto, Canada

Project X Ltd.

<div>Project X Ltd. is a data and analytics boutique, systems integration and support firm.</div> <p>By focusing on our clients&rsquo; objectives and best interests we are able to work collaboratively to drive business value.&nbsp;Our team of experienced professionals works along side our customers using an integrated delivery model which allows us to tailor our approach to the individual needs of an engagement. From strategy through execution to delivery we work with our clients to achieve results in a quick and cost effective manner.</p> <p><strong>Our Difference is our Approach.</strong></p> Creative, innovative and adaptive approach to solutions to meet client objectives<br />Single focus on delivering value<br />Act with a sense of urgency<br />Maintain collegial approach<br />Work in the best interests of client<br />Generate great results<br />Develop trusted relationships<br /> <p>&nbsp;</p> http://www.pxltd.ca

keywords: who we are,who we need,innovation,what we do,culture,build relationships,consulting,database builds,performance,compliance,database administration,teradata,knowledge,experience,why join,travel

Experienced

Overview: <p><strong>Who we are</strong></p> <p><span style="font-weight: 400;">Every tech consulting company wants a rockstar or a guru. We aren&rsquo;t every other company. At Project X, we want invincible and uncanny super heroes to join our team. We hire energetic and innovative people who solve client problems in unexpected ways and who enjoy the challenge of building prototypes in hours or days when it would take others weeks or months. It goes with the territory when you go from a client intake meeting to developing a solution, literally on the road and come out of it with a data analytics solution that solves a, dare we say apocalyptic, crisis.</span></p> <p><span style="font-weight: 400;">At Project X, we take on massive data analytics projects, building customized solutions using awesome tech like big data, MicroStrategy and Teradata. We aren&rsquo;t afraid to commit to the toughest of projects because we think differently, almost mutant like. Our teams are consistently representing Project X while working out of client sites across the GTA and nothing in the field scares them. Well, maybe bees. And spiders. But we will never leave you out there in quicksand; our consultants are first and foremost Project X team members surrounded by an incredibly knowledgeable, dynamic and responsive support system; with mentoring and coaching from Project Managers and the Executive leadership. We are a culture of consultants with a strong home base not unlike a certain superhero academy that shares our initials. Mostly, we are a culture of team members who own what they do, want to grow through the journey and enjoy working on awesome projects.</span></p> <p><span style="font-weight: 400;">We want a Solutions Architect who is leader, a communicator and a hands-on team player.&nbsp;</span><span style="font-weight: 400;">We need a </span><strong>Solutions Architect</strong><span style="font-weight: 400;"> to build big data solutions side-by-side with our co-founder and current lead Architect. From communicating with Project Managers or tooling and modelling a database within our Project X Labs for our geodash projects, the new </span><strong>Solutions Architect</strong><span style="font-weight: 400;"> at Project X will play a key role in the growth of our company.</span></p> <p><br /><br /></p>
Responsibilities: <p>As a Project X&nbsp;<strong>Solutions Architect</strong>&nbsp;you will have hands-on database architecting responsibilities and function in a consulting capacity with our clients.</p> <p><strong>The consulting side, you will</strong>:</p> <ul> <li>Build relationships. You will engage technical and non technical client staff in update communications using appropriate language and terminology for your audience (third party knowledge workers and consultants; client or third party data architects and solution designers; and other systems designers and developers, as well as‬‬ MicroStrategy and other BI designers and users‬‬).</li> <li>Meet end-user expectations. You will construct business and technical solutions that are time sensitive, cost effective and user accepted.</li> <li>‬‬Understand Enterprise Architecture. You will dive deep into the client&rsquo;s business processes and work with the business to promote enterprise wide understanding of their data's lifecycle.</li> <li>Consult. You will proactively identify barriers to success and identify methods to resolve differences.</li> </ul> <p><strong>The hands-on technical work, you will:</strong></p> <ul> <li>Build and maintain Logical and Physical Data Models using ERwin‬‬ (or other modeling tools).</li> <li>Use SQL, NoSQL or other data analysis &amp; interrogation methods to do complex joins of database tables and other non database sources such as Excel or .csv files.</li> <li>Prepare data based systems for access by MicroStrategy (preferred) or other equivalent BI tools. Perform query tuning, as well as, table, index and view management in the database environment (Teradata, Oracle, SQL server preferred. Hadoop would be beneficial as emerging tools).</li> <li>Enforce compliance and adherence to generally accepted EDW development and productions standards and conventions‬‬.</li> <li>Own the Database Administration process and perform all relevant tasks including: <ul> <li>write and promote DDL from development to test and then to production databases‬‬</li> <li>move or construct test data for general testing purpose‬‬</li> <li>maintain development, test, training and production database environments‬‬</li> <li>design and build BAR (Backup Archive and Recovery) procedures‬‬</li> </ul> </li> <li>Use Teradata tools, including:‬ <ul> <li>Teradata Studio Express or Teradata SQL Assistant‬‬</li> <li>TPT (BTEQ, TPUMP, MLOAD, FASTLOAD, FAST EXPORT)‬‬</li> <li>read and diagnose an "Explain" plan‬‬</li> <li>design and write Stored Procedure and Macros‬‬</li> <li>understand database authorization and access for granting privileges‬‬</li> </ul> </li> </ul>
Requirements: <p><strong>How do we know that&rsquo;s you? You have:</strong></p> <ul> <li>10 years (or more) hands-on experience designing and building logical and physical databases, Data Modelling, programming, ETL work, Business Intelligence.</li> <li>Expert understanding of current Big Data and Data Warehouse Architectures and which tools apply to each part of the architectures.</li> <li>Experience with conceptualization, design and documentation of business and technology roadmaps including: <ul> <li>assessment of current environments</li> <li>evaluations of future-state alternatives</li> <li>gap analysis</li> <li>selection and recommendations of most appropriate solutions for the client</li> </ul> </li> <li>Expertise working with MS Office: Outlook, PowerPoint, Word, Excel, Visio; GANTT style planning and roadmapping; MS Project.</li> <li>Understanding of Python, R, SAS and an understanding of the BI tools' architectural and database interface requirements.</li> <li>Intermediate to expert knowledge with Teradata tools.<br />&nbsp;</li> </ul> <p><strong>Why join Project X</strong></p> <p>As one of CIO Review&rsquo;s &ldquo;100 Most Promising Big Data Solution Providers of 2015&rdquo;, as well as one of the &ldquo;50 Most Promising Google Technology Solution Providers of 2015&Prime; Project X has an incredibly rich environment for gaining awesome exposure and experience to the power of big data analytics. Whether you are new to your career or more established, we foster a supportive, challenging and rewarding environment.</p> <p><strong>Transparency is paramount</strong></p> <p>At Project X, we succeed because we use an integrated delivery model which allows the team to tailor their approach to the individual needs of an engagement. From strategy through execution to delivery, Project X works with their clients to achieve results in a quick and cost effective manner. This approach defines our success. It also directly impact our consultants: the hours can be long and it can feel a bit overwhelming to be on-client-site for extended periods.</p> <p>That said, we make every effort to regroup as a team once a quarter and bring everyone &ldquo;home&rdquo; for BBQs, games and celebrations - and we're hiring to increase this balance! We also pride ourselves on remaining GTA focused with minimal travel requiring an overnight stay.</p> <p><strong>And don&rsquo;t forget the perks</strong></p> <p>At Project X, we reward hard work with recognition, opportunity and a competitive salary. We offer a comprehensive Health and Dental Benefits Package. We offer an awesome gym membership discount, a casual dress code, a fun working environment and more.</p> <p>Project X Ltd drives its success by focusing on their clients&rsquo; needs and objectives and building teams of incredibly talented, fun, dedicated people. If you believe in working collectively to raise the bar, we want to meet you. Express your interest here and follow us on&nbsp;<a href="https://twitter.com/ProjectXLtd" target="_blank">Twitter</a>,&nbsp;<a href="https://www.facebook.com/ProjectXLtd" target="_blank">Facebook</a>&nbsp;or&nbsp;<a href="https://www.linkedin.com/company/project-x-ltd-?trk=top_nav_home" target="_blank">LinkedIn</a>.</p>