Mulesoft Data Engineer

Position Summary

The Effectual Data Engineer builds pipelines that are used to transport date from a data source to a data warehouse. These pipelines are crucial: they are what allow us to access and analyze an organizations data and use the insights to help them make decisions. Data pipelines transport and transform data according to established business rules or a line of exploratory analysis the business wants to undertake. As a Data Engineer, you will prepare and organize the data that organizations have built in their databases and other formats.  This role calls for an experienced Data Engineer highly skilled in MuleSoft design, development, deployment, and execution.

A Glimpse into the Daily Routine of a Data Engineer

A day in the life of a Data Engineer starts with building and delivering high quality data architectures and pipelines that support clients, business analysts, and data scientists. You also work with other technology teams to extract, transform, and load data from several data sources. Data Engineers improve ongoing reporting and processes and automate or simplify self-service for our clients. You will develop, code, and deploy scripts written in the Python programming language, as Python is the language of Data.

Responsibilities

• Develop, construct, test and maintain data architectures from the data architect
• Analyze organic and raw data
• Build data systems and pipelines
• Build the infrastructure required for extraction, transformation, and loading of data from different data sources using SQL and AWS ‘big data’ technologies
• Write scripts for data architects, data scientists, and data quality engineers
• Data acquisition
• Identify ways to improve data reliability, efficiency, and quality
• Develop data-set processes
• Prepare data for prescriptive and predictive modeling
• Automate the data collection and analysis processes, data releasing and reporting tools
• Build algorithms and prototypes
• Develop analytical tools and programs

Qualifications

• Bachelor’s or master’s degree in computer science, Engineering or a related field
• MuleSoft Certified Integration Associate and/or MuleSoft Certified Developer - Level 1
• Five years plus experience working in AWS as a Data Engineer
• Experience working as a Data Engineer in a professional services or consulting environment.
• Proficiency in programming languages such as Python, Java, or Scala, with expertise in data processing frameworks and libraries (e.g., Spark, Hadoop, SQL)
• In-depth knowledge of database systems (relational and NoSQL), data modeling, and data warehousing concepts
• Experience with cloud-based data platforms and services (e.g., AWS, Azure) including familiarity with relevant tools (e.g., S3, Redshift, BigQuery, etc.)
• Proficiency in designing and implementing ETL processes and data integration workflows using tools like Apache Airflow, Informatica, or Talend
• Familiarity with data governance practices, data quality frameworks, and data security principles
• Work minimal direction and turn a clients want and need into working stories, epics which can be performed upon during a sprint.
• A firm understanding of the SDLC process
• An understanding of object-oriented programming

Company Offered Benefits

Full-time employees are eligible to participate in our employee benefit programs:

• Medical, dental, and vision health insurances,
• Short term disability, long term disability and life insurances,
• 401k with Company match
• Paid time off (PTO) (120 hours PTO that accrue over one year)
• Paid time off for major holidays (14 days per year)
• These and any other employee benefit offerings are subject to management's discretion and may change at any time.

Location: Remote or hybrid option

Salary Range for this position: $110,000-$160,000

"Salary ranges provided are for informational purposes only and may vary depending on factors such as experience, qualifications, and geographic location. The final salary offer will be determined based on your skills and understanding of the role requirements."

This job description may not be inclusive of all assigned responsibilities, or aspects of the job described, and may be amended anytime at the sole discretion of the Employer. Responsibilities are subject to possible modification to reasonably accommodate individuals with disabilities. This document does not create an employment contract, implied or otherwise, other than an "at will" relationship. Effectual Inc. is an EEO employer and does not discriminate on the basis of any protected classification in its hiring, promoting, or any other job-related opportunity.