Database Engineer V

🔥 0 minutes ago

🦀 Maryland – Remote

🦀 Maryland – Remote

💵 $138k - $155k / year

⏰ Full Time

🟠 Senior

🔴 Lead

🔙 Backend Engineer

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

eSimplicity

WebsiteLinkedInAll Job Openings

51 - 200 employees

Founded 2016

💼 Consulting

🏥 Healthcare

⚕️ Healthcare Insurance

Consulting • Healthcare • Healthcare Insurance

eSimplicity is a company comprised of designers, engineers, and strategists that excels in creating digital services and healthcare IT solutions. They simplify complexity to deliver award-winning products and services that enhance customer experiences, improve public health, and secure the nation. Specializing in areas such as healthcare IT, telecommunications, identity management, and fraud prevention, they work with organizations like the Centers for Medicare & Medicaid Services (CMS) to improve healthcare access and quality. eSimplicity is recognized for their innovative approaches in spectrum management, data analytics, and machine learning, aiming to broaden healthcare coverage and simplify processes for healthcare providers and beneficiaries.

📋 Description

• Gather information from existing systems and analyze program, business, and timing requirements for complex data warehouse initiatives • Provide technical guidance on complex database, data warehouse, and systems analysis challenges • Develop detailed specifications, design logic, pseudo code, and documentation supporting design, development, testing, and implementation • Conduct gap and impact analyses for source-system changes, requirement updates, and data transformation logic • Lead data analysis and database design, including logical and physical relational and dimensional data models • Develop and maintain source-to-target mappings, transformation rules, BI object definitions, and data quality rules • Analyze complex ETL mappings and AWS Glue data flows • Manage metadata across ERwin, Oracle, Amazon Redshift, AWS Glue, and MicroStrategy environments • Create, update, and maintain DDL scripts and database structures for Oracle and Amazon Redshift • Write complex SQL queries to analyze large datasets across multiple formats and sources • Tune database performance and recommend improvements • Evaluate multi-data-mart integration opportunities and recommend solutions • Conduct peer, code, and design reviews and validate testing approaches • Partner with technical teams to resolve issues and support on-schedule delivery of milestones and deliverables • Maintain data architecture standards, technical specifications, operating instructions, and SDLC documentation • Protect CMS, Buyer, and program information according to security, privacy, and confidentiality requirements • Work remotely during Eastern Time business hours; occasional travel may be required at less than 5% annually

🎯 Requirements

• Bachelor's degree in Computer Science, Information Systems, Engineering, or related field; four years of additional relevant experience may substitute for the degree • 10+ years of overall professional experience in database engineering, database design, data warehousing, systems analysis, data architecture, or related technical delivery • Minimum of 7 years of systems analysis experience in a data warehouse environment • Minimum of 3 years of recent hands-on experience architecting data warehouse solutions • Complex SQL query development and analysis of large, multi-format datasets • Logical and physical data modeling, including relational and dimensional models • Database design, DDL scripting, and database structure updates in Oracle and/or Amazon Redshift • Data warehouse architecture, source-to-target mapping, transformation logic, and metadata management • AWS Glue ETL flow analysis and data movement understanding • ERwin or comparable data modeling tools • MicroStrategy 2019 or higher, BI objects, reporting metadata, dashboards, or related BI environments • Database performance tuning, data quality rules, and data architecture documentation • SDLC processes, technical documentation, requirements analysis, peer/code reviews, and quality assurance practices • Experience with Microsoft Word, Excel, PowerPoint, and Project • Ability to work independently and collaboratively while managing multiple priorities • Ability to obtain and maintain favorable Federal suitability/Public Trust adjudication • Only U.S. citizens or lawful permanent residents may be considered due to government contract requirements • Access to information subject to U.S. government regulations

🏖️ Benefits

• Medical coverage • Dental coverage • Vision coverage • 401(k) retirement benefits • Paid time off • Paid holidays • Life insurance • Disability insurance • Wellness and employee support programs • Reasonable accommodations during the application and hiring process