Analytics Consultant

We need an <strong>Analytics Consultant</strong> with a technical background and solid business acumen. This is a role for someone who can present insight and action, not metrics and numbers, to senior executives and empower them to make informed decisions.

Toronto, ON

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>

keywords: who we are,what we do,who we need,what's in it for you?,design,recommend and implement,report,collaborate,the education and experience,the technical skills,the bonus skills,the communication skills,a consulting state-of-mind

Entry Level

Overview: <p><strong>Data is our core DNA</strong></p> <p><strong>About Project X</strong></p> <p>We work with clients to solve problems and gain insight through the use of data and analytics. Our clients give us their most challenging situations and no problem is too big or small for our team.</p> <p>Every day at Project X is a call to address the challenges our clients have. That&rsquo;s the life of a team of trusted advisors creating data and analytics solutions for complex client problems. We do this through collaboration, creativity and an innate need to solve tough data problems.</p> <p>Data can be messy and problematic and our teams generally land somewhere in the middle of it. And that&rsquo;s where the passion comes in; to work at Project X you must share our obsession for the essence of data, to break through and make sense of it all and of course, add value at every stage of the process.</p> <p>Data is our core DNA. What makes Project X unique is our custom methodology that delivers results rapidly and allows for our team&rsquo;s creativity to solve the problems we&rsquo;re trusted to work on. This, paired with the fact that data runs deep in our veins and is what makes up who we are, individually and as a team, allows us to do the work we&rsquo;re passionate about. It is the foundation that translates into a common understanding, a way of being, that is apparent not just to us at Project X, but to our clients.</p> <p><strong>What we do</strong></p> <p>At Project X, we work side-by-side with our clients to create a tailored approach that meets their needs. From strategy through execution to delivery, Project X works with our clients to achieve results in a quick and cost-effective manner using our rapid results methodology. This approach defines our success and sets us apart.</p> <p><strong>Who we need</strong></p> <p>We need an <strong>Analytics Consultant</strong> with a technical background and solid business acumen to work with internal and business stakeholders to provide knowledge and expertise on Business Intelligence projects. This is a role for someone who can present insight and action, not metrics and numbers, to senior executives and empower them to make informed decisions.</p>
Responsibilities: <p><strong>What our Analytics Consultant will do:</strong></p> <ul> <li>Assist in the design of a BI solution from existing data warehouse and other enterprise data sources.</li> <li>Recommend and implement solutions to achieve required business functions.</li> <li>Implement materialized views of the data cubes and/or BI data marts.</li> <li>Create different report style sheet in compliance with the clients report style guidelines.</li> <li>Build reports and dashboards for deployment in a web-based environment in accordance with predefined detailed report specifications and conduct the required unit testing.</li> <li>Play a key role developing project artifacts; business requirements documents, detailed design documents and report specifications.</li> <li>Prepare and execute test cases for unit and integration testing in development and UAT.</li> <li>Assist the BI Architect in designing logical and physical dimensional data mart models.</li> <li>Assist in initial performance tuning and recommend options as required.</li> <li>Provide report development training, guidance and knowledge transfer to the development team.</li> <li>Work closely with the Project Lead to ensure deliverables and milestones are achieved.</li> <li>Provide oral and written project status reports to the Project Lead on an ongoing basis.</li> </ul>
Requirements: <p><strong>And how do we know that&rsquo;s you? You have:</strong></p> <ul> <li>The right combination of education and experience. A university degree or college diploma combined with direct experience: <ul> <li>You have two or more years DB programming experience and have advanced SQL skills.</li> <li>You understand complex views and stored procedures and have hands-on exposure working with BI/data warehousing solutions.</li> </ul> </li> <li>The practical knowledge of database model and design patterns: <ul> <li>Specifically dimensional and third normal form data mart and data warehouse design concepts.</li> <li>RDBMS concepts and technologies</li> </ul> </li> <li>The bonus skills. Not required, but a definite asset: <ul> <li>An ETL tool, ideally SSIS, Informatica, DataStage.</li> <li>ETL architecture and design.</li> <li>ERWin or another data modeling tool.</li> </ul> </li> <li>The communication skills. You have the ability to communicate complex information and issues to all levels of the organization. You excel at making presentations, negotiating timelines and providing updates. The written materials you produce are equally impressive and effective.</li> <li>A consulting state-of-mind. It&rsquo;s a thing. You&rsquo;ll know if you have it. So will we. You have the ability to work autonomously and away from headquarters for long periods of time. And still find your way back &ldquo;home&rdquo; and into the comfortable, open and sharing mental and physical space of our office on a regular basis.</li> </ul> <p><strong>Why join Project X?</strong></p> <p>Project X Ltd drives success by focusing on building teams of incredibly talented, fun, dedicated people.</p> <p>At Project X, we work hard for our clients but we also work hard to continue to be an employer of choice. We reward hard work and forward thinking with recognition, a fun company culture, opportunity to advance your career and a competitive salary.</p> <p>We also offer other employment benefits like:</p> <ul> <li>Health and dental benefits package.</li> <li>Gym membership discount.</li> <li>Casual dress code and working environment.</li> <li>Holiday parties and BBQs.</li> <li>Getting together for team socials and sporting events.</li> </ul> <p>While we often work onsite with our clients, we make sure we spend lots of time together to ensure everyone feels connected to the mission, company culture and is a valued member of the team.</p> <p>If you believe in working collectively to raise the bar, we want to meet you. Express your interest here and follow us on <a href="">Twitter</a>, <a href="">Facebook</a> or <a href="">LinkedIn</a>.</p> <p>Project X welcomes and encourages applications from people with disabilities. Accommodations are available on request for candidates taking part in all aspects of the selection process.</p>