Data Specialist

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 executing on data pipeline, integration, and modeling processes based on the needs of each client project. Working closely with cross-functional teams to understand data requirements and implement data solutions.  

Responsibilities  

• Data Extraction and Analysis: Query large datasets from cloud based data warehouses (e.g. BigQuery) using SQL to extract relevant pipeline and operational data. Analyze structured and semi-structured data to uncover trends, anomalies and insights 

• Data Pipeline Development: execute 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 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. Validate outputs and collaborate with cross-functional teams to address data discrepancies.  

• Data Warehouse Management: Maintain data infrastructure, including data warehouses and data marts, ensuring data availability, reliability, and security. Execute scripts to convert OLTP data (online transaction processing) to OLAP data (online analytical processing).  

• Data Quality and Governance: Implement data quality checks and validation processes to ensure data accuracy and consistency. Spot data discrepancies and identify data gaps. Enforce data governance policies, standards, and best practices to maintain data integrity and compliance. Collaborate with Operations team to resolve data discrepancies or quality issues. 

• Problem Solving: Address data challenges. Interpret complex data and identify patterns. 

• Organization Skills: Manage data efficiently, organizing files and maintaining data integrity. Utilize GCP tools (e.g., BigQuery, Cloud Storage, Dataflow) for efficient data processing and storage. 

• Data Security and Privacy: Follow 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.  

• Collaboration with Stakeholders: working closely with Operation teams to understand analytical needs and deliver actionable insights.  

• Process Improvement and Automation: identify opportunities to automate repetitive data tasks using SQL scripts, scheduled queries or GCP workflows. 

• Documentation and Best Practices: maintain clear and thorough documentation of data sources, logic, workflows and assumptions.  

 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 results.   

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.  

• Technical Skills: Advanced SQL and basic Python are required. Experience in cloud platforms such as AWS, Azure or Google is desired. Experience in Power BI is required.  

• Experience: 3+ years of relevant work experience, experience in data engineering is preferred.  

• Familiar with data management design, delivery, techniques, and systems development methodologies   

• Data Modeling and Database Management: Basic understanding of data modeling concepts, relational databases (e.g., PostgreSQL, MySQL), and data warehousing principles.  

• Experience in Azure cloud technologies such as Data Factory, Data Bricks, Data Explorer, Data Share, Data Catalogue, Azure Data Lake Storage and other Azure storage mediums (file, blob, etc.), Azure SQL Database   

• Data Governance: Understanding of data governance principles, data quality frameworks, and data security best practices.  

• Communication: Good communication skills and can gather input from various stakeholders.  

• Collaboration: Proven to work effectively with others to achieve positive results  

• Ability to travel across the US and Canada, if required.   

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 role pays $83,000-109,000 per year.