Data Intelligence Consultant

Hylaine; Raleigh (NC); On-site; USD 110,000 - 150,000; Full time

Job summary

Hylaine is seeking a Senior Data Intelligence Consultant to join our Raleigh, NC team. You will be exposed to a broad mix of projects focused on databases, ETL, and data visualization tools.

You will design BI strategies, assist with ETL, data modeling, data warehousing, cloud solutions, and build new reports and dashboards. Ideal candidates have 5+ years of development experience, strong database and data-modeling skills, and experience with major cloud platforms.

Qualifications

• 5+ years of development experience.
• Database development experience with a relational database (ideally Oracle or SQL Server).
• Ability to build conceptual, logical and physical data models, data flows, and create data management.
• Experience in Big Data/Data Warehousing at scale - Including but not limited to Hadoop, Snowflake, Google BigQuery, Azure Data Lakes, Azure Synapse Analytics, Amazon Redshift, AWS EMR
• Some Cloud Experience in a major CSP (AWS, Azure, Google Cloud)
• Strong written and verbal communication skills to work with our team and our clients.

Responsibilities

• Solve challenging business and technical problems.
• Design and develop BI strategies to include assisting with ETL, data modeling, data warehousing, cloud solutions, and building new reports and dashboards.
• Grow in your career and enhance your technical abilities.

Skills

Database development

Relational DB

Big Data Warehousing

Cloud experience

Tools

Hadoop

Snowflake

Google BigQuery

Azure Data Lakes

Azure Synapse Analytics

Amazon Redshift

AWS EMR

Job description

Position Description:

As a Senior Data Intelligence Consultant, you form the backbone of our consulting pool. You will be exposed to a little bit of everything, with a strong focus on databases, ETL, and data visualization tools.

Position Description:

As a Senior Data Intelligence Consultant, you form the backbone of our consulting pool. You will be exposed to a little bit of everything, with a strong focus on databases, ETL, and data visualization tools.

What you’ll Do:

• Solve challenging business and technical problems.
• Design and develop BI strategies to include assisting with ETL, data modeling, data warehousing, cloud solutions, and building new reports and dashboards.
• Grow in your career and enhance your technical abilities.

What you’ll need:

• 5+ years of development experience.
• Database development experience with a relational database (ideally Oracle or SQL Server).
• Ability to build conceptual, logical and physical data models, data flows, and create data management.
• Experience in Big Data/Data Warehousing at scale - Including but not limited to Hadoop, Snowflake, Google BigQuery, Azure Data Lakes, Azure Synapse Analytics, Amazon Redshift, AWS EMR
• Some Cloud Experience in a major CSP (AWS, Azure, Google Cloud)
• Strong written and verbal communication skills to work with our team and our clients.

Extra Credit:

• Agile methodologies and DevOps basics as they pertain to data
• Cloud Technologies
  • Architecture basics of AWS, Azure or Google Cloud- i.e. compute, storage, and permissions
  • Understanding differences between VM and containers as well as knowledge of container orchestration technologies
• Artificial Intelligence or Machine Learning
  • Including but not limited to R, Python, TensorFlow, PyTorch, AutoML, OpenML, Juila, Jupyter,
  • Understanding Data Warehouse vs Data Lake vs Lakehouse concepts and tradeoffs

This position is not eligible for visa sponsorship. To be considered, you must be legally authorized to work in the U.S. now and in the future without the need for sponsorship.

Our company participates in the U.S. Department of Homeland Security's E-Verify program to confirm the employment eligibility of all new hires. Upon hiring, you will complete Form I-9 and present acceptable documents for verification. We use E-Verify to ensure a legal workforce and prevent unauthorized employment, adhering strictly to anti-discrimination laws and protecting employee rights.