**Basic Job Functions**:Helps the data and analytics team achieve its vision of enabling the access and analysis of any data, from anywhere, at any time. Responsible for the ongoing development, maintenance and transformation of the company's data integrations, systems and analyses working collaboratively in a team environment to create trusted data assets. General activities include integration/cleansing processes, developing/supporting data platforms, creating reports and visualizations, building analytical analyses and processes, and delivering/reviewing/presenting results or outcomes.**Experience and Education**:- Bachelor's degree in Computer Science, Data Science, Information Technology or related field with one year of related work experience OR- Associate's degree in in Computer Science, Data Science, Information Technology or related field with two years of related work experience OR- Four years of First Solar IT Experience.- Analytical, data science, integration, data warehouse or business intelligence certifications a plus**Required Skills/Competencies**:- Excellent communication and organization skills- Proven interpersonal skills- Strong self-direction, initiative, and ability to prioritize multiple tasks from various requestors- Proficient with medium complexity SQL queries and scripts to retrieve, join and manipulate data.- Proficient with business intelligence and visualization technology, including Power BI, Tableau, Qlik, Oracle BI etc.- Demonstrated skill in extract, transform, and load processes.- Experience working in big data ecosystems with structured and unstructured (XML, JSON, CSV, etc.) data. Examples include Azure Data Warehouse, Google BigQuery, Hadoop, Apache Spark etc.- Familiar with data catalog usage, maintenance and governance processes.- Other nice to have experience, but not required:- Modeling and dimensional analysis. Examples include Microsoft SQL Server Analysis Services, Oracle Data Warehouse, etc.- Statistical analysis and predicative analytics using scripting languages such as R, Python or Scala, or package software like SAS, SPSS or Statistica.- Basic knowledge on.NET, C#, C++ or similar- Familiar with fundamental technologies in a Microsoft environment: operating systems, networking, middleware, security, databases, etc. Demonstrated history of maintaining up-to-date technology skills in both upcoming and current, production-orientated technologies.**Essential Responsibilities**:- Interfaces with other IT associates and end users to understand business requirements from a technical perspective. Develops experience in multiple business domains (Manufacturing, Quality, Sales, Services, Finance, Supply Chain, etc.)- Executes ETL / ELT integration processes: extracting, manipulating, loading, aggregating and transforming data to create and publish data services to a data catalog.- Gathering and analyzing extensive amounts of data from various sources.- Creating visually appealing and informative reports and dashboards using PowerBI.- Identifying trends and patterns within the data to derive meaningful insights.- Collaborating with business stakeholders to understand their requirements and objectives.- Troubleshooting and resolving any technical or data-related issues.- Ensuring the accuracy and integrity of the data being analyzed.- Maintains a data catalog with additions, changes and deletions to ensure most up-to-date information is available to other technical resources and end users on the availability, descriptions and intent of data and analytical assets.- Conducts data lifecycle activities of simple complexity: problem identification, hypothesis definition, data integration, data profiling, prototyping and experimentation, data schema design, development, testing and deployment across First Solar technology landscape through projects and change requests.- According to instructions builds and maintains the organization, structure and use of First Solar's data assets (e.g., data warehouse, Hadoop data lake, operational data stores, etc.)- According to instructions evaluates the accuracy of data from multiple internal and external sources, identifies relationships, performs quality audits, identifies data gaps / anomalies, conducts root cause analysis with recommend solutions, and tracks error resolution through completion.- Performs simple data mining, statistical analyses and advanced analytical processes against large data sources working with on-premise and cloud-hosted platforms.- Monitors First Solar's data environments and resolves issues. According to instructions takes steps to improve solutions that positively impact performance, scalability and user experience.- Creates technical documentation and conducts development to support routine, recurring and ad-hoc requests adhering to First Solar's technical standards.- Performs other assignments as requiredTravel:- 0-5%, as needed
