Jr. Data Engineer I at Bloom Insurance

1 year ago Data & Databases Junior Full-Time

We need one to Write SQL scripts, create SQL agent jobs to automate tasks like data importing, exporting, cleansing tasks.


Skills/Knowledge

  • Strong experience in writing efficient SQL code
  • Working knowledge of SQL Server Management Studio (SSMS)
  • Knowledge of SQL Server Reporting Services (SSRS)
  • Knowledge of SQL Server Integration Services (SSIS)
  • Knowledge of Red Gate DBA Tool Belt (SQL Compare, SQL Data Compare, SQL Source Control) a plus
  • Knowledge of data science technologies is a plus
  • Clear, concise communication skills, excellent organizational skills
  • Highly self-motivated and directed
  • Keen attention to detail
  • High level of work intensity in a team environment
  • High integrity and values-driven
  • Eager for professional development
  • Experience and understanding of source control management a plus


Description

Data Engineer I

To support internal and external clients via processing and handling of data. To generate data solutions for ongoing immediate day to day business needs.

Essential Functions

  • Day to day functions include the following:
  • Design data models and develop database structures in Microsoft SQL server.
  • Write various database objects like stored procedures, functions, views, triggers for various front end applications.
  • Write SQL scripts, create SQL agent jobs to automate tasks like data importing, exporting, cleansing tasks.
  • Create database deployment packages for deploying changes.
  • Identify & repair inconsistencies in data, database tuning, query optimization.
  • Able to generate ad hoc data on demand.
  • Able to identify best practices, documentation, communicate all aspects of projects in a clear, concise manner
  • Develop simple SSIS packages to perform various ETL functions including data cleansing, manipulating, importing, exporting.
  • Develop & maintain client facing reports by using various data manipulation techniques in SSRS and Visual Studio.
  • Documentation
  • Optimization recommendations
  • Day to day troubleshooting
  • .NET Programming as needed
  • Education/Experience
  • BA, BS, or Masters in computer science/related field preferred or an equivalent combination of education and experience derived from at least 2 years of professional work experience
  • Solid experience with various versions of MS SQL Server and TSQL programming
  • Microsoft Certified DBA a plus

What We Offer

  • At Advise / Bloom, we offer an engaging, supportive work environment, great benefits, and the opportunity to build the career you always wanted. Benefits of working for Advise / Bloom include:
  • Competitive compensation
  • Comprehensive health benefits
  • Long-term career growth and mentoring

About Advise

Advise Insurance is a licensed Medicare agency that aims to preserve the patient–physician relationship and help build a better healthcare experience. We provide education that explains how Medicare works and helps beneficiaries select a plan that meets their healthcare needs and includes their trusted doctor.

About Bloom

As an insurance services company licensed in 48 contiguous U.S. states, Bloom focuses on enabling health plans to increase membership and improve the enrollee experience while reducing costs. We concentrate on two areas of service: technology services and call center services and are committed to ensuring our state-of-the-art software products and services provide greater efficiency and cost savings to clients.

Ascend Technology ™

Advise / Bloom provides advanced sales and enrollment automation technology to the insurance industry through our Ascend ™. Our Ascend™ technology platform focuses on sales automation efficiencies and optimizing the member experience from the first moment a prospect considers a health plan membership.

Advise / Bloom is proud to be an Equal Opportunity and Affirmative Action employer. We do not discriminate based upon race, religion, color, national origin, sexual orientation, gender, gender identity, gender expression, transgender status, sexual stereotypes, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics. We also consider qualified applicants with criminal histories, consistent with applicable federal, state and local law.

🌍 World Wide sql data database .net
🎉 Let Employers Find You!

Employers will see your profile when they are sending a job in your skill.


Create Your Profile   (simple)