Data Engineer/specialist

Aurora, ON, CA, Canada

Job Description

JANA is focused on improving the integrity of gas pipeline systems through the application of advanced risk modeling technologies. Our models and software are defensible and highly predictive, allowing gas pipeline operators to take actions to reduce risk in their systems. And our Integrity Data suite enables pipeline operators to finally capture their pipeline asset data and unlock the value associated with this data.


As an entrepreneurial company, we provide an exciting, dynamic and respectful work environment where you will be an important contributor to the JANA Team. Our Mission at JANA is "Better Pipelines for a Better World" - we are true believers and inspire our employees to join us in this Mission! High-energy Collaborative Environment: JANA combines the energy of a start-up software organization with the discipline of a precision engineering firm. Social Events: Join the entire JANA Team for fun virtual Social Events like our Beer Club. We also like to get together for in-person events such as our Annual Birthday Bonspiel, Holiday events, our annual Company Picnic, and team events! Best-in-Class Benefits: JANA offers all employees a comprehensive benefits package including a Healthcare Spending Account, Medical, Dental, Life Insurance, AD&D, Drug coverage, Disability coverage, as well as a Wellness Benefit!! JANA also provides employees with the opportunity to get support with mental wellness through our Employee Assistance Program. Giving Back: JANA is dedicated to giving back to our community. We hold an annual food drive for the Aurora Foodbank and have become one of their top contributors! JANA promotes a healthy work-life balance: Through our comprehensive vacation program, floater days, and a hybrid work environment (up to 20% a month in office) JANA employees are able to take time to rest and rejuvenate! Employee Recognition: We aim to Win, and we love to celebrate Wins with our People. We also offer a Phantom Share Program and annual bonuses!

JANA's Data Specialist is responsible for defining and improving data pipeline, integration, and modeling processes based on the needs of each client project. Working closely with cross-functional teams to understand data requirements, implement data integration solutions, and ensure the availability and reliability of data for analysis and reporting purposes.



JANA's Delivery Data Specialist defines data models and schemas, ensures data quality, and provides data warehouse management support to execute JANA's implementation process.





Responsibilities


Data Pipeline Development: Build, and optimize data pipelines and ETL (Extract, Transform, Load) processes to efficiently move and transform data from various sources into structured formats for storage and analysis Data Integration: Collaborate with data stakeholders to understand their requirements and develop data integration solutions that enable seamless and accurate data flows across systems and databases. Data Modeling and Schema Design: Implement data models and schemas that align with business requirements, ensuring data consistency, integrity, and performance. Implement data partitioning and indexing strategies to optimize query performance. Data Warehouse Management: Maintain data warehouses and data marts, ensuring data availability, reliability, and security. Monitor and tune database performance to meet service level agreements (SLAs) and scalability needs. Data Quality and Governance: Implement data quality checks and validation processes to ensure data accuracy and consistency. Enforce data governance policies, standards, and best practices to maintain data integrity and compliance. Data Security and Privacy: Implement data security measures and protocols to protect sensitive data. Ensure compliance with relevant data protection regulations and industry standards. Infrastructure and Tooling: Implement appropriate data engineering tools, frameworks, and technologies to enhance data processing efficiency, scalability, and maintainability. Stay updated with industry trends and emerging technologies in the data engineering field.


Leadership


The JANA Way: Functions in alignment with JANA's Values and Professional Culture. Analytical Thinking: Summarizes information concisely and clearly identifies key elements, patterns, results, or relationships; utilizes data to draw conclusions and make fact-based decisions. Attention to Detail: Completes work with the utmost attention to detail, ensuring confidence in work product. Communication and Stakeholder Management: Effectively communicate complex findings and technical concepts to non-technical stakeholders, fostering a data-driven culture and promoting the value of data science within the organization. Problem Solving and Continuous Learning: With a skills-improvement mentality, able to analyze problems and formulate different points of attack to come up with viable solutions. Writing: Clearly communicates in a written format with logical and concise presentation of recommendations, conclusions and supporting facts. Collaboration: Works effectively with others to achieve positive result

Required Skills & Experience


Education: Bachelor's degree in computer science, Software Engineering, or a related field. Relevant certifications in data engineering or database management are a plus. Data Engineering Experience: 1 year experience in data engineering is preferre Technical Skills: Proficiency in programming languages such as Python, or Scala. Strong knowledge of SQL for data manipulation and query optimization. Experience with big data technologies and frameworks like Apache Hadoop, Spark, or Kafka. Familiarity with cloud platforms (e.g., AWS, Azure, GCP) and their data services is desirable. Data Modeling and Database Management: Solid understanding of data modeling concepts, relational databases (e.g., PostgreSQL, MySQL), and data warehousing principles. Experience with NoSQL databases (e.g., MongoDB, Cassandra) and columnar databases (e.g., Redshift, BigQuery) is advantageous. ETL and Data Integration: Hands-on experience with designing and implementing efficient ETL processes using tools like Apache Airflow, Apache NiFi, or Informatica. Familiarity with data integration patterns and technologies (e.g., APIs, message queues) is beneficial. Data Governance: Understanding of data governance principles. , data quality frameworks, and data security best practices. Familiarity with privacy regulations (e.g., GDPR, CCPA) and experience in implementing data anonymization techniques is desirable.

JANA is committed to accommodating applicants with disabilities throughout the hiring process; in accordance with the Accessibility for Ontarians with Disabilities Act (AODA). Please let us know if you require accommodation at any stage of the hiring process. By applying for a position with JANA, you understand that we use third party systems and recruiting agencies that may employ the use of Artificial Intelligence within their programs for finding, screening, assessing, and/or selecting candidates. You also understand that offers of employment are contingent upon the successful completion of a background check. The type of check performed is determined by the role and JANA's employment policies. Checks may include any of the following: employment verification, employment references, SIN validation, education verification, criminal records check, search against global sanctions and government watch lists, and/or credit check. You will be notified during the hiring process which checks you are required to complete. We thank you for your interest. Only candidates selected for an interview will be contacted. This posting is for an existing opening.

Beware of fraud agents! do not pay money to get a job

MNCJobz.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Job Detail

  • Job Id
    JD2413506
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Contract
  • Salary:
    Not mentioned
  • Employment Status
    Permanent
  • Job Location
    Aurora, ON, CA, Canada
  • Education
    Not mentioned