Senior Database Developer

3PILLAR GLOBAL Company

At 3Pillar, culture is more than a buzzword. The power of culture, teamwork, and open collaboration drive our commitment to building breakthrough software solutions that power digital businesses. Our passion for products has gained us recognition in some of software’s most innovative spaces, including a spot on the Inc. 5000 list ten times, an Institute of Excellence in Sales (IES) Premier Sales Employer winner, a three-time winner of the Washington Post Top Workplaces Award, and notable features in Forbes, Fortune, and the Washington Business Journal.

We work with clients to build incredible innovative products as their development partner whose solutions drive rapid revenue, market share, and customer growth for industry leaders in Software and SaaS, Media and Publishing, Information Services, and Retail. Our key differentiator is our Product Mindset and Lightwave Methodology. Our development teams focus on building for outcomes and all of our team members around the globe are trained on the Product Mindset’s core values – Minimize Time to Value, Solve for Need, and Excel at Change. Our teams apply this mindset to build digital products that are customer-facing and revenue-generating. Our business-minded approach to agile development ensures that we align to client goals from the earliest conceptual stages through market launch and beyond.

WHAT WE BELIEVE

At 3Pillar, our core values – Intrinsic Dignity, Outsized Impact, Open Collaboration, and Continuous Improvement – drive our commitment to providing best in class product development services to high growth businesses across the globe. We’ve spent more than fifteen years building innovative software solutions. Our executive team has always held our values to the highest standard which has led to active participation on the Forbes Tech Council, a winner of the Ernst & Young Entrepreneur of the Year Award, and a spot on the Washington Business Journal’s Women Who Mean Business list.

RESPONSIBILITIES

• Understanding the business requirements
• Writing code and implementing the proposed solutions
• Creating data pipelines, versioning and change management
• Manage the complexity inherent in versioned data pipelines
• Develop ETL/ELT processes to help extract and manipulate data from multiple sources.
• Design, build and maintain batch or real-time data pipelines in production.
• Automate data workflows such as data ingestion, aggregation, and ETL processing.
• Logging and instrumentation of pipelines and services.
• Ensure data accuracy, integrity, privacy, security, and compliance through quality control procedures.
• Train and mentor junior engineers.
• Key Skills: Oracle, Stored Procedures, Data Analysis

REQUIREMENTS

• Demonstrated expertise with a minimum of 5+ years of experience as data engineer or similar role
• Advanced SQL skills and experience with relational databases and database design.
• Experience working with cloud Data Warehouse solutions (e.g., Snowflake, Redshift, BigQuery, Azure Synapse, etc.).
• Strong Python skills with hands-on experience on Pandas, NumPy and other data related libraries
• Experience with Big Data technologies like Spark, Map Reduce, Hadoop, Hive etc
• Proficiencient in data pipeline and workflow management tools e.g. Airflow
• Experience with data visualization tools like PowerBI, Tableau, AWS QuickSight etc
• Experience with the AWS/Azure/GCP data engineering services
• Knowledge of AWS services viz., S3, Lambda, EMR, GLUE ETL, Athena, RDS, Redshift, EC2, IAM
• OR
• Knowledge of Azure services viz., ADF, Azure Synapse Analytics, ADLS Gen2, Azure SQL DB
• Very good exposure of working on Data Lakes & Data Warehouses solutions
• NICE TO HAVE:
• Experience working with data ingestion tools such as Fivetran, stitch, or Matillion.
• Good understanding of NoSQL databases like Redis, Cassandra, MongoDB, or Neo4j.
• Familiarity with machine learning technologies.
• Experience in Java or Scala

BENEFITS

• At 3Pillar, we offer a world of opportunity:

• Imagine a flexible work environment – whether it's the office, your home, or a blend of both. From interviews to onboarding, we embody a remote-first approach.

• You will be part of a global team, learning from top talent around the world and across cultures, speaking English everyday. Our global workforce enables our team to leverage global resources to accomplish our work in efficient and effective teams.

• We’re big on your well-being – as a company, we spend a whole trimester in our annual cycle focused on wellbeing. Whether it is taking advantage of fitness offerings, mental health plans (country-dependent), or simply leveraging generous time off, we want all of our team members operating at their best.

• Our professional services model enables us to accelerate career growth and development opportunities - across projects, offerings, and industries.

• We are an equal opportunity employer. It goes without saying that we live by values like Intrinsic Dignity and Open Collaboration to create cutting-edge technology AND reinforce our commitment to diversity - globally and locally.

• Join us and be a part of a global tech community! 🌍💼 Check out our Linkedin site and Careers page to learn more about what it’s like to be part of our #oneteam!