We are a Platform as a Service (Paas) provider, with each instanced powered by a unique and powerful data warehouse. The Data Warehouse Analyst/Developer will be responsible for supporting existing
clients, and the migration of new clients, with analysis and development of their data.
This role follows a complete E.T.L lifecycle, including data profiling, design and development of supporting tables, data mapping between competitors’’ systems and the data warehouse, database support and E.T.L enhancements.
You will work closely with the Data Solutions Architect, Business Analyst and the Project Manager, and each client. We are looking for someone who is data‐driven, a great communicator, creative, and can dive in and quickly come up to speed. Each new client provides you an opportunity to tackle new problems as we work to take their existing data architecture and convert it to the architecture enforced by the data warehouse.
Bachelor degree or a minimum of 4 years professional experience
Demonstrate a strong understanding of SQL and SQL Server Development (stored procedures, functions, views, triggers, SQL coding standards, indexing)
Experience working in SQL Server Management Studio
Experience working with other databases (MySQL, Oracle, etc.)
Data warehouse experience
Experience working with a Business Intelligence (BI) environment
Experience optimizing queries, views, stored procedures, and tables
Experience creating SQL Server Jobs
Experience importing data from multiple formats (backups, flat files, Excel)
English must be EXCELLENT.
Excellent written and verbal communication skills
Analytical and problem solving skills
Ability to complete tasks with minimal direction, or minimal business requirements
Ability to multitask and self‐prioritize, and to meet deadlines
Proven ability to work as a productive team member, as well as solo