Job added in hotlist
Applied job
Contract job
90-day-old-job
part-time-job
Recruiter job
Employer job
Expanded search
Apply online not available
View more jobs in Washington, DC
View more jobs in District Of Columbia

Job Details

Cloud Data Warehouse Support Engineer

Location
Washington, DC, United States

Posted on
May 09, 2022

Apply for this job






Profile

Resp & Qualifications
COMPANY SUMMARY:
CareFirst, Inc., and its affiliated companies, generally referred to as **MEMBERS ONLY**SIGN UP NOW***. (CareFirst), is the Mid-Atlantic region’s largest private sector health insurer, serving the healthcare needs of 3.5 million members in Maryland, the District of Columbia, and portions of northern Virginia. The Company offers a comprehensive portfolio of products and services to individuals and groups, as well as state and federal government sponsored plans. With a market share almost three times that of the closest competitor, the company commands 45 percent penetration across the region.
In July 2018, Brian D. Pieninck assumed the role of President and CEO after serving as the company’s COO of Strategic Business Units and IT Division. Under his leadership, the organization completed an extensive review of its operations and clinical programs, resulting in an expansive 3-year strategy to grow and diversify the company’s core business. Along with a 5-year vision to drive the transformation of the healthcare experience across the continuum of its members, partners, and communities, the company has placed a renewed and intentional focus on fostering a mission-based culture, which drives every decision the company makes. The organization employs over 5,600 full-time employees in Maryland, Northern Virginia, the District of Columbia, and West Virginia. CareFirst has earned multiple workplace awards recognizing its leadership in diversity and inclusion, wellness engagement, and creation of a supportive and equitable work environment for all employees.
At CareFirst, you are part of an inspired, collaborative team that is building the healthcare experience we want for our families and our future. Every day, we make a meaningful difference in the communities where we live and work.
We practice empathy, seek to understand, invest in inclusion, demand equity and nurture belonging every day for our employees and the communities we serve. We rely on the rich diversity of our employees’ experiences and backgrounds to achieve our mission. Every year we host a Week of Equity and Action where we deepen our investment and commitment to diversity, equity, and inclusion. During this week thousands of employees engage in workshops and volunteerism with the goal of bettering themselves and our community.
Women make up around 70% of CareFirst’s employee population, and over 50% identify as BIPOC (Black, Indigenous, and people of color).
We have 9 resource groups that connect employees over shared identities (LGBTQ, veteran status, race, etc.) and passions (climate change, healthy living, leadership development).
Employees are encouraged to give back and volunteer in their communities with their civic engagement hours.
As a not-for-profit, CareFirst regularly ranks among the most philanthropic organizations with $65 million invested in the community in 2020 to improve overall health, and increase the accessibility, affordability, safety, and quality of healthcare throughout its market area. The company’s employees consistently add to this impact by devoting thousands of volunteer hours to numerous community organizations and social causes. The company’s continued efforts to reinvest in community health care programs has repeatedly earned CareFirst regional accolades as a leading corporate philanthropist, including the No. 2 and No. 7 spots on the Baltimore Business Journal and Washington Business Journal’s 2019 list of top corporate givers, respectively.
PURPOSE:
Understands data needs and advise company on technological resources. Aggregate and analyze various data sets to provide actionable insight. Develop reports, dashboards, and tools for business-users. Develop technical solutions to improve access to data and data usage. Develops and executes ETL code and ensures that the data loading processes are reliable and data quality remains high.

ESSENTIAL FUNCTIONS:
Writes and executes ETL code, primarily complex SQL/NoSQL script, but with a strong ability to leverage other technologies.
Analyzes and validates existing routines and communicates impacts. Assists with data transformation, manipulation, and presentation to users.
Works with Business Analysts, Business Intelligence Developers, Infrastructure Architects, and key business users to review, design, and develop data models and ETL processes.
Supports the Software Engineering team with data analysis and validation with extensive SQL queries.
Designs, configures, implements, monitors, and manages all aspects of Data Integration Framework.
Provides detailed guidance and performs work related to Modeling Data Warehouse solutions in the cloud OR on-premise. Understands Dimensional Modeling, Denormalized Data Structures, OLAP, and Data Warehousing concepts.
Defines Data Integration best practices for the data management environment.
SUPERVISORY RESPONSIBILITY:
This position has no direct reports, however, may informally lead teams in a matrix
environment
.


QUALIFICATIONS:
Education Level:
Bachelor's Degree in Information Technology or Computer Science or Engineering OR in lieu of a Bachelor's degree, an additional 4 years of relevant work experience is required in addition to the required work experience.

Experience:
3 years Hands-on experience with database management systems, ELT/ETL systems, business intelligence tools, defect management and system testing.

Knowledge, Skills and Abilities (KSAs)
Knowledge, understanding, and development experience in Informatica IICS ETL tool. Informatica PowerCenter knowledge is a nice-to-have.
Knowledge, understanding, and development experience in writing SQL queries and Snowflake experience preferred. Oracle and/or SQL Server knowledge is a nice-to-have.
Experience developing in a DevOps environment utilizing CI/CD.
Knowledge and understating of troubleshooting and resolving ETL code issues.
Knowledge and understanding of cloud platforms (Azure preferred).
Knowledge and understanding of at least one programming language (i.e., SQL, NoSQL, Python).
Knowledge and understanding of data exchange formats.
Knowledge and understanding of database design and implementation concepts.
Ability to recognize, analyze, and solve a variety of problems.
Knowledge and understanding of data movement concepts.
Excellent communication skills both written and verbal.
Must be able to effectively work in a fast-paced environment with frequently changing priorities, deadlines, and workloads that can be variable for long periods of time. Must be able to meet established deadlines and handle multiple customer service demands from internal and external customers, within set expectations for service excellence. Must be able to effectively communicate and provide positive customer service to every internal and external customer, including customers who may be demanding or otherwise challenging.
Department
Department:
CBIW Operations - DC
Equal Employment Opportunity
**MEMBERS ONLY**SIGN UP NOW***. is an Equal Opportunity (EEO) employer. It is the policy of the Company to provide equal employment opportunities to all qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veteran or disabled status, or genetic information.
Hire Range Disclaimer
Actual salary will be based on relevant job experience and work history.
Where To Apply
Please visit our website to apply: ****Federal Disc/Physical Demand
Note: The incumbent is required to immediately disclose any debarment, exclusion, or other event that makes him/her ineligible to perform work directly or indirectly on Federal health care programs.
PHYSICAL DEMANDS:
The associate is primarily seated while performing the duties of the position. Occasional walking or standing is required. The hands are regularly used to write, type, key and handle or feel small controls and objects. The associate must frequently talk and hear. Weights up to 25 pounds are occasionally lifted.
Sponsorship in US
Must be eligible to work in the U.S. without Sponsorship
#LI-LD1

Company info

Sign Up Now - OperationsCrossing.com

Similar Jobs:
Specialty/Competency: Data and Analytics Technologies Industry/Sector: Not Applicable Time Type: Full time Travel Requirements: Up to 20% A career within Data and Analytics services will provide you with the opportunity to...
Cloud Data Warehouse Engineering, Manager
Location : Washington, DC
Specialty/Competency: Data and Analytics Technologies Industry/Sector: Not Applicable Time Type: Full time Travel Requirements: Up to 20% A career within Data and Analytics services will provide you with the opportunity to...
Operations Manager
Location : Lanham, MD
What Were Looking For: This role will work to help create, document, implement, and train new tools and processes across the entire Student Service and Central Support organization. Reporting to the Director of Central Operation...
I like the volume of jobs on EmploymentCrossing. The quality of jobs is also good. Plus, they get refreshed very often. Great work!
Roberto D - Seattle, WA
  • All we do is research jobs.
  • Our team of researchers, programmers, and analysts find you jobs from over 1,000 career pages and other sources
  • Our members get more interviews and jobs than people who use "public job boards"
Shoot for the moon. Even if you miss it, you will land among the stars.
OperationsCrossing - #1 Job Aggregation and Private Job-Opening Research Service — The Most Quality Jobs Anywhere
OperationsCrossing is the first job consolidation service in the employment industry to seek to include every job that exists in the world.
Copyright © 2022 OperationsCrossing - All rights reserved. 21 192