Data Developer with strong SQL & ETL experience
About the role
Data Developer (ETL / SQL / BI)
Location: 7000 - 113 Street Edmonton, Alberta, CAN, T6H 5T6
Project Overview:
Justice Information Management System (JIMS) 3.0 is a data integration project designed to consolidate several disjointed reporting data marts into a modern, efficient Enterprise Data Warehouse (EDW). This role plays a critical part in ETL planning, design, and testing efforts while analyzing and re-structuring legacy court data from the Justice Online Information Network (JOIN).
Role Description:
This Data Developer will work closely with Senior Data Architects and will focus on:
- Profiling, mapping, and migrating legacy data marts into a new data warehouse structure
- Designing and developing ETL processes
- Creating and testing Dimensions and Fact tables
- Analyzing large volumes of legacy data and ensuring business alignment
- Collaborating across technical and business teams for data quality assurance
Responsibilities:
- Deliver application programming tasks in line with business and technical requirements
- Analyze and document requirements, develop SQL queries and ETL logic
- Build reusable components (views, stored procedures, tables, batch jobs)
- Perform unit, system, and integration testing
- Document technical design and maintain project artifacts
- Support go-live and post-deployment efforts, including bug fixing and optimization
- Liaise with stakeholders and provide reports/status updates
Required Qualifications (Must Have):
- Bachelor’s degree in Computer Science or related field
- Eligible for Enhanced Security Clearance (includes Criminal & Credit Check)
- 5+ years of experience with Microsoft SQL Server
- 5+ years of hands-on ETL development
- 5+ years of experience in Data Warehousing or Business Intelligence (BI) projects
- 5+ years of experience in Enterprise Application Development
- 5+ years of experience creating technical documentation and user training materials
Preferred Qualifications (Nice to Have):
- 3+ years of experience with Agile methodologies
- 3+ years performing smoke, unit, system, and integration testing
- 3+ years working on User Acceptance Testing (UAT) for large, complex projects
- 3+ years of experience in public sector environments
About United Software Group Inc
Welcome to USG - Pioneering IT & Engineering solutions provider. Nurturing legacy of 22 years, USG has grown into a global powerhouse, distinguished for its expertise in Information Technology. As a leading IT & Engineering Solutions company, we've cultivated diversified revenue streams and a reputation for excellence. We are an Minority Business Enterprise with focus on diversity and inclusion, proudly serving Global Clients in Banking, Financial, Insurance, Manufacturing, Engineering, Healthcare, Transportation, Communication, Hi-tech, and Public Departments.
Our Evolution- USG embarked on a journey rooted in innovation and reliability, envisioning a future where technology transforms businesses. Over the years, we have refined our strategies, adapted to industry shifts, and remained at the forefront of the IT landscape.
Global Impact, Local Precision- USG's influence spans the globe, strategically positioned to deliver top-notch IT & Engineering Solutions services. Our commitment to local expertise ensures that our global reach is complemented by a nuanced understanding of regional needs and client expectations.
Diversified Excellence- Beyond our specialized services, USG's success is rooted in our ability to diversify revenue streams. This strategic approach positions us to navigate market dynamics effectively while consistently delivering exceptional value to our clients.
Our Dynamic Team- USG's success story is co-authored by our dynamic and skilled team. Their expertise and collaborative spirit drive us to surpass client expectations consistently.
Join the Future with USG. Embark on a journey with USG, where innovation converges with reliability, and excellence knows no limits. Whether you seek advanced IT solutions or aspire to grow your career through our staffing services, USG is your steadfast partner in shaping a technologically advanced future. Discover the USG advantage – where tomorrow's solutions are delivered today.
Data Developer with strong SQL & ETL experience
About the role
Data Developer (ETL / SQL / BI)
Location: 7000 - 113 Street Edmonton, Alberta, CAN, T6H 5T6
Project Overview:
Justice Information Management System (JIMS) 3.0 is a data integration project designed to consolidate several disjointed reporting data marts into a modern, efficient Enterprise Data Warehouse (EDW). This role plays a critical part in ETL planning, design, and testing efforts while analyzing and re-structuring legacy court data from the Justice Online Information Network (JOIN).
Role Description:
This Data Developer will work closely with Senior Data Architects and will focus on:
- Profiling, mapping, and migrating legacy data marts into a new data warehouse structure
- Designing and developing ETL processes
- Creating and testing Dimensions and Fact tables
- Analyzing large volumes of legacy data and ensuring business alignment
- Collaborating across technical and business teams for data quality assurance
Responsibilities:
- Deliver application programming tasks in line with business and technical requirements
- Analyze and document requirements, develop SQL queries and ETL logic
- Build reusable components (views, stored procedures, tables, batch jobs)
- Perform unit, system, and integration testing
- Document technical design and maintain project artifacts
- Support go-live and post-deployment efforts, including bug fixing and optimization
- Liaise with stakeholders and provide reports/status updates
Required Qualifications (Must Have):
- Bachelor’s degree in Computer Science or related field
- Eligible for Enhanced Security Clearance (includes Criminal & Credit Check)
- 5+ years of experience with Microsoft SQL Server
- 5+ years of hands-on ETL development
- 5+ years of experience in Data Warehousing or Business Intelligence (BI) projects
- 5+ years of experience in Enterprise Application Development
- 5+ years of experience creating technical documentation and user training materials
Preferred Qualifications (Nice to Have):
- 3+ years of experience with Agile methodologies
- 3+ years performing smoke, unit, system, and integration testing
- 3+ years working on User Acceptance Testing (UAT) for large, complex projects
- 3+ years of experience in public sector environments
About United Software Group Inc
Welcome to USG - Pioneering IT & Engineering solutions provider. Nurturing legacy of 22 years, USG has grown into a global powerhouse, distinguished for its expertise in Information Technology. As a leading IT & Engineering Solutions company, we've cultivated diversified revenue streams and a reputation for excellence. We are an Minority Business Enterprise with focus on diversity and inclusion, proudly serving Global Clients in Banking, Financial, Insurance, Manufacturing, Engineering, Healthcare, Transportation, Communication, Hi-tech, and Public Departments.
Our Evolution- USG embarked on a journey rooted in innovation and reliability, envisioning a future where technology transforms businesses. Over the years, we have refined our strategies, adapted to industry shifts, and remained at the forefront of the IT landscape.
Global Impact, Local Precision- USG's influence spans the globe, strategically positioned to deliver top-notch IT & Engineering Solutions services. Our commitment to local expertise ensures that our global reach is complemented by a nuanced understanding of regional needs and client expectations.
Diversified Excellence- Beyond our specialized services, USG's success is rooted in our ability to diversify revenue streams. This strategic approach positions us to navigate market dynamics effectively while consistently delivering exceptional value to our clients.
Our Dynamic Team- USG's success story is co-authored by our dynamic and skilled team. Their expertise and collaborative spirit drive us to surpass client expectations consistently.
Join the Future with USG. Embark on a journey with USG, where innovation converges with reliability, and excellence knows no limits. Whether you seek advanced IT solutions or aspire to grow your career through our staffing services, USG is your steadfast partner in shaping a technologically advanced future. Discover the USG advantage – where tomorrow's solutions are delivered today.