Job Description

The Opportunity:Company, Department: Nova Scotia Power, ITLocation: Halifax, NSClosing Date: November 24th, 2024Nova Scotia Power\xe2\x80\x99s greatest source of energy is our people. In a culture focused on safety, we\xe2\x80\x99re committed to providing exceptional service to our customers and rewarding jobs to our employees. We\xe2\x80\x99re hiring solution-minded people excited to help us grow into the future. We are currently looking to fill the position of Sr Data Specialist.As a member of NSP\xe2\x80\x99s Business Intelligence and Analytics (BIA) team, the Sr Data Specialist is responsible, working under the technical guidance of the Data Architect, for the design, development and testing of workflows, business rules, scripts and custom coding for data movement into target analytic data structures both in batch and in real time, on premise as well as azure cloud, as dictated by requirements. The individual in this position has a high degree of competency in ETL development using Microsoft SSIS, Azure data factory, Azure Databricks and/or any hands-on experience with Oracle\xe2\x80\x99s Fusion tool suite with specific experience with Oracle Data Integrator (ODI) is an advantage. Key elements of this role include::

• Data Engineering & ETL Development: Design, develop, and test ETL workflows, business rules, custom code, and scripts to cleanse, transform, and integrate data from structured and unstructured source systems into analytical data structures.
• Real-Time Data Processing: Lead the development of real-time or near-real-time data processing solutions using tools like Oracle Fusion Middleware or Azure Event Hub to meet low-latency data requirements.
• Design & Testing: Create and document detailed design specifications. Conduct unit, system, integration, and other forms of testing on ETL processes to ensure quality and functionality.
• Data Quality & Analysis: Collaborate with data analysts to profile and assess data quality in both source systems and analytical data structures.
• Data Lakehouse Administration: Assist with setting up and managing the ETL execution schedule, monitor ETL process performance, troubleshoot issues, and optimize ETL processes.
• Performance Monitoring: Work with DBAs and the Data Architect to monitor and optimize the capacity and performance of analytical data structures.
• Mentorship & Code Review: Perform code reviews and test results for work done by consultants and junior team members.

These skills will make you successful::Experience:

• Educational Background: Bachelor\xe2\x80\x99s degree in Computer Science, Information Systems, Data Management, or a related field; or equivalent experience.

• Professional Experience: At least 3 years of recent hands-on experience with ETL/data integration in a business intelligence context, including significant work with SSIS, ADF, and ODI (including configuration, tuning, and security management).
• Database Management: Demonstrated experience with database management systems and development tools.
• Cloud Data Integration: Proven experience with data movement and ingestion into cloud data lakes.
• Organizational Experience: Experience working in large private or public-sector organizations is preferred.

Skills and Capabilities:

• ETL/ELT Architecture: In-depth knowledge of ETL/ELT architecture, application development, and data cleansing using SSIS, ADF, ADB or ODI.
• SQL Proficiency: Strong skills in SQL programming (both procedural and non-procedural) on Oracle or SQL Server platforms.
• ETL Process Management: Expertise in deploying, scheduling, and managing ETL processes.
• Cloud Technologies: Experience with Microsoft Azure technologies, such as Azure Data Factory and Azure Event Hub.
• Testing Approaches: Extensive knowledge of ETL application testing approaches and techniques.
• Data Modeling: Deep understanding of normalized and dimensional data modeling techniques and analytical data structure standards.
• Programming Languages: Knowledge of application programming languages such as Java or Python is a plus.
• ESB/EAI Tools: Familiarity with ESB and/or EAI tools and development methodologies.
• Adaptability & Communication: Ability to work effectively in a dynamic environment with shifting priorities and communicate technical concepts clearly, both verbally and in writing.
• Data Governance: Ability to support organizational data governance initiatives, including metadata management, data profiling, and quality assessment.
• BI Methodologies: Understanding of BI delivery methodologies, familiarity with agile development practices, and knowledge of ITIL/Operational Support is a plus.

Learn more about our culture and values:At the Emera Group of Companies, you\xe2\x80\x99ll be part of an inclusive, respectful workplace where everyone is welcomed and supported. Come build a career as unique as you are: making an impact from Atlantic Canada to the world. Your experience and perspective will help us to safely deliver cleaner, more reliable energy to our customers.If working in an innovative environment, challenging yourself, and shaping a cleaner energy future inspires you, we want to hear from you. Apply by November 24th, 2024, and let us know why this role is right for you. The perks of joining our team? We offer::

• Flexibility: Hybrid work model
• Health & Wellbeing: A comprehensive benefits plan, 24/7 access to virtual health care services for you and your family through Dialogue, access to a free on-site fitness centre, Employee and Family Assistance Program, parental leave top-up plan and wellness benefits.
• Grow Your Career: Opportunities to advance within and between our affiliate companies, a focus on employee development and available sponsored education programs.
• Community Engagement & Care: Corporate investments in the places where our people live and work, mentoring opportunities, fundraising-matching, volunteer programs, various committees and employee resource groups, and scholarships for children of employees.
• Competitive Compensation: Short-term incentive plans and a Defined Contribution Pension Plan.

Diversity, Equity & Inclusion at Emera:As one of Atlantic Canada\xe2\x80\x99s largest publicly traded companies, we are ranked one of , and . We know our success is driven by our dedicated teams and we strongly encourage applications from all qualified candidates, including persons who identify as racially visible, Indigenous, persons with disabilities, women in underrepresented roles and members of the 2SLGBTQ+ community.
Applicants from these equity groups may self-identify through the online application process. We support candidates and employees with access and accommodation needs and encourage you to let us know when you require accommodation. Recruitment & Promotion Policy:The success of the Emera Company is driven by its people: a strong team with a shared commitment to support the . The purpose of our recruitment policy is to provide a consistent framework to support fair and equitable attraction, hiring, and retention of the best talent for vacant positions. We are dedicated to maintaining a fair hiring process that provides equitable opportunities to all our applicants and is guided by our company values.

Nova Scotia Power