The ideal candidate will provide data support including programming and troubleshooting to support multiple operations and development projects. They will provide support across all aspects of the technology used to support data services. They will have a clear background in the support, manipulation, Extracting, Loading and Transforming (ELT) of business data into a Data warehouse, and the ability to build complex dashboards and visualization of the data for the executive team. In addition to using advanced SQL to mine and analyze data, the Data Analyst will also design, develop, and implement data flows and applications and work closely with Business and other analytical staff to define new project requirements. This includes working with users to identify and develop data requirements, data definitions and data standards.
The Data Analyst will be fluent in documenting, understanding and working with data from various systems, using SSIS for ETL, warehousing concepts, as well as using SSIS to import data into their data warehouse system. This entails using SSMS to access data, write stored procedures, and investigate data issues. Knowledge of Salesforce SOQL and SOSL will be a plus as Salesforce is a frequent source data system.
Responsibilities:
- Make data accessible and understandable to staff.
- Assess and interpret customer needs and requirements.
- Work closely with a small team to develop and unit test ETL processes to facilitate the movement of data throughout the organization.
- Apply mapping requirements to transform and load procedures in order to process inbound and outbound files.
- Conform to industry best practices for code construction, software security, data security, scalability, and performance.
- Provide verified, repeatable, accurate business answers from data sources.
Qualifications:
- Four-year degree - Computer Science preferred.
- 5+ years of experience with SQL databases, ETL, and writing complex SQL statements.
- 3+ Experience using SQL Server Management Studio and SQL Server Integration Services.
- Experience with development – including full life cycle activities.
- Experience with Agile methodology.
Requirements:
- 5+ years of experience
- Strong, analytical problem solver
- Experience with data analytics and business intelligence
- Experience with PowerBI
- Experienced with database migrations.
- Proven experience managing complex database environments.
- Experienced with SQL 2008 R2, 2012 and above, SSIS ETL, SSAS, SSRS
- Able to write fluent, complex T-SQL queries
- PowerShell, C# and/or .NET, and Salesforce experience is a big plus.
- SOQL/SOSL knowledge and Salesforce platform experience are a plus, not a requirement.
- Team player and able to work independently, while staying in communication in a fast-paced environment.
- Able to support for non-business hours and participate in on-call rotation.
Qualifications
Qualifications:
- Four-year degree - Computer Science preferred.
- 5+ years of experience with SQL databases, ETL, and writing complex SQL statements.
- 3+ Experience using SQL Server Management Studio and SQL Server Integration Services.
- Experience with development – including full life cycle activities.
- Experience with Agile methodology.
Requirements:
- 5+ years of experience
- Strong, analytical problem solver
- Experience with data analytics and business intelligence
- Experience with PowerBI
- Experienced with database migrations.
- Proven experience managing complex database environments.
- Experienced with SQL 2008 R2, 2012 and above, SSIS ETL, SSAS, SSRS
- Able to write fluent, complex T-SQL queries
- PowerShell, C# and/or .NET, and Salesforce experience is a big plus.
- SOQL/SOSL knowledge and Salesforce platform experience are a plus, not a requirement.
- Team player and able to work independently, while staying in communication in a fast-paced environment.
- Able to support for non-business hours and participate in on-call rotation.