Lead Data Analytics Engineer - Remote
United States
SemanticBits
ICF provides the health IT and scientific support so you can focus on scientific discovery, patient care, and population health.SemanticBits is looking for a talented Data Analytics Engineer who is eager to use their skills to rapidly turn big data into insights for healthcare analysts working at the national level. You will be a senior member of an Agile team delivering a Business Intelligence (BI) and Data Warehouse (DW) solution using AWS services and open-source technologies.
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.
SemanticBits, LLC is an equal opportunity, affirmative action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability, or any other characteristic protected by law. We are also a veteran-friendly employer.
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.
Tags: Agile AWS Big Data Business Intelligence Computer Science Data Analytics Data Warehousing DevOps Looker OLAP Redshift Spark SQL Tableau
Perks/benefits: Flex hours Health care Medical leave Parental leave
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Marketing Data Analyst jobs
- Open MLOps Engineer jobs
- Open AI Engineer jobs
- Open Junior Data Scientist jobs
- Open Senior Data Architect jobs
- Open Data Engineer II jobs
- Open Sr Data Engineer jobs
- Open Data Analytics Engineer jobs
- Open Power BI Developer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Principal Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open Product Data Analyst jobs
- Open Business Data Analyst jobs
- Open Data Manager jobs
- Open Data Quality Analyst jobs
- Open Sr. Data Scientist jobs
- Open Big Data Engineer jobs
- Open Data Scientist II jobs
- Open Business Intelligence Developer jobs
- Open Data Analyst Intern jobs
- Open Principal Data Scientist jobs
- Open ETL Developer jobs
- Open Azure Data Engineer jobs
- Open Data Product Manager jobs
- Open Business Intelligence-related jobs
- Open Data quality-related jobs
- Open Privacy-related jobs
- Open Data management-related jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open Deep Learning-related jobs
- Open APIs-related jobs
- Open PyTorch-related jobs
- Open PhD-related jobs
- Open TensorFlow-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open NLP-related jobs
- Open Data governance-related jobs
- Open Data warehouse-related jobs
- Open Airflow-related jobs
- Open Databricks-related jobs
- Open Hadoop-related jobs
- Open LLMs-related jobs
- Open DevOps-related jobs
- Open Kubernetes-related jobs