Project X Ltd. is a boutique advisory, systems integration and support firm focusing on data & analytics and business consulting$1. .$1
Business Intelligence • Data Integration • IT Effectiveness • Rapid Results • Systems Integration
August 28
🏢 In-office - Toronto
Project X Ltd. is a boutique advisory, systems integration and support firm focusing on data & analytics and business consulting$1. .$1
Business Intelligence • Data Integration • IT Effectiveness • Rapid Results • Systems Integration
• Collaborate with clients to understand their business goals and develop data strategies aligned with their objectives. • Lead the planning and roadmap development for data architecture projects, ensuring alignment with organizational priorities. • Design and develop conceptual, logical, and physical data models to support business requirements and data analysis needs. • Implement best practices for data modeling, including normalization, denormalization, and dimensional modeling techniques. • Lead the design and implementation of data integration solutions to consolidate and harmonize data from multiple sources. • Develop and optimize Extract, Transform, Load (ETL) processes to ensure efficient data movement and transformation. • Provide expertise in database management tasks such as database installation, configuration, performance tuning, and capacity planning. • Optimize database performance and scalability through indexing strategies, query optimization, and partitioning techniques. • Define and enforce data governance policies and standards to ensure data quality, integrity, and security. • Implement access controls, encryption, and auditing mechanisms to protect sensitive data assets. • Design and develop interactive dashboards, reports, and visualizations to communicate insights and key metrics to stakeholders. • Utilize data visualization tools such as Power BI, Tableau, or equivalent to create compelling and actionable visualizations. • Create and maintain documentation for data architecture solutions, including technical specifications, data dictionaries, and architectural diagrams. • Share knowledge and best practices with team members and clients through training sessions, workshops, and knowledge transfer activities.
• College degree, Bachelor's, or Master's degree in Computer Science, Information Systems, or a related field. • 3-5 years of experience in data architecture, data modeling, and database design. • Proficiency in data modeling tools such as ERwin, ER/Studio, or equivalent. • Strong SQL skills and experience with relational database management systems (e.g., SQL Server, Oracle, PostgreSQL). • Hands-on experience with ETL tools and processes, such as Informatica, Talend, or SSIS. • Expertise in data visualization and reporting tools such as Power BI, Tableau, or QlikView. • Knowledge of data governance principles, data security practices, and regulatory compliance requirements. • Excellent analytical and problem-solving skills, with the ability to translate business requirements into technical solutions. • Strong communication and interpersonal skills, with the ability to effectively collaborate with clients and team members.
Apply Now