IT

Data Engineer/Analyst

Centurion Consulting Group

Data Engineer/Analyst Windsor Mill, MD

 

Centurion is hiring immediately for an Enterprise Data Engineer to support a multi-year Federal program in Baltimore, MD. 

As part of enterprise data architect team, enterprise data engineer is responsible for providing the data architect solutions and develop data models to support OLTP, BI and advanced analytics across the enterprise in cloud database platforms.  Candidate will work with project leads, business analysts, enterprise data architects, development teams and DBAs to design conceptual data models for relational and non-relational databases.

Key Required Skills:

Experience in PostGreSQL / Greenplum database and working on data pipeline for non-relational data structure, NoSQL data model such as JSON on MongoDB, HBASE, Hive is a plus

Required:

  • The position requires a Bachelor Degree with 5+ years’ experience in BI related fields with progressively increased level of responsibility in ETL development, data pipeline, database design, and SQL development with some experience in data analysis, data modeling, BI report development.
  • Worked with OLTP/data warehouse modeling, and play key role in multiple projects and act as knowledge expert (Technical, Functional).
  • Collaborate with Solution & Enterprise Architects, Business analysts, DBAs and others to understand business requirements.
  • Lead complex discussions and engagements that may involve multiple project teams from client.
  • Able to work independently with BA and PM to gather requirements, perform data discovery, come up with data model, and work with developers to design and implement ETL solutions.
  • Extensively used ETL methodologies for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution.
  • Experience working on data pipeline solution on large database environment (e.g. Greenplum/PostgreSQL).
  • Good experience in ETL design best practices and performance tuning.
  • Good data analysis, problem solving and SQL skills.
  • Ability to optimize and performance tune in ETL and SQL queries.
  • Technical experience in information architecture, data architecture, data modeling, data governance, ETL design, data quality and BI-analytics.
  • Experience designing relational data models, analytical data models and non-relational data models for OLTP and advanced analytic applications.

Desired Skills:

  • Experience working in large-scale cloud database environments is a plus.
  • Experience in PostGreSQL / Greenplum database is good to have
  • Experience working on data pipeline for non-relational data structure, NoSQL data model such as JSON on MongoDB, HBASE, Hive is a plus
  • Good communication skills and ability to convey complex topics through effective documentation as well as presentation.
  • Familiar with machine learning and advanced analytic application development.
  • Ability to create dashboards in Tableau or Webfocus using various sources like database, CSV files, XL spreadsheets etc.

Education: 

  • Bachelors +5 minimum

Position Details: 

  • Clearance: Ability to Obtain a Public Trust
  • US Citizenship or Authorization to work in US required
  • Travel: < 10% (CONUS)
  • Centurion Consulting Group, LLC is an Equal Opportunity Employer EOE M/F/D/V
  • No third parties or subcontractors

Tagged as: Data Engineer/Analyst