Data Engineer 2
Join our dynamic team at our energy partner as a Data Engineer 2, where you will play a pivotal role in harnessing the power of data to optimize operations, enhance decision-making processes, and drive innovation in the rapidly evolving energy sector. As a seasoned professional, you will leverage your expertise to design, implement, and maintain robust data pipelines, ensuring the seamless flow of information critical to powering the future of sustainable energy solutions
Description
- This position is for an experienced report & data developer Working on the Nuclear Analytics Durable Team as an experienced SQL Developer.
- The position will report to the Nuclear Analytics & Reporting Manager and will receive primary task direction from the reporting lead of various projects.
- The person serving in this role will participate in the team standups, planning and reviews.
- As part of the Nuclear IT organization this position will be an integral part of a fast-paced, entrepreneurial, energetic, and high performing team environment at the heart of Nuclear’s digital transformation.
- They will be on the forefront of the expansion of Nuclear’s analytics capabilities.
- You will be changing data sources.
- The ideal candidate would have a strong background in SQL and SSIS development and upgrades.
- This position is expected to deliver solutions that adhere to enterprise and/or governance standards and meet, if not exceed, the information needs of all stakeholders in terms of information availability, security, and quality.
- Applicants should be self-motivated individuals with excellent communication skills who possess the desired qualifications in this requisition and who work well in a collaborative environment.
Responsibilities
- Comfortable assisting the upgrade and move of SQL Server Databases and SSIS packages to new servers.
- Demonstrates the ability to visualize long-term results and asset impacts on a system-wide basis.
- Partners with other developers, lead, architects, IT management, and clients to identify and recommend solutions.
- Develops and maintains awareness of emerging technological trends, best practices and the required technical and business knowledge needed to perform assigned duties.
- Anticipates internal and external influences that may impact system designs and raises concerns in a timely manner and participates in the development of action plans to address.
- Collaborates with the Infrastructure & Operations, Nuclear IMA, Data Architecture, and Analytics teams to ensure solutions meet standards for ETL and application design for the development of all solutions.
- Familiarize and practice established best practices for data management and data governance standards for both traditional relational database management models as well as non-traditional data architectures.
- Participates in appropriate peer groups to understand and implement given direction, understand product roadmaps, and ensure product delivery alignment where possible.
- Migrate applications to newer servers as part of sustainability initiatives.
- Create documentation for requirements, analysis, design, test plans, implementation plans, support documentation as required.
- Provides experience in SQL query writing and use of DBMS technology.
Basic/Required Qualifications
- In lieu of Bachelor’s degree(s) AND 3-5 year(s) related work experience listed above
- Top 3 required skills- SQL, SSIS, AWS
Desired Qualifications
- 3-5 years SQL experience
- 3-5 years experience with SSIS packages
- “Nice to have” - AWS Redshift experience
- Excellent customer service, requirements gathering, and data analysis skills
- Excellent analytical abilities and documentation skills
- Intermediate expertise in SQL, SSIS (multi-dimensional and tabular)
- Advanced expertise building ETLs to convert transactional data into dimensions and fact tables
- Experience managing end-to-end delivery of data warehousing solutions
- Excellent analytical, consulting, change management and communication skills across large audiences and management.
- Ability to work and communicate effectively with others at all levels of the organization.
- Experience working in an Agile development environment.
- Some experience with IT DevOps principles and tools
- Strong knowledge and experience with relational and dimensional modeling
- Cloud architecture experience with public cloud providers is considered a plus.
- Experience or general familiarity and understanding of the Elastic Search suite of products is considered a plus.
Job Types: Full-time, Contract
Pay: From $40.00 per hour
Expected hours: 40 per week
Benefits:
- 401(k)
- Dental insurance
- Health insurance
- Paid time off
- Vision insurance
Schedule:
- 8 hour shift
- Monday to Friday
Work Location: Remote