Team recruiter


Application Developer - SQL, Python, Kanban, ETL, Government Exp. (Remote)

Reference id:950686
Posted on: 2/5/2025
  Location: Edmonton, AB - Remote

Job Description

One of government our clients is looking for an Application Developer - SQL, Python, Kanban, ETL, Government Exp. (Remote)
Length: 12 months contract with a possibility of extension
Location: Edmonton, Alberta - REMOTE
Hours of Work: 8:15 to 4:30 Alberta time (with a 1 hr lunch break), Monday through Friday excluding holidays observed by the province. Resources must be available during this time.


'The start date of this job is flexible and in order to find the best candidate the job may remain open much longer than the date mentioned on this posting... or you may be asked to start sooner than the expected start date if you are able to do so !'

Please read the job description below. If this interests you, please send a MS-Word version copy of your resume (ASAP) along with a telephone contact number: E-mail to yangzom@teamrecruiter.com

Please mention the job title above in the subject line
The recruiter in charge of this role is Yangzom

After you have submitted your resume via e-mail please complete the application for this specific job by clicking 'Submit Your Resume for this Job' at the bottom of this page to match your resume to the job.

If you are interested in further opportunities, why not also do a general registration in our database. By visiting our website and clicking on 'Database Registration'

If you do not think you are a match for this opportunity, but know someone who is, feel free to forward this email to them and you will be eligible for a referral bonus upon a successful hire.

Requirements:
NOTE:
- Three references, for whom similar work has been performed, must be provided. Reference checks may or may not be completed to assist with scoring the proposed resource.
- Resources will work remotely, though you must be available for onsite meetings when required.
- Onsite meetings include but are not limited to strategic, architectural, and technical discussions, meetings with team members, senior managers, directors, executive directors and business clients. The frequency of meetings could be up to 3-4 monthly.
- Equipment Requirements: Resource will require own equipment
- A standard criminal record check will be required before we start the Enhanced Security Clearance process.
- An Enhanced Security Clearance will be required for this position, which will be coordinated only for this position.

PROJECT NAME: JIMS (Justice Information Management System)

SCOPE:
The Data Unit requires the support of contingent labour to support a data integration project aimed to re-design and implement several reporting data marts, with conformed dimensions, containing court data into an Enterprise Data Warehouse (EDW) and a set of dependent views.

The position will be responsible for performing technical strategic functions, ensuring the architecture supports Justice data analytics and reporting needs.

Additionally, this role may support application of the Data Fabric architecture, data quality, data standards, and best practices to development as needed.

The successful candidate is expected to have a broad skill set and be capable of performing diverse functions and activities, including but not limited to:
 Understanding of data warehouse design principles, including dimensional modeling, star schemas, snowflake schemas, and the use of conformed dimensions to ensure consistency across data marts.
 Create both logical and physical data models that efficiently store data and support business processes.
 Support the development and adoption of best practices for data management, integration and common data management, and standardized methodologies.
 Contribute to development of individual data architectures and data quality practices, as needed, to support business objectives.
 Work with datasets using ETL (Extract, Transform, Load) tools and techniques for integrating data from various sources into the EDW.
 Interact with clients/partners (-internal and/or external).

DUTIES:
Deliver applications programming and analysis tasks as part of a system development process as well as provide application support, maintenance and enhancements. An Application Developer applies a broad knowledge of various technical areas to foresee and rectify certain problem areas within technology or with a mix of technologies, but the focus is to ensure a certain business/functional use case is solved with the help of technology.

 Liaise with business units and program areas to ensure solutions meet current and strategic ministry needs.
 Align development team to follow Application and Data Architecture.
 Write code for the most complex Functional and Technical Designs with minimal defects.
 Hands - on experience with building and managing data solutions using SQL and/or Python.
 Experience in data modelling (star or snowflake schema), including designing and developing data models to support business requirements.
 Develop and implement data warehouse solutions to support business intelligence and analytical needs.
 Demonstrate strong commitment to Data Security and Compliance to protect sensitive information and enforce data governance in enterprise platforms (access control, security policies across platforms etc.).
 Conduct data profiling to identify data trends, patterns and data quality issues.
 Experience with software development best practices including code reviews, unit testing and documentation.
 Define non-functional requirements (Performance, Availability, Portability, Recovery / Recoverability etc.).
 Assess technical impacts up front and recommend better ways of designing application to ease the development.
 Produce Technical Design, Database structure and Application Architecture for a new average to high complex application.
 Seek for the best technical design solution that respects budget and timeline. Advocate the re-use of existing components/frameworks.
 Innovate in providing better efficient ways to design application.
 Review Technical Designs from other developers and recommend optimization if necessary.
 Evaluate, with assistance, the quality of the product being delivered, and take action to improve situations.
 Assist/Execute performance/penetration tests and troubleshoot issues at the system level.
 Isolate root cause of issues and provide solution options/recommendations.
 Provide tracking and reporting of time and status on all work, as required.
 Contribute to the creation of the Application Lifecycle Planning.
 Identify and coordinate release schedules.
 Identify service requests and priorities with customers.
 Ensure planned releases remain on schedule.

Qualifications:
EDUCATION
The proposed resource must meet or exceed one of the following:?
 University graduation in computer science or a related discipline and 4-yr relevant experience;?OR?
 2-yr diploma in computer science or a related discipline and 6-yr relevant experience;?OR?
 1-yr certificate in computer science or a related discipline and 7-yr relevant experience;?OR?
 a currently active professional certification or accreditation and 8-yr relevant experience


MUST HAVE:
- Experience in designing, building, testing, deploying, and supporting applications in an enterprise IT environment equivalent in size and complexity to the Government of Alberta.
- Experience using Microsoft SQL.
- Experience with Python development
- Experience with software development processes, and all associated best practices, methods, standards, tools, and policies.
- Experience working with various software development methodologies (i.e. agile, waterfall, scrum, Kanban, etc.).
- Experience working in a data warehouse / datalake / business intelligence or relevant data environment in a development role
- Knowledge of ETL processes and tools, with hands-on experience designing and implementing data pipelines for transforming and loading data from multiple sources into data warehouses.

NICE TO HAVE:
- Experience assisting in overall project planning and providing advice on system development opportunities.
- Experience making decisions and recommendations on highly technical or complex issues without formal guidelines or precedents and exercises resourcefulness and ingenuity
- Experience translating data from multiple sources to a single solution, including planning for historical, current, and future data needs
- Experience with cloud computing or big data platforms and infrastructure
- Experience working in the public sector


Please note that this is the most up to date version of job description available at this time - During Client Interview you will receive additional information - variance may apply!

When you have some time please register in our database (5 minutes process) to be considered for future openings; the link is available on our website at http://www.teamrecruiter.com in the Candidate section. Please follow us on LinkedIn at https://www.linkedin.com/company/teamrecruiter.com/, or on Twitter at https://twitter.com/TeamRecruiter.

We thank all applicants for their interest. Only those who meet the qualifications will be contacted through telephone/email. You are encouraged to register with us in our database to be considered for future positions available.

Have a great day.

......At Teamrecruiter.com we offer some of the most highly qualified professionals in the workforce. We dedicate an industry trained recruitment specialist to the following areas: IT, Finance, Admin, Sales, Executive Search and Contractors. If you would like to learn more about our full-service recruiting firm please visit our website at www.teamrecruiter.com.

CAMSC and ACSESS certified

"...All Offers are conditional on Client Post-Offer Conditions being met and removed by end client prior to written offer signing"

"Please note that emails from our Recruitment Firm may inadvertently be sent to your Spam Folder. When contacted regarding an employment opportunity, please keep an eye on your Spam/Junk Folder to avoid missing important communication."

THE EMPLOYER OF RECORD FOR THIS ROLE WILL BE TEAM RECRUITER / SE.



Accommodations are available upon request for all individuals with disabilities taking part in the recruitment and selection process.