Developer II (ETL & SSIS & SQL)

First Solar reserves the right to offer you a role most applicable to your experience and skillset.

Basic Job Functions:

Enhance First Solar's data management, business intelligence and analytical capabilities using its packaged solution standards of Azure and Oracle, along with Microsoft SQL Server technologies.

Experience:

• Minimum 4 years of work experience
• Data warehouse or business intelligence certifications a plus
  
  
  
  • Microsoft certifications a plus
  
  

Education:

• Bachelor's degree in Information Technology or related field or equivalent years of work experienc

Required Skills:

• 3+ years of experience designing and developing Extract, Transform and Load (ETL) routines, writing schemas, maps, packages, etc. at a medium to large scale company.
• 2+ years of experience with Microsoft SQL Server Integration Services or an enterprise ETL tool, such as Azure Data Factory, SSIS or other related Microsoft data loading tools.
• 2+ years of experience in a multi-tiered architecture with languages such as SQL, C#, HTML, XML, etc.
• Familiar with Service Oriented Architecture (SOA) concepts such as web services.
• Familiar with data warehouse concepts and models using traditional star schema modeling techniques.
• Demonstrated understanding of fundamental technologies in a Microsoft environment: operating systems, networking, middleware, security, databases, etc.
• Desired technical skills:
  
  
  
  • Experience with Microsoft SQL Server
  • Experience with various Microsoft ETL tools
  • Exerprience with Microsoft Azure
    
    
    
    • Data Factory
    • Functions
    • Logic Apps
    • Data Warehouse and SQL Server
    • Blob and Data Lake storage
    • Dev Ops
    • Databricks is a plus
    
    
  • Experience with Microsoft SQL Server Analysis Services (SSAS) or Reporting Services (SSRS) is a plus.
  
  

Essential Functions & Responsibilities:

Primary Responsibilities:

• Designs, develops and implements ETL solutions across the First Solar technology landscape through projects and change requests.
• Monitors and manages ETL environments and resolves issues.
• Takes proactive steps to improve ETL solutions that positively impact performance, scalability and user experience.
• Interfaces with other IT associates and end users to understand business requirements from a technical perspective.
• Thoroughly documents ETL solutions and adheres to First Solar's development standards.
• Provides knowledge and suggestions on the integration of data within First Solar's enterprise data warehouse.
• Works with other developers in the management and maintenance of First Solar's enterprise data warehouse (content, performance, integration, etc.)
• Works with Architects in the design and application of ETL solutions in support of Critical Design Reviews and New Technology Review processes.
• In coordination with Architects, applies patches, notes, upgrades, etc. to First Solar's ETL infrastructure

Key Competencies:

• Undertakes analytical activities and delivers analysis outputs, in accordance with customer needs and conforming to agreed standards.
• Provides expertise and support on use of methods and tools.
• Applies data analysis and data modeling techniques to establish, modify or maintain a data structure and its associated components (entity descriptions, relationship descriptions, attribute definitions).
• Undertakes complete design of simple applications using simple templates and tools. Assists as part of a team on design of components of larger systems. Produces detailed designs including for example: physical data flows, file layouts, common routines and utilities, program specifications or prototypes, and backup, recovery and restart procedures.
• Translates and implements simple development project requirements into physical database structures. Assesses proposed changes to object and data structures and implements these changes in physical databases. Assists in database management system support activities for operational database systems.
• Designs, codes, tests, correct, and documents simple programs, and assist in the implementation of software which forms part of a properly engineered information or communications system.
• Applies tools and methods to identify the user experience, user's characteristics and tasks, and the technical, organizational and physical environment in which the product or system will operate.
• Uses the tools and techniques for specific areas of release and deployment activities. Administers the recording of activities, logging of results and documents technical activity undertaken. May carry out early life support activities such as providing support advice to initial users.
• Assists in the investigation and resolution of issues relating to applications. Assists with specified maintenance procedures.
• Investigates problems in systems and services. Assists with the implementation of agreed remedies and preventative measures.
• Uses appropriate methods and tools in the development, maintenance, control and distribution of quality and environmental standards. Makes technical changes to quality and environmental standards according to documented procedures. Distributes new and revised standards.

Please note: potential candidates will meet the education and experience requirements provided on the above job description and excel in completing the listed responsibilities for this role. All candidates receiving an offer of employment must successfully complete a background check, pre-employment drug screen, and any other test that may be required for the role.

Equal Opportunity Employer Statement: First Solar Inc. is an Equal Opportunity Employer (EOE) that values and respects the importance of a diverse and inclusive workforce. It is the policy of the company to recruit, hire, train and promote persons in all job titles without regard to race, color, religion, sex, age, national origin, veteran status, disability, sexual orientation, or gender identity. We recognize that diversity and inclusion is a driving force in the success of our company.