Etl architect job description

The Data ETL Specialist defines the client's data migration requirements, analyzes the tech stack required for client's end-to-end (E2E) data migration, and builds custom ETL scripts/tools and data validation reports to ingest client data into the digital environment. This position requires 1: an expert understanding of ETL processes, APIs, and automation scripting to streamline the receiving, transforming, and loading of the delivered data; 2: an understanding of data schemas and bulk data-loading tools and techniques ; 3: ability to obtain a Secret clearance; 4: ability to acquire and maintain an IAT II certification such as Security+. The ETL specialist will be a part of a broader solution team which spans expertise across a larger digital ecosystem, and communication across domains will be required for understanding data model changes/updates, cyber security constraints, infrastructure requirements, and access controls that will impact data migration activities. Understanding of Agile software development is preferred. The ideal candidate is located near Dayton OH to support future classified activities, configuration and data load work on client site. Full telework will be considered. Experience with Siemens Teamcenter as well as CAD and CAD integration software (installation, configuration, mapping, etc.) are desired.

What You'll Do

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this position.

• Elicit requirements from clients
• Support bulk migration of data into through automation scripts and utilization of APIs
• Create reports to assist clients in data analysis decisions
• Create technical documentation for data migration processes and utilities
• Create test cases to support the generation of automation scripts
• Test executed solutions and troubleshoot anomalies to resolution
• Coordinate issue resolution with Technical Support and similar infrastructure / software support activities
• Analyze migration performance and optimize solutions
• Coordinate with Scrum Master, Product Owners, Information System Security Engineering (ISSE), Engineering Subject Matter Experts and Infrastructure/Network administrators on broader team to accomplish objectives
• Other Duties as assigned

Your Qualifications

• US Citizen
• Ability to obtain Secret clearance
• IAT II certification such as Security +
• 4+ years of writing automation scripts using Python or PowerShell
• Experience reading and understand API documentation
• Experience creating documentation around tools and processes
• Strong spoken and written English skills
• Experience delivering presentations to clients
• Adequate home working environment to include dedicated office-space to enable productive remote work

Equal Opportunity Employer including Disability and Veterans

Employees must abide by Sabel System's government contracts and any federal, state, and local laws regarding COVID-19 vaccination and related requirements.

Check out this video and find out why our team loves to work here!

The Domain Architect has technical expertise within his/her domain focus area. A domain area could be a technology area (for example, network, middleware and desktop), or may encompass business functionality supported by technology (for example: Maximo architect, Digital Architect, Metering Architect, Billing Systems Architect).

The Domain Architect has an understanding of the capabilities of a business application family and/or set of technologies within the domain and ensures that these capabilities are fully utilized and effectively optimized to make leveraging them efficient. He/she evaluates the technologies against vendor product roadmaps, competitive products, and market trends to ensure that the domain meets current and future Eversource needs.

The Domain Architect is responsible for contributing to the domain roadmap, standards and practices into the overall Enterprise Architecture as well as supporting solution development efforts guided by Solutions Architects that involve their assigned domain. Efficient governance over the domain is necessary to ensure that the technologies are incorporated into solutions in compliant, standard, and supportable ways.

Essential Functions:
Responsible for successfully applying the technology in their domain to solve business problems in a supportable, cost effective, way.Understands how the domain supports Eversource needs and assesses current capabilities and future needs to identify necessary changes to the domain technologies or practices.Develops guidance for incorporating the technology within their domain into solutions, including defined standards, reference architectures, solution guidelines and metrics. Define patterns and building blocks that leverage domain technologies in an optimal way.Understands technology trends and the practical application of existing, new and emerging technologies to enable new and evolving business needs, including those of IT.Defines high-level migration plans to address the gaps between the current and future state, typically in sync with the IT budgeting or other capital planning processes.Analyzes the current technology environment to detect critical deficiencies and recommend solutions for improvement. In addition, analyze the technology industry and market trends to determine their potential impact on the enterprise as well as on the enterprise technology architecture.Mentors and collaborates with technical subject matter experts and EA to develop technology architecture that enables and drives new business capabilities and operating models.Facilitates the research, evaluation, and selection of hardware and software technology and product standards, as well as the design of standard configurations and technology platforms.
Identifies the organizational impact (for example, on skills, processes, structures and culture) and financial impact of changes to the technology architecture.Participates in Eversource Enterprise Architecture processes as the expert in their domain(s) and works with peers to align architects.Incorporates domain standards, practices, guidance and roadmaps into the Eversource Architects and communicate them via architecture documents, meetings or other channels. Periodically review and maintain the accuracy of the information.Develops standards, practices, roadmaps, for inclusion in the Eversource EA and for use in developing solutions leveraging the domain technology Provides technology consulting to solution architects and others who are using or modifying multiple domain technologies within a solution, insuring the technology operates coherently to meet overall needs.Effectively integrate knowledge from subject matter experts and peers from other technical areas Responsible for governance over solutions that leverage their domain technologies

Technical Knowledge/Skill/Education/Licenses/Certifications:
Technical Knowledge/Skill:
Exposure to multiple, diverse technical configurations, technologies and processing environments Deep knowledge of one technical domain, or experience working with multiple technical domains. Demonstrate an understanding of how the domains relate and can be assembled into comprehensive solutions that meet business and IT needs Knowledge of many, if not most, aspects of the technology domain architecture, including current technology and vendors, emerging capabilities, best practices and patterns, cost models, and management and operating model considerations Understanding and knowledge of system development life cycle methodologies Understanding and knowledge of IT service management (ITSM) Understanding and knowledge of IT standards and controls Ability to work effectively with business and technical roles Excellent interpersonal skills in areas such as teamwork, facilitation and negotiation Strong leadership skills Excellent analytical and technical skills; Excellent written and verbal communication skills Excellent planning and organizational skills, and the ability to manage smaller efforts Knowledge of financial models and budgeting Ability to balance the long-term (big picture) and short-term implications of individual decisions

Education:
Bachelor's degree or equivalent. Advanced degree preferred.

Experience:
3 to 5 years in an IT Architect or Lead Subject Matter Expert role Minimum of 4 years related experience working with technology or application solutions, including experience in architecture, design, implementation, support and management of the technologies appropriate for the specific positions.

Working Conditions:
Must be available to work emergency storm assignment as required.Must be available to travel between MA/CT/NH as necessary.Work is performed primarily in an office environment which requires standing, sitting, walking, climbing stairs, writing and typing. Work involves using a computer and telephone as well as personal communication.

Worker Type:
Regular
Number of Openings:
1
EEO Statement

Eversource Energy is an Equal Opportunity and Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to age, race, color, sex, sexual orientation, gender identity, national origin, religion, disability status, or protected veteran status.

VEVRRA Federal Contractor
Vaccination Information:

Eversource requires all new employees to be fully vaccinated for COVID-19 by their first day of employment. If you have any concerns regarding compliance with this requirement, you will need to discuss your concerns with Eversource's HR department after you have been made a conditional offer of employment. Eversource does not require applicants to discuss vaccination status prior to receipt of a conditional offer of employment and complies with all applicable laws.
Emergency Response:

Responding to emergency situations to meet customers' needs is part of every employee's role. If employed, you will be given an Emergency Restoration assignment. This means you may be called to assist during an emergency outside of your normal responsibilities, work hours and location.