FOCUS · 16 hours ago
Database Developer II
Maximize your interview chances
InsuranceInsurTech
H1B Sponsor Likely
Insider Connection @FOCUS
Get 3x more responses when you reach out via email instead of LinkedIn.
Responsibilities
Writing database scripts and queries: A database developer is responsible for writing SQL scripts and queries to extract, manipulate, and manage data. They must ensure that the queries are optimized for performance and security.
Designing, reengineering, and troubleshooting advanced MS SQL SSIS packages.
Designing, reengineering, and troubleshooting advanced PowerBI dashboards.
Designing and developing databases: The database developer II is responsible for designing and developing efficient, secure, and scalable databases/marts to meet the organization's needs. This involves creating data models, tables, indexes, and other database objects.
Creating/updating ETL specifications and supporting documentation
Perform day-to-day tasks as an individual contributor for our most complex computer applications and/or application initiatives.
Collaborate on the design & build of a reporting data infrastructure
Interface with product owners and key stakeholders in Project Management, Business, QA and Technology Operations to ensure high quality delivery of software projects
Work with business analysts to understand business requirements and use cases.
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
A bachelor’s degree in computer science or a related discipline, or equivalent work experience
2-3 years' experience in database design, development, and management, including knowledge of SQL and one or more database management systems such as Oracle, SQL Server, or MySQL.
2-3 years hands-on experience in MS T-SQL and SSIS
2-3 years' experience in data warehouse, data modeling, ETL, BI projects
2-3 years SQL experience with the ability to develop, tune and debug complex SQL applications is required
2-3 year’ hands-on experience in PowerBI
Knowledge in schema design, developing data models and proven ability to work with complex data is required
Understanding of best practices for building different data architectures including a Data Mesh, Data Fabric, Data Lake, Data Warehouse and supporting analytical architectures.
Good interpersonal, analytical, problem-solving and organizational skills
Excellent written/verbal communication skills
Preferred
AWS
GCP
GIT / Bitbucket
Docker
Python
DB2
Oracle
Networking
Security / Authentication
Service Provisioning / IaC
Monitoring
Containerization
Benefits
Medical, Dental, Vision, Life, Pet; Flexible Spending Account
Competitive Salaries
401K Match
Work-Life Balance: Personal Days, PTO Days, 12 Paid Holidays, Two Paid Days for Volunteer Service, Paid Parental Leave
Short and Long-Term Disability
Employee Support Programs, Including Mental Health
Tuition Reimbursement
Matching Charitable Gift Program
Lucrative Referral Program
Commuter Benefits
Flexibility: Remote and Hybrid Opportunities Available
Company
FOCUS
FOCUS provides cloud-based, core administration solutions for P&C insurance companies and MGAs.
H1B Sponsorship
FOCUS has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2021 (3)
2020 (1)
Funding
Current Stage
Growth StageRecent News
2024-10-27
Company data provided by crunchbase