Remote Data Engineer

Description:

• The Data Engineer will craft data pipelines that are accurate, performant, testable, scalable, secure, and of the highest quality.
• The role involves applying industry-leading design patterns to ensure resilience, traceability, and predictability of the ETL process.
• The Data Engineer will actively contribute to agile project teams during scrums, sprint planning, and code reviews.
• Participation in requirements analysis sessions, technical design, implementation, testing, problem analysis and resolution, and technical documentation is expected.
• The individual will be responsible for integration testing and articulating technical issues to peers, architects, and project managers while recommending creative solutions.
• Diagnosing process failures and data quality issues and devising remediation solutions in a timely fashion is a key responsibility.
• Client-facing experience and strong communication skills are essential for this role.
• The Data Engineer will actively participate in accurate planning and estimation efforts, utilizing project methods and tools.
• Promoting client success by collaborating with engineers, designers, and managers to understand user pain points and iterate on solutions is crucial.
• The individual will actively participate in the Engineering Practice community, mentoring others and supporting the growth of technical capabilities.
• The role requires independently driving project delivery within defined architecture, demonstrating autonomy and accountability in all stages from conceptualization to deployment.

Requirements:

• A Bachelor’s degree in Computer Science or Software Engineering is required, with a thorough understanding of CS fundamentals and theory relevant to application development.
• A minimum of 4 years of experience/expertise in Oracle PL/SQL, SQL Server T-SQL, or any equivalent procedural database language is necessary.
• Proficiency in SSIS, Datastage, Informatica, or any equivalent graphical ETL tool is required.
• The candidate must demonstrate mastery in SQL.
• Knowledge of industry-standard approaches to dev ops, including version control systems (GIT), automated deployment (Jenkins, Azure DevOps), and database deployment tools (Liquibase, MS DACPAC) is essential.
• Experience in ingesting large volumes of data to a Data Warehouse or Data Lake from diverse data sources such as flat files, relational databases, web services, JSON, and XML is required.
• The candidate should have experience transforming and loading large volumes of data to a data model adhering to Kimball design concepts.
• Familiarity with Agile software development methodologies is necessary.
• Client-facing experience and strong communication skills are essential.

Benefits:

• 3Pillar offers a flexible work environment, allowing employees to work from the office, home, or a blend of both, embodying a remote-first approach.
• Employees will be part of a global team, learning from top talent around the world and across cultures, with English as the primary language.
• The company emphasizes well-being, dedicating a trimester each year to focus on employee wellness, including fitness offerings, mental health plans, and generous time off.
• The professional services model at 3Pillar accelerates career growth and development opportunities across various projects, offerings, and industries.
• 3Pillar is an equal opportunity employer, committed to diversity and reinforcing values like Intrinsic Dignity and Open Collaboration.
• Employees are invited to join a global tech community and can learn more about the company culture through their LinkedIn and Careers pages.