Programmeur Oracle/SQL

2 weeks ago

Vancouver, Canada ESSA Technologies Ltd Full time

Financial Automation Programmer Part time hourly contract ESSA Technologies Ltd. (ESSA) is an employee-owned Canadian environmental consulting company with offices in British Columbia and Ontario. We envision a world where creativity, a focus on learning, and systems thinking are the foundation of innovative solutions to environmental challenges. Our corporate mission is to "bring together people, science and analytical tools to sustain healthy ecosystems and human communities". We achieve this mission by helping clients deal with tough, emerging problems, applying a neutral, thorough evaluation of evidence, encouraging diverse participatory processes, and collaboratively guiding our clients to make informed decisions that are designed to learn over time. You are a resourceful, independent, and skilled Financial Automation Programmer with the passion and skill needed to automate and validate selected financial accounting data workflows. This role combines technical expertise in coding (software development) with a firm understanding of financial concepts and processes . Your prior experience will afford you a strong ability to understand service firm performance data while having the know-how to deliver automated scripts / code to manipulate these data into elegant summary tables (e.g., As a Financial Automation Programmer, you will be responsible for surveying our existing data and manual workflows for creating ESSA's internal key performance indicators and related performance metrics. Your primary objective will be to develop an automated workflow solution that streamlines the generation of key performance indicator (KPI) and diagnostic performance metrics based on our financial data. You will collaborate with selected accounting (finance) and professional consulting staff to understand requirements, propose, then design and code an automation solution to cut down person hours associated with manual generation of these report cards and related summaries. By October 15 2024 , you will develop metric data summaries, report cards, and related visualizations that replicate our standard multi-year and staff specific reporting templates (allowing for minor design improvements). The expected outcome is an improvement in ease, efficiency, and timeliness of performance-related reporting for the company. Additionally, you will also include quality assurance steps, and from November 2024 to December 2024 you will provide technical support for pilot testing, troubleshoot issues, and implement bug fixes. Prior to the end of the term of your contract you will also be called upon to document the operation of automation code , necessary input data configurations, assumptions, processes, and procedures. The data used to develop these metrics are from two sources: (i) a SQL server database underpinning our time tracking and accounting software suite, Unanet A/E (Clearview Software InFocus), and (ii) various purpose-built Excel workbooks. The successful person would support our head office accounting team on a part-time hourly contract basis expected to require service on and off over an approximately 6-month period. At least multiple years of demonstrable professional experience developing production-level coded workflows, preferably combined with either a Diploma and/or bootcamp course certification OR a Bachelor's degree in Computer Science, Data Science, Information Technology or related field. *Proven experience as a software developer, preferably with a focus on financial systems development. · Integrating disparate data formats including SQL and Excel data to generate targeted financial outputs. · Experience collaborating with finance, IT, and business consulting teams to gather, interpret and understand requirements and design appropriately tailored solutions. · A portfolio of previously completed data-driven financial automation projects. Experience in both accounting (principles, terminology) and computer science (coding). · Strong programming skills in a mix of R, Python, C#, SQL Server and Excel VBA/Interop. · Familiarity with database management systems (including SQL Server, MySQL) and data integration techniques (e.g., Experience with enterprise financial software and reporting platforms such as Unanet A/E (Clearview Software InFocus), SAP, Oracle. · Generating elegant data rollups and related visualizations. · Ability to work with large datasets, perform data cleaning and manipulation. · Strong English writing and communication and collaboration skills to work effectively with cross-functional teams. · Ability to work with little instruction/supervision and to work effectively and collaboratively in person and remotely. · Personable, with a flexible, calm demeanor, comfortable in small group settings. com by May 24 th 2024 with " Financial Automation Programmer " in the subject line. A reminder this is a part-time position, with periods of around 1-2 weeks where no activity may occur due to the availability of supporting supervisors. Delivery of the first working version of automation code is required by October 15 2024 . All applicants must be eligible to legally work in British Columbia at the time of applying through the full duration of the contract. The gross hourly pay rate for this position ranges from $46/hr to $57/hr depending on qualifications and experience, inclusive of 5% statutory holiday pay premium, 6% vacation pay premium and 2% sick leave premium. Depending on the experience of the selected candidate and the emergent scope of services co‑created with the selected Financial Automation Programmer , our Management Team has budgeted between 450 to 600 hours to complete this contract assignment.

  • Intermediate ETL Developer specializing in Microsoft SQL Server and Power BI to Design and deve[...]

    2 weeks ago

    Vancouver, Canada S I Systems Full time

    Intermediate ETL Developer specializing in Microsoft SQL Server and Power BI to Design and develop ETL processes to enable creation a comprehensive dashboard Our construction client is looking for an Intermediate ETL Developer specializing in Microsoft SQL Server and Power BI to Design and develop ETL processes to enable creation a comprehensive dashboard4...

  • Intermediate ETL Developer specializing in Microsoft SQL Server and Power BI to Design and deve[...]

    2 weeks ago

    Vancouver, Canada S I Systems Full time

    Intermediate ETL Developer specializing in Microsoft SQL Server and Power BI to Design and develop ETL processes to enable creation a comprehensive dashboard Our construction client is looking for an Intermediate ETL Developer specializing in Microsoft SQL Server and Power BI to Design and develop ETL processes to enable creation a comprehensive dashboard4...

  • Intermediate ETL Developer specializing in Microsoft SQL Server and Power BI to Design and deve[...]

    2 weeks ago

    Vancouver, Canada S I Systems Full time

    Intermediate ETL Developer specializing in Microsoft SQL Server and Power BI to Design and develop ETL processes to enable creation a comprehensive dashboard Our construction client is looking for an Intermediate ETL Developer specializing in Microsoft SQL Server and Power BI to Design and develop ETL processes to enable creation a comprehensive dashboard4...

  • Business System Analyst

    1 month ago

    Vancouver, Canada iPartner Staffing Full time

    **Business System Analyst** **Vancouver BC -Onsite** **Education**: Min. Bachelor's in Computer Science or Engineering, Information Systems, or related fields **Responsibilities** - Provide written business requirements documents (BRD) inclusive of business, functional, non-functional, and user requirements that are actionable by development teams - Uses...

  • Entry Level

    1 week ago

    Vancouver, BC, Canada Medrio Full time

    Medrio’s SaaS offering is a key component in the pipeline of getting lifesaving drugs to people who need them. We automate the clinical trial process and offer significant advantages over the competition, including 75% lower cost and quick, easy setup. The candidate will be very experienced and be able to demonstrate excellent skills in Oracle SQL and...

  • Database Administrator

    1 month ago

    Vancouver, Canada Colton’s Couture International Full time

    Education: College/CEGEP - Experience: 2 years to less than 3 years **Tasks**: - Collect and document user's requirements - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Develop and implement data administration policy, standards and models - Research and document data requirements,...

  • Senior Developer

    1 week ago

    Vancouver, BC, Canada S I Systems Full time

    Senior Batch Job & Workload Automation Developer to automate processes using an enterprise batch scheduling tool (Redwood Cronacle). Our Public Enterprise Client is looking for a Senior Batch Job & Workload Automation Developer to automate processes using an enterprise batch scheduling tool (Redwood Cronacle). Contract, 1 year to start with 2 terms of...

  • Senior Batch Job

    2 weeks ago

    Vancouver, Canada S I Systems Full time

    Senior Batch Job & Workload Automation Developer to automate processes using an enterprise batch scheduling tool (Redwood Cronacle).Our Public Enterprise Client is looking for a Senior Batch Job & Workload Automation Developer to automate processes using an enterprise batch scheduling tool (Redwood Cronacle).Contract, 1 year to start with 2 terms of...

  • Analyst, Database

    4 weeks ago

    Vancouver, Canada Ancile Canada Inc Full time

    Education: Bachelor's degree - Experience: 3 years to less than 5 years **Work setting**: - Consulting firm **Tasks**: - Design and develop database - Design, construct, modify, implement and test data models and database management systems - Operate database management systems to analyze data - Develop and implement data administration policy, standards...

  • Database Administrator, Oracle/Cloud

    1 week ago

    Vancouver, BC, Canada Coast Capital Savings Full time €10

    Location: Help Headquarters Job Type: Full Time Hybrid or Remote The Database Administrator (DBA) is responsible for the overall management and maintenance of information databases used to operate the infrastructure and technology platform. The DBA will collaborate with technical and business user groups to ensure that databases are...

  • Business Systems Analyst

    2 weeks ago

    Vancouver, Canada Randstad Canada Remote Work Freelance Full time

    Are you an experienced Business Systems Analyst in search of your next contract opportunity? Our high-profile client is seeking to hire a Business Systems Analyst to join their talented team on a 6 month contract with a strong probability of extension. Apply for this amazing opportunity if this sounds like a good fit for you!AdvantagesWhat’s in it for...

  • Business Analyst

    1 month ago

    Vancouver, Canada Ignite Technical Resources. Full time

    On behalf of our client in **Burnaby,** **Ignite Technical Resources** is looking for a ** Business Analyst - Business Intelligence** with our client for a **contract **opportunity. **Role Description**: This resource will support ongoing data analytics and data integration projects. These projects include the development of data models, KPI dashboards,...

  • Business Systems Analyst

    2 weeks ago

    Vancouver, British Columbia, Canada Randstad Canada Full time

    Are you an experienced Business Systems Analyst in search of your next contract opportunity? Our high-profile client is seeking to hire a Business Systems Analyst to join their talented team on a 6 month contract with a strong probability of extension. Apply for this amazing opportunity if this sounds like a good fit for youAdvantagesWhat's in it for youAs a...

  • Senior Batch Job

    1 week ago

    Vancouver, BC, Canada S I Systems Full time

    Senior Batch Job & Workload Automation Developer to automate processes using an enterprise batch scheduling tool (Redwood Cronacle). Our Public Enterprise Client is looking for a Senior Batch Job & Workload Automation Developer to automate processes using an enterprise batch scheduling tool (Redwood Cronacle). Contract, 1 year to start with 2 terms of...

  • Senior Software Engineer

    2 weeks ago

    Vancouver, Canada Medrio Full time

    Medrio’s SaaS offering is a key component in the pipeline of getting lifesaving drugs to people who need them. We automate the clinical trial process and offer significant advantages over the competition, including 75% lower cost and quick, easy setup. Founded in 2005, Medrio is privately owned and currently experiencing geometric growth in terms of...

  • Senior Software Engineer

    2 weeks ago

    Vancouver, Canada Medrio Full time

    Medrio’s SaaS offering is a key component in the pipeline of getting lifesaving drugs to people who need them. We automate the clinical trial process and offer significant advantages over the competition, including 75% lower cost and quick, easy setup. Founded in 2005, Medrio is privately owned and currently experiencing geometric growth in terms of...

  • Senior Software Engineer

    2 weeks ago

    Vancouver, Canada Medrio Full time

    Medrio’s SaaS offering is a key component in the pipeline of getting lifesaving drugs to people who need them. We automate the clinical trial process and offer significant advantages over the competition, including 75% lower cost and quick, easy setup. Founded in 2005, Medrio is privately owned and currently experiencing geometric growth in terms of...

  • Manager (.NET) - Remote

    4 weeks ago

    Vancouver, Canada Cognizant Technology Solutions Full time

    **About Cognizant’s Digital Engineering Practice**: At Cognizant Digital Engineering, a small cross functional team comprised of a Product Manager, an Architect, Full-Stack Developers, UI/UX designers and Big Data analysts builds higher quality software faster siloed individuals working independently. Small, nimble engineering teams generate collective...

  • Senior IT

    1 week ago

    Vancouver, BC, Canada Community Living British Columbia Full time

    Community Living British Columbia (CLBC) is a Crown corporation responsible for arranging supports and services for adults with developmental disabilities and their families. CLBC staff strive to advance the vision of Communities of belonging, lives with connection . As a Senior .Net Developer at CLBC, you will assist with the design and development of...

  • Data and Reporting Analyst

    4 weeks ago

    Vancouver, Canada Langara College Full time

    Interested in a career at Langara College?_ Our employees exemplify Langara's values of excellence, collegiality, innovation and integrity. If you think this position fits your qualifications, we encourage you to apply! Langara College is located in Vancouver, B.C.: applicants to postings must be located in BC or willing to move to BC to accept work with...