SemanticBits is a leading company specializing in the design and development of digital health services and the work we do is just as unique as the culture we’ve created. We deliver using Agile practices to help the government solve their most technically challenging problems. The systems we develop are used to improve the quality of healthcare delivered to millions of people and revolutionize the healthcare industry on a nationwide scale. SemanticBits is a remote-first employer and has been named a Top Workplace in 2021. As a government contractor, SemanticBits requires that candidates must be able to obtain a Public Trust clearance and show proof of COVID-19 vaccination or obtain a religious or medical exemption.

Responsibilities:

• Apply dimensional modeling best practices to design an enterprise DW
• Provide data modeling guidance to line-of-business contributors to the enterprise DW and fellow analytics engineers
• Participate in enterprise data governance activities
• Configure, optimize, and troubleshoot the DW to meet performance and scalability needs
• Provide guidance on the most effective use of data marts within the BI solution
• Contribute to data warehouse documentationUse open-source software and AWS services to automate data warehouse transformations over big data sets
• Provide guidance to DevOps team for maintaining database performance by identifying and resolving production and application development problems, calculating optimum values for database parameters, evaluating, integrating, and installing new releases, performing maintenance, and answering user questions

Qualifications:

• At least 3 years in a DBA or data architect role
• Significant experience with AWS Redshift and one or more BI tools (e.g. Tableau, MicroStrategy, Looker, Apache Superset)
• Strong understanding of relational database and data warehousing concepts (e.g. OLAP, dimensional modeling)
• Very strong SQL query skills
• Must be able to effectively use a query planner and database metrics to analyze and optimize queries, table structure, indices, and partitioning strategies.
• Strong problem solving and structuring skills
• Strong technical communication skills; both written and verbal
• Ability to understand and articulate the "big picture" and simplify complex ideas
• Ability to identify and learn applicable new techniques independently as needed
• Candidate must reside in the United States
• Bachelor's degree in Computer Science strongly preferred and a minimum of 5 years of relevant experience or a Master’s degree with a minimum of 3 years experience
• Flexible and willing to accept a change in priorities as necessary

Preferred Qualifications:

• AWS Certified Data Analytics - Specialty
• Experience with EMR, Spark, and DBT
• Prior experience working with Medicare and/or Medicaid data
• Prior experience working remotely full-time
• Federal Government contracting work experience

Physical and emotional requirements for the job:

• This position is to be performed remotely from an individual’s home office and involves sedentary work. Employees in this role can be expected to exert up to 10 pounds of force on occasion in order to lift, carry, push, pull or otherwise move standard electronic equipment. Employees are expected to make decisions in a timely manner and display emotional intelligence during occasional stressful situations.

Competitive salary

Stipend for work station set up

Four weeks of PTO

Eleven paid holidays

One floating holiday

Comprehensive health benefits (medical with HSA option, dental, and vision)

Employer HSA contribution

401k retirement plan with matching benefit

100% paid short-term and long-term disability

100% paid life insurance

Flexible Spending Accounts (FSA)

Three weeks parental leave

Casual working environment

Flexible working hours

If you are an individual with a disability and require a reasonable accommodation to complete any part of the application process, or are limited in the ability or unable to access or use this online application process and need an alternative method for applying, you may contact 703-787-9656 x257 for assistance.