Data Engineer

Join SADA as a Data Engineer!

Your Mission

Job Duties:

1. Design, develop, implement, and maintain data and database systems, servers, and solutions.
2. Review project requests and estimate the time, cost, and feasibility of database designs and projects within time and cost constraints.
3. Analyze business and software requirements and design database solutions, tables, code, and procedures to improve system performance.
4. Ensure the quality and performance of database solutions and develop strategies to detect, diagnose, and resolve hardware, software, and network issues.
5. Provide technical support to database users and serve as a subject matter expert on company database systems and solutions.
6. Work with management to determine business, data, and data management requirements.
7. Prepare design specifications and functional documentation for application databases.
8. Work collaboratively with architects and other engineers to recommend, prototype, build, and debug data infrastructures on Google Cloud Platform (GCP).
9. Identify system, hardware, and software components required to meet user needs and ensure the compatibility of components with business requirements.
10. Create, review, and finalize designs and technical specifications and establish project scope, goals, budgets, phases, and timelines.
11. Participate in early-stage opportunity qualification calls and lead client-facing technical discussions for establishing effort estimates.
12. Write code and logical and physical database descriptions and specify database identifiers using Python, Java, Scala, and Go.
13. Create, administer, maintain, and load-test highly available and scalable MySQL clusters, cluster databases, and database servers.
14. Write SQL deployment scripts using DDL and DML for application patches.
15. Develop batch jobs using shell scripting and SQL and stored procedures using PL/SQL to load data files, create reports, and perform custom jobs.
16. Implement and utilize backup and recovery procedures, including disaster recovery, database planning, and replication of MySQL clusters across multiple security groups.
17. Operationalize machine learning models on large datasets and build production-grade data solutions (relational and NoSQL).
18. Conduct systems monitoring/alerting, capacity planning, and performance tuning with Google Cloud data products, including Cloud SQL, Spanner, Cloud Storage, Pub/Sub, Dataflow, Dataproc, Bigtable, BigQuery, Dataprep, and Composer.
19. Develop test plans to test and debug solutions and modify systems, scripts, and utilities as needed.
20. Perform SQL query and database performance tuning on a regular basis to ensure optimal application performance using tools such as SQL Server Profiler and SQL Server Database Tuning Advisor.
21. Analyze and troubleshoot database queries and adjust indexes to optimize query performance.
22. Develop standards and guidelines to guide the use and acquisition of software and to protect vulnerable information.
23. Ensure data quality and integrity in system databases using database comparison tools such as RedGate SQL Compare.
24. Coordinate system improvements, bug fixes, and deployments with software development, quality assurance, and customer support teams.
25. Run point on whole projects and provide guidance to less experienced Data Engineers.
26. Serve as an expert within the team and help build a reputation with Google and our customers.
27. Deliver project architectures and critical components effectively on a consistent basis.
28. Develop standards and guidelines for the use and acquisition of software and the protection of vulnerable information.
29. Stay abreast of the latest technology and industry trends with an emphasis on the Google Cloud Platform.

Job Requirements:

The position requires a Bachelor's Degree or foreign equivalent in Computer Science, Information Technology, Computer Applications, Information Systems, and Security or related and 3 years of experience in the job offered or related occupation.

Special skills requirements:

Must have 3 years of experience in the following skills:

1. Experience in building production-grade data solutions (relational and NoSQL).
2. Experience with Data Integration Tools: building data pipelines using modern data integration tools such as Fivetran, Striim, Data Fusion, etc.
3. Experience configuring and integrating with multiple Data Sources within and outside of Google.
4. Large Enterprise Migration: migrating entire cloud or on-prem assets to Google Cloud, including Data Lakes, Data Warehouses, Databases, Business Intelligence, Jobs, etc.
5. Provide consultations for optimizing cost defining methodology, and coming up with a future state architecture.
6. Experience writing software in at least two or more languages such as Python, Java, Scala, or Go.
7. Experience with systems monitoring/alerting, capacity planning, and performance tuning.

The base salary range for this full-time position is $158,000 and $168,000 + company bonus + benefits. Within the range, individual pay is determined based on job-related skills, experience, relevant education/certification or training, and work location.

Work Schedule: 40 hours/week

May telecommute from anywhere in the US.

Qualified applicants send cover letter and resumes to: SADA Systems, Inc., Joseph Obezo, Senior People Operations Generalist, , and ref job #AA01. EOE.

About SADA An Insight company

Values: SADA stands for inclusion, fairness, and doing the right thing. From our very beginning, we've championed a diverse workplace where we support and learn from each other, amplifying the impact we make with our customers. We're proud that our teams are composed of contributors who represent a wide array of backgrounds, experiences, abilities, and perspectives. We are an equal opportunity employer. Our five core values are the foundation of everything we do:

• Make Them Rave
• Be Data Driven
• Think One Step Ahead
• Drive Purposeful Impact
• Do The Right Thing

Work with the Best: SADA has been the largest Google Cloud partner in North America since 2016 and, for the sixth year in a row, has been named a Google Global Partner of the Year. This year, SADA was named a Google Cloud Global Partner of the year 2023. SADA has also been awarded Best Place to Work year after year by the Business Intelligence Group and Inc. Magazine, and was recognized as a Niche Player in the 2023 Gartner Magic Quadrant for Public Cloud IT Transformation Services.

Benefits: Unlimited PTO, paid parental leave, competitive and attractive compensation, performance-based bonuses, paid holidays, generous medical, dental, vision plans, life, short and long-term disability insurance, 401K/RRSP with match, as well as Google-certified training programs and a professional development stipend.

Business Performance: SADA has been named to the INC 5000 Fastest-Growing Private Companies list for the last 10+ years in a row, garnering Honoree status. CRN has also named SADA on the Top 500 Global Solutions Providers list for the past 5 years. The overall culture continues to evolve with engineering at its core: 3200+ projects completed, 4000+ customers served, 10K+ workloads, and 30M+ users migrated to the cloud.

To request reasonable accommodation to participate in the job application or interview process, contact SADA complies with federal and state/provincial disability laws and makes reasonable accommodations for applicants and candidates with disabilities.