Note: The job is a remote job and is open to candidates in USA. Applied Systems develops cloud software and AI-powered solutions for the insurance industry. The company is seeking a Data Engineer to build, model, and maintain large-scale data solutions and support data architecture, accessibility, and AI initiatives using Google Cloud Platform and BigQuery. The role involves optimizing data infrastructure, ensuring data quality, and improving data management processes from ingestion through reporting.
Responsibilities
- Code BigQuery procedures, functions, and other database objects by applying expert knowledge in BigQuery SQL and ANSI SQL
- Implement scalable and efficient data models within our data lake, with a focus on BigQuery
- Manage and optimize data storage, partitioning, and clustering strategies to ensure high performance and reliability of our data infrastructure
- Develop and implement features and enhancements in BigQuery, levering your expertise in SQL and cloud-based data warehousing technologies
- Collaborate with cross-functional teams to understand requirements and deliver solutions aligned with business objectives, security requirements, and guidelines for data governance
- Develop documentation for the team to support design discussions
- Ensure data integrity and quality by implementing robust data validation and error-handling mechanisms
- Identify and implement improvements across the full lifecycle of data management, from ingestion to ETL processes and final reporting layers, to increase productivity on the team
- Continuously build knowledge of industry trends and advancements in data engineering and big data technologies
Skills
- 3+ years of experience in modeling, building, and maintaining data solutions in cloud-based environments
- Proficiency in SQL and Python to manipulate, store, manage, or retrieve data assets
- Proven impact with BigQuery and cloud-based data warehousing solutions
- Experience managing and optimizing BigQuery and Google Cloud Platform data services
- Knowledge of Agile frameworks, ideally Scrum, and tools like Jira and Confluence
- Demonstrated analytical and problem-solving skills and detail orientation
- Bachelor-level degree in Computer Science, MIS, or CIS, or equivalent experience
Benefits
- Remote work
- Medical, Dental, and Vision Coverage
- Holiday and Vacation Time
- Health & Wellness Days
- A Bonus Day for Your Birthday
- Depending on the role, team members may also be eligible for additional compensation plans (bonus and commission).
Company Overview
Company H1B Sponsorship