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 da