Creatio Data Developer

Our portfolio spans 10+ top technologies across business applications, data, process, cloud, and AI.

We’re seeking a Creatio Data Developer to join our Delivery Team. In this role, you will combine strong database, migration, synchronization and integration knowledge with solid professional and client-facing skills.

About bitsinglassca

• Join a company that’s leading the way in AI and automation consulting.
• At Bits In Glass, you’ll do meaningful work with a supportive, driven team that loves to collaborate and celebrate wins together.
• Whether you’re coding, consulting or bringing bold ideas to the table, you’ll tackle real business challenges, grow your skills, and make a BIG impact.
• Our growing team has earned global recognition as a Great Place to Work and received multiple industry partner awards—while keeping things fun and people-focused.
• If you’re looking to deepen your expertise and solve real-world problems, Bits In Glass could be the place for you.
• Our vast experience in the IT industry and our current track record in enterprise software development, allow us to provide a full range of services to our clients.
• Bits In Glass helps organizations of all sizes to automate their businesses and leverage the power of the web and mobile technologies.

Responsibilities

• This role focuses on moving data from external systems into Creatio, synchronizing data across systems and databases, and helping customers define a practical migration approach based on their current architecture, data model, and business processes.
• Lead client discovery on source systems, data structures, field mappings, business rules, and integration requirements.
• Design and run end-to-end migrations into Creatio, covering staging, transformation, validation, load, sequencing, and cutover.
• Map entities, keys, dependencies, and parent-child relationships across source and target systems.
• Build and support synchronization between databases, applications, and CRM platforms, including full and incremental loads, upserts, change tracking, conflict handling, and rollback.
• Cleanse, normalize, deduplicate, enrich, and reconcile data, then validate completeness and accuracy after each load.
• Document mappings, transformation rules, assumptions, and validation criteria.
• Troubleshoot issues across the database, integration, and application layers.
• Own the work from analysis through development, testing, validation, and post-deployment support.
• Work closely with customers, analysts, developers, and QA, and also work well on your own.
• ETL/ELT pipelines and SSIS packages, plus REST APIs, OData, and common integration patterns.

Requirements

• its data model, core entities, and integration patterns.
• accounts, contacts, leads, opportunities, products, activities, and cases, along with source systems such as MS Dynamics, Business Central, and spreadsheets.
• strong relational database and data modeling knowledge, with hands-on MS SQL Server and PostgreSQL experience.
• advanced querying (joins, subqueries, CTEs, aggregations, and validation queries) and database objects (views, stored procedures, functions, indexes, and triggers).
• strong JSON skills, and familiarity with CSV, XML, spreadsheets, and flat files.
• Git or Bitbucket, and Agile delivery using Jira.
• secure handling of sensitive business data.
• clear with both technical and non-technical stakeholders, and confident in client-facing discussions about architecture, scope, risks, and synchronization approach.
• willing to ask clarifying questions and challenge unclear assumptions; a proactive problem-solver with strong attention to detail; able to learn and adapt quickly to new tools and environments Python for data processing, validation, reconciliation, and automation.
• Familiarity with Microsoft Fabric, data lakes, and medallion architecture (Bronze, Silver, Gold).

Preferred

• Skills & Experience A bachelor's degree or equivalent practical experience.
• Experience in data migration, data integration, database development, or data engineering.
• Salesforce, Microsoft Dynamics, HubSpot, or similar CRM experience is highly valued.
• C# for integration services, backend utilities, and migration tools.
• Ability to build reusable scripts that improve consistency and reduce manual effort.
• Practical use of AI for mapping analysis, SQL drafting, transformation review, reconciliation, and documentation, with careful validation of outputs to protect accuracy, security, and business context.
• BIG is a high growth Cloud Consulting firm with offices in Edmonton, Calgary, Toronto, Denver, India and the United Kingdom.
• Our clients are in Canada, UK, India and the US.
• We are a team of experienced IT professionals who specialize in providing business value to organizations looking at leveraging modern platforms such as Pega, Appian, MuleSoft and Boomi.