<p>Candidatul ideal</p>

<p>Minimum requirements:<br />
&bull; This position requires strong technical expertise and excellent communication skills at all levels;<br />
&bull; Proficiency with MS SQL programming with a minimum of 2 years of experience;<br />
&bull; Experience with Data Warehouse and ETL processes implementation<br />
&bull; Must be willing to learn data visualization and reporting tools (MS Excel Pivot Tables, MS Excel PowerPivot, Tableau, Power BI, SQL Server Reporting Services (SSRS) and other, as needed)<br />
Preference will be given to candidates who have demonstrable experience in the following areas:<br />
&bull; Quantifiable experience with MS SQL server programming<br />
&bull; Quantifiable experience with any scripting or programming in object-oriented language (e.g. PHP, C++<br />
&bull; Experience working with data analytics methods and techniques (e.g. R programming) and with data visualization tools (MS Excel, Tableau, Business Objects, etc.)<br />
&bull; Experience with Unix shell scripting.</p>

<p>Descrierea jobului</p>

<p>BASIC FUNCTION<br />
The SQL database / data warehouse developer is responsible for the development of SQL code and SQL Server integration services packages that automate data extraction from various sources, transformation and load into an Enterprise Data Warehouse. The data stored in the system will be used to produce various reports and dashboard.</p>

<p>PRINCIPAL FUNCTIONAL RESPONSIBILITIES<br />
&bull; The majority of time will be spent on lead reporting projects and initiatives:<br />
o Work with customers to understand reporting goals, objectives, scope and approach and document the information within scope and approach document<br />
o Present proposed solution to customers and management to solicit feedback<br />
o Identify data sources and automate data extraction and transformation using SQL Server Integration Services (SSIS), stored procedures and PowerShell scripts; investigate the use of other integration tools, as needed<br />
o Manage data quality by enabling uniqueness constraints and/or by producing reports that show invalid data elements and communicating results to data owners<br />
o Develop and publish reports and dashboards that address customer requirements requested reports and dashboards<br />
o Create customer documentation and provide training to customers<br />
&bull; Assist customers with ad-hoc data analytics requests<br />
&bull; Monitor and fix ETL job failures<br />
&bull; Evaluate new tools, technologies and processes in order to improve service management processes, enhance reporting capabilities, reduce cost and/or improve efficiency<br />
The ideal candidate will be able to:<br />
&bull; Work with service owners to identify reporting goals, objectives and requirements.<br />
&bull; Work with service design, engineering and operations groups to identify data sources and implement ETL procedures to load data into the Enterprise Data Warehouse.<br />
&bull; Analyze data collected from tools in order to:<br />
o Validate data accuracy and completeness,<br />
o Identify appropriate metrics that addresses reporting requirements,<br />
o Gain insight into data to identify trends and improvement opportunities in order to assist design, transition and operations team with improving service delivery and quality,<br />
o Develop reporting methodology and perform impact analysis prior to report roll-out.</p>

<p>Descrierea companiei</p>

<p>Emerson is a global leader in bringing technology and engineering together to provide innovative solutions for customers in industrial, commercial, and consumer markets around the world. Founded in 1890 in St. Louis, Missouri (USA), Emerson delivers solutions through five business segments: Process Management, Industrial Automation, Network Power, Climate Technologies, and Commercial &amp; Residential Solutions. With sales of $24.7B and more than 130,000 employees in over 150 countries, we have a customer-focused, results-driven culture where employee performance is recognized and rewarded.</p>

<p>Visit us at: www.emerson.com</p>
