Senior Software Engineer - Analytics

Employer: Corvesta Inc.
Job Location: Roanoke, Virginia
Category: IT/Computers/Networking
Employment Type: Full Time
Last Updated: 1/8/2018
Closing Date: 3/31/2018
Corvesta Inc.
Corvesta, Inc. is the parent holding company for a family of companies dedicated to advancing oral
health through scientific research, technology, and benefits and practice management. OneMind Health,
Revolv, and Corvesta Life Insurance Company are among the wholly owned subsidiaries of Corvesta, Inc.
Corvesta also fulfills its mission through a variety of strategic partnerships and investments, including
Encara, C3 Jian, Inc. and Healthentic, Inc. Corvesta is a non-stock, non-profit holding corporation.
Job Description Position Summary:
We are looking for highly experienced data warehouse modeler and developer to join our Reporting & Analytics team. This position will play a key role working hands-on with team in designing and developing operational reporting, BI and Analytical solutions. This position will have an exciting opportunity to work with cutting-edge technologies in an agile team environment in developing/revising solutions for an enterprise self-service data platform.
Essential Functions:
As a Sr. Software Engineer in Reporting & Analytics team, you will work on following:
  • Develop a strong understanding of organization’s existing and upcoming data structures and usage requirements
  • Partner closely with business stakeholders, business analysts, end users and development team members to refine business and data capability requirements
  • Lead efforts to map requirements to structures in data warehouse using conceptual, logical, and physical models and develop appropriate processes for data integration
  • Provide hands-on technical development of new data warehousing solutions
  • Implement ETL processes integrating data from variety of transactional data sources to staging and into traditional dimensional databases/data lake
  • Optimize data management process involving large complex data sets, abstract complexity to enable users to perform required analysis and reporting
  • Lead data development and change management on the data warehouse and ensure overall integrity of data models and configurations
  • Develop appropriate logs monitoring methods, and audit methods to ensure high availability, quality, security, scalability, performance and overall reliability
  • Collaborate users, development, architecture teams to ensure timely resolution of data issues
  • Maintain accurate documentation of work, including data models, data dictionaries and other artifacts as per corporate standards, data governance and architecture guidelines
  • Recommend technical resources on best practices related to BI and enterprise data management
  • Partner with business users to ensure self-reliance is achieved, and users are able to develop their own reports using tools provided and with complete confidence on data 
  •  Effective communicator with excellent analytical and problem-solving skills
  • Proven skills in developing robust, extensible and scalable data warehouse solutions
  • Bachelor’s Degree in Computer Science, Information Technology or related field required
  • 10+ years of demonstrable development and administrative work data warehouses
  • Solid understanding of ETL and ELT data integration methodologies
  • Required:
    • ETL tools: 5+ years of experience in (Clover, Talend, Pentaho DI, or similar); preferably Clover
    • BI Tools: 5+ years of experience in (Qlik, Tableau, Spotfire, Pentaho or similar); preferable in QlikView/QlikSense
    • Databases: 10+ years of experience in data warehousing using relational, NoSQL. (Postgres, Oracle, SQL Server).
      • Preferable to have experience multiple types of data sources (structured, semi-structured, unstructured data).
    • Reporting: 3+ years of experience developing formatted reports using Crystal Reports, Pentaho Report Designer, Qlik NPrinting or similar tools
    • Experience with Data Lake/BigData is highly desirable
    • Experience with AWS, RDS/Redshift/S3/Lambda Architecture is highly desirable
  • Strong experience in developing visualizations using BI/Analytics tools like Qlik, Tableau, Spotfire, Pentaho
  • Experience as a hands-on technical role working directly with user departments
  • Excellent knowledge and multi-year experience with agile development methodology.
  • Analytics lifecycle development methodologies.
  • Ensure overall solution-level integrity of analytics.
  • Experience successfully working with internal and extended / off shore staffing models
  • Insurance domain experience preferred
  • Strong interpersonal and communication skills.
  • Updates job knowledge by studying state-of-the-art development tools, programming techniques, and computing equipment; participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations.
  • Accountable to accomplish engineering and organization mission while completing solution delivery.
  • Develops software solutions by studying information needs; conferring with users and internal cross discipline IT department; studying systems flow, data usage, and work processes; investigating problem areas; following the software development lifecycle.
Physical Demands and Work Environment:
The physical demands and work environment characteristics described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
  • Physical demands: While performing the duties of this job, the employee is occasionally required to walk; sit; use hands to finger, handle, or feel objects, tools, or controls; reach with hands and arms; balance; stoop; talk or hear. Use of hands is required for such technological devices such as a computer, telephone, blackberry and others. The employee must occasionally lift and/or move up to 15 pounds. Specific vision abilities required by the job include close vision, distance vision, color vision, peripheral vision, depth perception and the ability to adjust focus. The employee will be required to travel (sometimes long distances) to attend required meetings.
  •  Work environment: The work is limited to the office environment with occasional trips to other office facilities or locations necessitating walking outdoors or driving. The noise level in the work environment is usually minimal.
Sharing and Options