Data Modeling and Analytics Architect

Vancouver 1 days agoFull-time External
465.4k - 721.5k / yr
The Role: This role encompasses both hands-on data modeling and the architectural guidance necessary to develop robust data marts to support the business’ data analytics and reporting requirements. You will be instrumental in designing data structures that support analysis for business intelligence, ultimately empowering data-driven decisions across the organization. A key responsibility will be the efficient design and development of the Data Model. You Are: • A strong collaborator who thrives in cross-functional teams and enjoys interacting with diverse stakeholders. • Focused on building strong relationships, possessing excellent communication skills to influence, gain buy-in, and provide clear guidance. • An excellent communicator, capable of effectively conveying complex technical concepts to both technical and non-technical audiences, including Enterprise Architects and analytics professionals. • A transformational leader who proactively shares ideas, champions best practices, and helps elevate the skills of the team. • A strong advocate for Data Governance principles and actively contributes to their implementation. • Hands-on experience with traditional RDBMS such as MSSQL or Oracle databases. • Familiarity with Agile and Scrum methodologies for project delivery. • Experience in designing and developing data solutions. The Work: • Coordinate and collaborate with business stakeholders to understand and translate business needs into effective solutions • Participate in requirement and high level design discussions, assessing the need for model and architectural changes • Take ownership of the design of data models, marts, and semantics for key business areas • Develop and maintain documentation on the data architecture, models, marts and semantics. • Balance conceptual architecture work with hands-on modelling in Oracle/AWS • Provide support and guidance to the development team during build and testing of the model Here’s what you need: • Minimum of 5 years of experience in data architecture and modelling • Minimum of 5 years in creating and optimizing data models and database schemas. • Minimum 3 years integrating data from diverse sources and managing ETL workflows. • Minimum 3 years experience with cloud platforms, big data frameworks, and ensuring data governance and security in cloud environments is essential. • Demonstrated expert knowledge in data mapping, data transformation processes, and SQL, with a proven ability to implement physical and relational data models for data analytics. • Proficiency in industry-standard data modeling tools and techniques (e.g., Oracle SQL Data Modeler, UML, dimensional modeling, etc.). • Understanding and experience with a modern data technology stack, such as AWS • Must have eligibility for reliability security clearance Bonus points if you have: • Bachelor’s Degree or Diploma in Computer Science, Information Technology, Electrical Engineering, or related field. • Certifications from a cloud service provider in Cloud Architecture, Data Architecture, or BI/Analytics • Experience with Oracle tools (i.e. Sql Modeler, ORDS, APEX) • Excellent communication and documentation skills • Ability to work independently and collaboratively in a fast-paced environment Compensation at Accenture varies depending on a wide array of factors, which may include but are not limited to the specific office location, role, skill set, and level of experience. As required by local law, Accenture provides a reasonable range of compensation, based on full-time employment, for roles that may be hired as set forth below. The recruiting efforts for this position are intended to fill a brand new position. The base pay range shown below is intended as a guideline to reflect the majority of offers for this role. It does not represent a maximum limit — in some cases, actual compensation may exceed the range where appropriate. Information on benefits is here. Role Location Annual Salary Range British Columbia/Ontario $90,850 to $140,850