Job Title 

Senior Data Engineer

Location

Remote or Hybrid (Manchester, NH)

Summary

As a key member of our team at RiverStone, you will be integral in leading the building and maintaining of data integration and warehouse solutions.  These solutions are an integral part of key business functions like Actuarial, Finance, Acquisitions, Claims, Reinsurance and other key areas.  As we modernize our current Data Architecture, we will leverage a more diverse technology stack such as Azure , Spark, HaDoop and beyond.  Developing and scaling these big data technologies will be a core part of our daily job.

The ideal candidate for this position will be able think outside of the box and should have passion for building analytical solutions to enable business in making time sensitive and critical decisions.

Essential Functions

• Partners with Business Stakeholders to understand business processes to inform data integration and architecture solutions for Business
• Leads and contributes to Data Integration Projects via the design, development and optimization of data integrations between key business system data sources, Master References data sources, ODS and Data Warehouse.
• Provides oversight in the identification of key development tasks for the completion of data integration projects
• Align data integrations with Data Governance Master reference data to meet Data Governance objectives and data quality standards.
• Analyze data to assist in the development of data integration pipelines, to provide clarification of business requirements and to understand business processes.
• Leads team strategy for CI/CD pipeline process for new data integration and assists in the maintenance CI/CD pipeline for existing data integrations.
• Mentors associate Data Engineer team member in adoption of new technologies and strategies for data integration
• Leads building and designing Data Lake Architecture implementation leveraging Azure Cloud technologies including data integrations into the Data Lake.
• Architects data models (dimensional or transactional), database objects, stored procedures and views in support of data integrations.
• Facilitates key business and technical stakeholder discussions to formulate business requirements for new or enhanced data integrations.
• Understands, maintains and documents key existing data integrations and dependencies between integration to maintain and upgrade the data integrations
• Deploy, visualize and communicate data analysis with PowerBI reports.
• Evangelizes Data Driven Culture

Related Functions:

• Establishes and maintains effective working relationships with key business and technical stakeholders
• Communicates the progress against department goals/objectives and priorities on a regular basis

Required Skills

• Experience implementing Modern Data Processing Architectures leveraging Microsoft Technologies
• Experience in designing and developing ETL data pipelines leveraging SQL Server Integration Services, Microsoft Azure Data Factory or similar integration technology
• Experience developing data integration pipelines leveraging restful API services and queuing technologies a huge plus
• Proficient in writing Advanced SQLs with expertise in performance tuning of SQL Queries
• Experience in designing and building dimensional data models using a Data Warehouse Development Methodology framework such as Kimball or Inman
• Database development experience with Relational or MPP/distributed systems such as SQL Server/Oracle/Spark/Hadoop preferred and Big Data architectures
• Experience with Embarcadero Data Modeling tools and IBM CloudPack Data Governance tools.
• Programming experience C#, Java, Python, R or Scala preferred
• Experience developing restful API’s for data services is a huge plus
• Report Development Experience with PowerBI a plus
• Experience with Azure Cloud Technology stack as applicable to Data Integration and Data Warehousing along with Spark development is preferred
• Strong understanding of development processes and agile methodologies
• Experience with or advance courses on data science and machine learning is a plus
• Strong analytical and communication skills
• Self-driven, highly motivated and ability to learn quick

Organizational

• Develops creative ideas and solutions to real time business problems and/or business opportunities; takes reasonable, calculated risks even if failure is possible.
• Empowers self and teammates to continuously improve RiverStone’s business processes/ systems and develops and escalates ideas and solutions.
• Consistently delivers superior customer service to both internal and external business partners.
• Demonstrates alignment with RiverStone’s Commitments.
• Prioritizes and organizes work in self-directed manner.
• Attains and maintains knowledge of assigned department.
• Performs other duties as required, including supporting and coordinating with other department colleagues.

Experience

• 7+ years’ industry experience is preferred

Required Education

BA/BS in computer science or related field, or equivalent work history

Preferred Education or Certification

Azure Data Engineer Certification

Supervisory Role 

None

Travel

Minimal, less than 10% 

Work Environment / Physical Demands

This position operates in a professional based collaborative environment and must have the ability to timely produce thorough, accurate work with many competing demands, deadlines, and distractions. The position uses standard equipment such as phones, computers, copiers/printers and filing cabinets. Noise level is moderate.

Other Duties (Disclaimer Statement)

RiverStone retains the right to change or assign other duties to this position as needed, OR Other duties or responsibilities may change or be assigned as needed.

Core Competencies

Learning on the Fly: Learns quickly when facing new problems; a relentless and versatile learner; open to change; analyzes both successes and failures for clues to improvement; experiments and will try anything to find solutions; enjoys the challenge of unfamiliar tasks; quickly grasps the essence and the underlying structure of anything.

Problem Solving: Uses rigorous logic and methods to solve difficult problems with effective solutions; probes all fruitful sources for answers; can see hidden problems; is excellent at honest analysis; looks beyond the obvious and doesn’t stop at the first answers.

Process Management: Good at figuring out the processes necessary to get things done; knows how to organize people and activities; understands how to separate and combine tasks into efficient flow; knows what to measure and how to measure it; can see opportunities for synergy and integration where others can’t; can simplify complex processes; gets more out of fewer resources.

Sizing Up People: Is a good judge of talent; after reasonable exposure, can articulate the strengths and limitations of people inside or outside the organization; can accurately project what people are likely to do across a variety of situations.

Ethics and Values: Adheres to an appropriate (for the setting) and effective set of core values and beliefs during both good and bad times; acts in line with those values; rewards the right values and disapproves of others; practices what he/she preaches.

Technical Learning: Picks up on technical things quickly; can learn new skills and knowledge; is good at learning new industry, company, product, or technical knowledge – like internet technology; does well in technical courses and seminars.

Managing Vision and Purpose: Communicates a compelling and inspired vision or sense of core purpose; talks beyond today; talks about possibilities; is optimistic; creates mileposts and symbols to rally support behind the vision; makes the vision sharable by everyone; can inspire and motivate entire units or organizations.

Creativity: Comes up with a lot of new and unique ideas; easily makes connections among previously unrelated notions; tends to be seen as original and value-added in brainstorming settings.

Managing and Measuring Work: Clearly assigns responsibility for tasks and decisions; sets clear objectives and measures; monitors process, progress, and results; designs feedback loops into work.

Diversity, Equity, Inclusion & Belonging

RiverStone Resources, LLC is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, LGBTQ+, national origin, gender identity, disability, protected veteran status, or any other characteristic protected by law.

Privacy Notice for California Residents

https://www.trg.com/california-consumer-privacy-notice/