SQL Developer from Collabera
San Diego, CA
About the Job
Day to day:
- Working with SQL Stack e.g. SQL Server 2016 or higher, SSAS, SSIS, SSRS, MDM, Power BI.
- Use of data model concepts, master data management, operational process, SDLC, project management, data profiling, data cleansing/de-duplication processes.
- Create and maintain DAX and MDX queries and perform performance tuning on SSAS.
- Troubleshooting/support - will have to dig in to the backend of databases and troubleshoot issue areas
- Implement data warehousing and associated architecture.
- Data migration with source database to target database mapping.
- Database design with multidimensional modeling.
- Working directly with the business clients.
- Extensive use of written and oral communication skills, particularly the ability to synthesize complex issues/scenarios into easy-to-understand concepts.
- Works closely with the business team, development team, analysis team, and the users to enhance quality and product delivered.
- Responsible for precisely communicating impact, status, priority, progress, and road blocks to management
- Provides guidance in terms of priority and ownership of issues and requests.
Requirements
- Education
- Requires a bachelor's degree, preferably in Computer Science, Information Systems, Business, Mathematics, or related field, or equivalent business experience as a SQL Developer.
- Experience
- 4+ years of direct experience as a SQL Developer.
- Experience in managing software requests, projects, and internal customers.
- Experience with every phase of the System Development Life Cycle.
- Experience with being the technical liaison between the business users and development.
- Experience with Azure DevOps is desired.
- 1 to 2 years of retail energy related experience is highly desired.
- Skills/Knowledge/Abilities
- Ability to convey technical information in a clear and concise manner to other less technically oriented customers.
- Ability to manage multiple duties at the same time.
- Advanced Proficiency in the Office suite and Office 365
- Demonstrated ability to work in ambiguous situations and across organizational boundaries.
- SQL Technologies
- SQL Server stack (Reporting Services, Integration Services, Analysis Services and Power BI).
- Advanced proficiency in SSAS cubes
- Relational Database Management Systems
- SQL Server 2016 or newer.
Salary range: 90-125K base
Salary
40 - 50 /hour