Insight Investments Corporate Office - Costa Mesa, CA

Sr. SQL Developer

Job Locations US-CA-Costa Mesa
Job ID
2021-1558
Type
Regular Full-Time
Division
Insight Investments

Responsibilities

Insight Investments has an immediate opening for a Senior SQL Developer.  This is a full-time, direct-hire, permanent position.

 

This position will be primarily focused on backend Data Architecture, Database & BI Reporting Development.  The position will be responsible for the design, development, and implementation of multi-functional, multi-platform application systems with a focus on delivering efficient, reliable, scalable, and high performing solutions.  The position will partner with various IT and Business Teams both within the Company and externally to identify and deliver data driven solutions.

 

  • Hands-on development leader focused on data and process automation including Data Warehousing & Business Intelligence.
  • Architects, builds, and provides technical supports for Enterprise-Wide Data Warehouses, Data Lakes, and Operational Databases.
  • Creates stored procedures, SSIS packages, and other ETL processes to import/translate/manipulate/export data.
  • Works with multiple data sources to create a unified solution that implements business rules and supports their analytical needs.
  • Focuses on reuse, scalability, resilience, and a balance of performance vs cost benefit for solutions delivered.
  • Analyzes potential data quality issues and creates effective mitigation solutions.
  • Optimizes processes involving large data sets to improve performance.
  • Quickly understand business needs and translate these needs into technical solutions.
  • Recognizes and implements automation opportunities.
  • Proactively solicits, analyzes, and negotiates customer requirements and works with Business Areas, BAs, PMs, and Management to architect, build, and deliver technology solutions.
  • Understands and keeps up to date on common network protocols, security standards, system admin and application development practices and trends.
  • Champions implementation of standard practices to increase design and implementation efficiency across Development Teams.
  • Educates team members and others on capabilities and constraints of technology platforms.
  • Must have strong communication skills and ability to interact with internal IT, third party vendors, and business partners.

Qualifications / Education

  • Bachelor’s or Advanced Degree in Computer Science, Management Information Systems, a related field, or equivalent experience required.

Skills

  • Hand-On experience with 5+ years’ experience in Database Architecture, Design, and Development with data structures and database solutions on Microsoft SQL Server, JSON, Open System RDBMSs like Snowflake and NOSQL data platforms.
  • Development Experience with Data migration and integration tools (SSIS, Python, or other ETL tools) is required.
  • Strong MS t-SQL skills are essential and required.
  • Hands On experience developing using other scripting languages such as PowerShell, Python, etc. is preferred
  • Hands-On experience using BI reporting Tools such as Microsoft Power BI, Tableau, SSRS, or others preferred.   
  • Development Experience with SQL Reporting Services is required. 
  • Experience using standard industry software & development tools including JIRA, Azure Dev Ops, Bit Bucket, TFS, AD, and others required.
  • Experience performing Data Administration using MS SQL Server (i.e., performance tuning, troubleshooting, security, maintenance, and data management is a plus.
  • Experience working on and developing in both On-Prem and Cloud Environments (Azure) is a plus
  • Experience automating, integrating, and scheduling data processes across applications with the intention of minimizing manual touch points is a plus.
  • Knowledge and Technical Experience supporting financial, marketing, and operational applications such as Microsoft Great Plains, Microsoft Dynamics 365 CRM, and Salesforce is a plus.

 

Insight Investments, LLC is an Equal Employment Opportunity/Affirmative Action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, national origin, gender, age, sexual orientation, gender identity, disability, status as a Veteran or other protected classification.

Division

Insight Investments

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Connect With Us!