Developer II (ETL & SSIS & SQL)

First Solar - Perrysburg, OH

Full-time

Perrysburg, OH

Utilities

About the position

First Solar is seeking a Developer II with expertise in ETL, SSIS, and SQL to enhance its data management, business intelligence, and analytical capabilities. The successful candidate will work with packaged solution standards of Azure and Oracle, alongside Microsoft SQL Server technologies. This role involves designing, developing, and implementing ETL solutions across the First Solar technology landscape, ensuring that the data infrastructure supports the company's operational and analytical needs. The Developer II will be responsible for monitoring and managing ETL environments, resolving issues, and proactively improving ETL solutions to enhance performance, scalability, and user experience. The position requires collaboration with other IT associates and end users to gather business requirements from a technical perspective. Thorough documentation of ETL solutions is essential, adhering to First Solar's development standards. The Developer II will also provide insights on data integration within the enterprise data warehouse and work closely with architects to design and apply ETL solutions. This role is critical in supporting Critical Design Reviews and New Technology Review processes, ensuring that the ETL infrastructure is up-to-date with patches, notes, and upgrades. Candidates should possess a strong understanding of data warehouse concepts and models, particularly traditional star schema modeling techniques. Familiarity with Service Oriented Architecture (SOA) concepts and fundamental technologies in a Microsoft environment is also required. The Developer II will undertake analytical activities, deliver analysis outputs, and apply data analysis and modeling techniques to maintain data structures. This role is integral to the success of First Solar's data initiatives, contributing to the overall efficiency and effectiveness of the company's data management strategies.

Responsibilities

• Design, develop and implement ETL solutions across the First Solar technology landscape through projects and change requests.
• Monitor and manage ETL environments and resolve issues.
• Take proactive steps to improve ETL solutions that positively impact performance, scalability and user experience.
• Interface with other IT associates and end users to understand business requirements from a technical perspective.
• Thoroughly document ETL solutions and adhere to First Solar's development standards.
• Provide knowledge and suggestions on the integration of data within First Solar's enterprise data warehouse.
• Work with other developers in the management and maintenance of First Solar's enterprise data warehouse (content, performance, integration, etc.).
• Collaborate with Architects in the design and application of ETL solutions in support of Critical Design Reviews and New Technology Review processes.
• Apply patches, notes, upgrades, etc. to First Solar's ETL infrastructure in coordination with Architects.

Requirements

• Minimum 4 years of work experience in a related field.
• Bachelor's degree in Information Technology or related field or equivalent years of work experience.
• 3+ years of experience designing and developing Extract, Transform and Load (ETL) routines 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.
• Familiarity with Service Oriented Architecture (SOA) concepts such as web services.
• Understanding of 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.

Nice-to-haves

• Data warehouse or business intelligence certifications.
• Microsoft certifications.
• Experience with Microsoft SQL Server.
• Experience with various Microsoft ETL tools.
• Experience with Microsoft Azure, Data Factory, Functions, Logic Apps, Data Warehouse and SQL Server, Blob and Data Lake storage, Dev Ops, Databricks.
• Experience with Microsoft SQL Server Analysis Services (SSAS) or Reporting Services (SSRS).