Signature Consulting Group, LLC

Database Developer

  • Dec-05-2017
  • 297.1
  • Technology
  • Windsor Mill, MD

Job Summary:

Architect and implement enterprise Data Management solutions for healthcare analytics

Job Responsibilities:

  • Design, develop and maintain complex and advanced Business Intelligence (BI) capabilities such as semantic layers, OLAP cubes, universes, predefined reports, access, capacity and performance management
  • Participate in various requirements sessions with internal and external stakeholders and convert business / functional requirements into technical solutions, along with supporting materials such as use cases, designs, flowcharts, models, specifications, and reports
  • Provide technical support to requirements, development, testing, help desk, and training teams
  • Work directly with users, client, and project team to develop end-user training and reference materials
  • Interact with the database team to ensure data integrity and optimize end-user experience and performance as well as interpret error logs to debug and correct code
  • Follow the corporate and program SDLC and quality guidelines, as well as adhere to industry regulations and compliance requirements
  • Draft standards and procedures affecting data analysis and process modeling, as well as database design, maintenance, and management
  • Support database initiatives related to security, capacity, scalability, performance, platform upgrades, service agreements, and disaster recovery
  • Provide support to users with formulating queries and understanding the data contained in the data warehouse
  • Conduct performance tuning reviews for improvements to high volume BI environments and prepare written reports of findings, including recommendations and cost justification analysis
  • Interview, train and coach team members

Job Qualifications:

Required:

  • 6+ years of proficiency with advanced SQL programming and/or database administration
  • 6+ years practical experience implementing enterprise data warehouse solutions, including physical, logical and conceptual modeling, ETL, BI reporting, and data analysis
  • Hands-on development experience with Teradata SQL and Fastload, Multiload, TPump, BTEQ and TASM utilities
  • Advanced knowledge of decision and intelligence systems concepts, and database structures such as ETL, normalization, datamarts, fact tables, dimensions, views, cubes, olap, rolap, rbac, star and snowflake schemas
  • Proven track record with successful implementation of Data Management disciplines such as Data Governance, Data Warehousing, Data Quality, Metadata Management and Master Data Management
  • Experience with KornShell programming on Unix/Linux platforms
  • Ability to analyze project requirements and develop detailed specifications and designs for new BI capabilities, while balancing cost, performance, quality and schedule demands
  • Ability to standardize, harmonize, cleanse, prepare and use data for developing datasets, reports and analytics
  • Must have excellent verbal and written communication skills, ability to work independently with minimal supervision, be a team player, and be well organized and efficient with excellent judgment, problem-solving and decision-making skills
  • Confident and proactive self-starter, skilled in taking initiative, assessing requirements, coming up with plans, and taking the lead in making plans reality
  • A high level of energy with a results-driven attitude in a fast-paced environment
  • Demonstrate a high degree of adaptability, comfortable in establishing new directions, managing rapid change, and trying different approaches to deal with uncharted territories
  • Possess excellent interpersonal skills to build and maintain positive, productive relationships with colleagues, managers, external stakeholders and client
  • Comfortable and experienced operating in an outcome oriented environment

Optional:

  • Experience with Medicare and/or Medicaid fee-for-service and managed care claims, coding, and reimbursement procedures, service and coverage policies, coordination of benefits, as well as provider and beneficiary eligibility data
  • Experience with supporting leading commercial-off-the-shelf (COTS) BI applications like SAS EBI, BusinessObjects, Cognos and MicroStrategy
  • Familiarity with post-relational databases such as Hadoop, Spark, NoSchema, NoSQL and Big Data
  • Experience with moving large amounts of data from a mainframe to a UNIX environment
  • Experience with CMS Integrated Data Repository (IDR), and CMS fraud detection and prevention solutions
  • Practical experience with high volume data mining or competitive intelligence, statistical analysis, predictive modeling, forecasting, or econometrics

Educational Requirements

  • Bachelor´s degree in engineering, computer science, mathematics, statistics or equivalent
  • First
  • No

Additional Information:

.