Senior Database/Data Modelling Developer - Halifax
2 days ago
Job description
We areAt Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions.
Synechron's progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps, Data, and Software Engineering, servicing an array of noteworthy financial services and technology firms.
Through research and development initiatives in our FinLabs we develop solutions for modernization, from Artificial Intelligence and Blockchain to Data Science models, Digital Underwriting, mobile-first applications and more.
Over the last 20+ years, our company has been honored with multiple employer awards, recognizing our commitment to our talented teams.
With top clients to boast about, Synechron has a global workforce of 16,400+, and has 60 offices in 20 countries within key global markets.
Our challengeWe are seeking a skilled Database Developer and Data Modeler with expertise in designing efficient database schemas, writing complex database code, and optimizing query performance.
The ideal candidate will play a key role in translating business requirements into effective data models, developing and maintaining database objects, and ensuring optimal query performance through tuning and troubleshooting.
Additional Information*The base salary for this position will vary based on geography and other factors.In accordance with law, the base salary for this role if filled within Halifax, NS is CAD $80k – CAD $90k/year & benefits (see below).
The RoleResponsibilities:
Key
Responsibilities:
Data Modelling (Highest Priority):
Build and optimize database schemas based on simplified but clear business requirements.
Design Entity-Relationship diagrams, relationships, and normalization strategies.
Example tasks include creating tables for job candidates and work history (companies, job titles, dates).
SQL Query Development:
Write and optimize SQL queries based on the designed schema.
Query and Performance Tuning & Troubleshooting:
Discuss and implement indexing strategies to enhance query performance.
Optimize database queries and troubleshoot performance issues.
Apply fundamental database principles to maintain system efficiency.
Requirements:
Bachelor's degree in Computer Science, Information Technology, or related field.
8+ years' experience with SQL Server or similar databases.
Proven experience in data modeling based on business requirements.
Strong hands-on experience with Data Modeling (including ER diagrams, relationships, normalization).
Ability to design schemas from detailed business requirements.
Proven expertise in SQL query development, including complex joins, subqueries, and aggregations.
Good understanding of indexes, performance tuning, and optimization strategies.
Experience in writing views, stored procedures, triggers, and other database objects
Preferred, but not required:
Experience with data warehousing and ETL processes.
Familiarity with data modeling tools (e.g., ER/Studio, PowerDesigner).
Knowledge of NoSQL databases is a plus.
We offer:
A multinational organization with 60 offices in 20 countries and the possibility to work abroad.
15 days (3 weeks) of paid annual leave plus an additional 10 days of personal leave (floating days and sick days).
A comprehensive insurance plan including medical, dental, vision, life insurance, and long-term disability.Flexible hybrid policy.
RRSP with employer's contribution up to 4%.
A higher education certification policy.
On-demand Udemy for Business for all Synechron employees with free access to more than 5000 curated courses.
Coaching opportunities with experienced colleagues from our Financial Innovation Labs (FinLabs) and Center of Excellences (CoE) groups.
Cutting edge projects at the world's leading tier-one banks, financial institutions and insurance firms.
A truly diverse, fun-loving and global work culture.
S YNECHRON'S DIVERSITY & INCLUSION STATEMENT
Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer.
Our Diversity, Equity, and Inclusion (DEI) initiative 'Same Difference' is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all.
We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company.We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply.
We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.
All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant's gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.
Similar jobs
We are · At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron's progressive technologies and optimization strategi ...
1 day ago
We are · At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron's progressive technologies and optimization strategi ...
2 days ago
This role will improve the accuracy of numerical ocean models for the sub-Arctic gateway in North Atlantic. · Set up regional ocean model configurations based on a selected modern ocean model system using realistic geometry and forcing data; perform high-resolution multi-decadal ...
2 weeks ago
The Principal Electrical Engineer – Ports will provide senior technical leadership and expertise on major port and maritime infrastructure projects. · Bachelor's degree in Electrical Engineering (Master's preferred). · Registered Professional Engineer (P.Eng.) in Nova Scotia and/ ...
1 month ago
We're on the lookout for a full time Data Analyst. The ideal candidate is comfortable working between finance stakeholders and technical teams. · Analyze financial and operational data from multiple source systems. · Write and optimize SQL queries to extract, transform, and valid ...
1 month ago
We are seeking a highly motivated and skilled AI Engineer to join our team. · This role focuses on designing, developing, and deploying AI-driven solutions that address complex business challenges. · ...
4 days ago
Arcadis is looking for a Discipline Team Leader with a strong geotechnical / geo-structures background to develop and grow our design team in East Canada. · ...
1 month ago
+We are seeking a skilled and experienced Tableau Developer to join our analytics team. · ...
1 month ago
We are looking for an experienced Senior Guidewire PolicyCenter Developer to join our team. · ...
1 month ago
+In this role, you will create a client-focused culture within the company. You will develop relationships with key decision-makers and operations staff at our clients. · +Manage client relationships and act as escalation point for all client queries · Own and manage incidents/er ...
1 week ago
We want to hear from you. As an experienced Senior Project Manager in the Civil & Infrastructure team at Pomerleau Construction, you will manage large-scale building and infrastructure projects - ranging from $1.5 million to upwards of $1 billion - while working closely with our ...
2 weeks ago
We are seeking a highly skilled Guidewire PolicyCenter Technical Developer to join our team.About Us: · Cognizant is one of the world's leading professional services companies, · a redefining clients' business operating and technology models for the digital era.Design develop and ...
1 month ago
The Physics of Aging project is a collaboration between investigators in Geriatric Medicine and Physics and Atmospheric Science. We study aging, with an overarching goal to characterize and improve individual health prognosis. · ...
3 weeks ago
+The Sr. Developer role requires a seasoned professional with 8 to 12 years of experience in Power BI Service MS Power BI MS Excel Database and SQL. · +Develop and implement advanced data models using Power BI Service to enhance business intelligence capabilities. · Collaborate w ...
1 month ago
Natural Forces is seeking a Corporate Finance Analyst to support our team members in Halifax. · ...
1 month ago
This is an opportunity for someone who wants their modelling work and analyses to inform real decisions and support evidence-based planning for energy system development. · Supporting the development,maintenance,and application of NZA's open-source energy system model. · Contribu ...
2 weeks ago
The Occupational Therapist – Sexuality & Relationship Health Specialist provides holistic occupational therapy services to autistic adults aged 19 and older within Pinwheel's adult services model. · ...
1 month ago
This role supports evidence-based energy and climate planning in Atlantic Canada. The Energy System Modeller will contribute to scenario design, analysis and communication of modelling results through clear visuals and concise written summaries. · Supporting the development, main ...
2 weeks ago
Corporate Finance Analyst · Natural Forces is a leading Canadian clean energy developer that delivers projects in partnership with Indigenous Communities and Nations, CEDCs, Municipalities and other local communities across Canada, Ireland and France. · Our passion is to build re ...
1 month ago
You will join our Application Development and Production Support (ADPS) team, · which provides end-to-end application development and production support services to partner departments · and agencies across diverse business domains. · Provide SDLC strategies, · technical leadersh ...
1 month ago