Junior SQL Developer

MissionMind Inc
Columbia, MD, United States
3 months ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Starter
Compensation
$55,007.0 - $66,245.0
Working hours
Regular working hours
Job source

Tech stack

Agile Methodology Amazon Web Services Bash Shell Big Data Cloud Computing Databases Data Integration Extract Transform Load (ETL) Data Security Data Systems Data Warehousing Database Design
+20 more
Distributed Data Store Apache Hadoop Apache Hive Python (Programming Language) Microsoft SQL Server Oracle Databases Oracle (Applications) Performance Tuning Azure Data Lake Shell Script SQL Databases Systems Integration Talend Data Storage Management Apache Spark Database Performance Vba Programming Language Restful APIs Looker Analytics Data Pipelines

Job description

Join our dynamic team as a Junior SQL Developer and play a vital role in shaping our data-driven solutions! This energetic position offers an exciting opportunity to contribute to the development, optimization, and management of data systems that empower business insights. You will work closely with experienced data professionals to build scalable data pipelines, enhance database performance, and support analytics initiatives using cutting-edge technologies. If you’re passionate about data, eager to learn, and ready to make an impact, this role is perfect for you!, * Assist in designing, developing, and maintaining SQL-based databases and data warehouses to ensure efficient data storage and retrieval.

  • Collaborate on building ETL (Extract, Transform, Load) processes using tools like Informatica and Talend to streamline data integration from diverse sources such as Oracle, Microsoft SQL Server, and cloud platforms like Azure Data Lake and AWS.
  • Support the implementation of Big Data solutions utilizing Hadoop, Apache Hive, Spark, and related frameworks to handle large-scale datasets effectively.
  • Develop and optimize SQL queries for reporting and analysis purposes; utilize Looker and other BI tools to create insightful dashboards.
  • Contribute to the automation of workflows through shell scripting (Bash), Python, VBA, or RESTful APIs to improve operational efficiency.
  • Participate in Agile development cycles by providing analysis skills for model training, database design improvements, and system enhancements.
  • Assist in troubleshooting database issues, performing performance tuning, and ensuring data security compliance.

Requirements

Do you have experience in Spark?, * Basic understanding of SQL programming with experience in Microsoft SQL Server or Oracle databases.

  • Familiarity with cloud platforms such as AWS or Azure Data Lake is highly desirable.
  • Knowledge of ETL processes and tools like Talend or Informatica; experience with Hadoop ecosystem components such as Apache Hive or Spark is a plus.
  • Exposure to Big Data concepts including distributed storage and processing frameworks like Hadoop or Spark.
  • Ability to write shell scripts (Bash) or Python for automation tasks; experience with VBA is advantageous.
  • Strong analysis skills with an eye for detail; capable of translating business needs into technical solutions.
  • Understanding of database design principles and data warehouse architecture.
  • Experience working within Agile teams; familiarity with RESTful APIs for system integration is beneficial.
  • Excellent problem-solving skills combined with a proactive attitude towards learning new technologies such as Looker or Model training techniques. Embark on a journey where your passion for data meets innovative technology! We are committed to fostering an inclusive environment that supports your growth while offering meaningful opportunities to develop your skills in a fast-paced setting. Join us today and help transform raw data into powerful insights that drive success!

Benefits & conditions

Pulled from the full job description

  • 401(k)
  • Dental insurance, * 401(k)
  • Dental insurance

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on indeed.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:04 min

Database evolution and the funding behind vector databases

Erik Bamberg · LIVE

3:28 min

Defining big data and machine learning fundamentals

Ayon Roy · LIVE

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

4:01 min

Managing application isolation via pluggable database models

Wei Hu Wei Hu · WWC 2022

2:10 min

Why organizations combine big data and machine learning

Ayon Roy · LIVE

3:14 min

Structuring career paths and localized data architectures

Ulrich Wurstbauer +1 · LIVE

Videos

See all

Related articles

See all