Remote Database Solution Architect

Summary

CloudHire is seeking a remote Data Architect with 7+ years of experience in AWS (preferred), GCP or Azure to build and maintain data architecture, data models, and conceptual data designs. The role involves integrating multiple databases, working with message buses, collaborating with stakeholders, designing and deploying for scale, analyzing the current technology environment, developing data pipelines, mentoring the team, and more.

Requirements

• 7+ years with AWS (preferred), GCP or Azure
• 10+ years of experience using standard methodologies to design, build, and support near real-time data pipelines and analytical solutions using Postgres, Redshift. , BigQuery, Hadoop, Teradata, MS SQL Server, Talend, Informatica, Powerbi and/or SSIS
• 10+ years of experience using object-oriented languages (.Net, Java, Python) to deliver data for near real-time, streaming analytics
• 10+ years of experience working with partners documenting business requirements and translating those requirements into relational, non-relational, and dimensional data models using Erwin
• 10+ years of experience working on agile teams delivering data solutions
• 10+ years of experience developing MDM solutions
• 8+ years of experience in delivering solutions on public cloud platforms (Google Cloud preferred)
• Experience writing automated unit, integration, and acceptance tests for data interfaces & data pipelines
• Ability to quickly comprehend the functions and capabilities of new technologies, and identify the most appropriate use for them

Responsibilities

• Integrate multiple databases together, Snowflake schema, Star schema, Network model, and others
• Work with multiple message buses, Kafka, IBM MQ to targets like Redshift, Postgres, MongoDB
• Discovering appropriate workloads and use the appropriate database to deliver the performance and functionality needed
• Design and deploy for scale considering the types of requests the database must deliver on
• Database recovery with sequence and time constraint
• Collaborating directly with business and technology stakeholders to define future-state business capabilities & requirements and translating those into transitional and target state data architectures
• Partnering with platform architects to ensure implementations meet published platform principles, guidelines, and standards
• Analyzing the current technology environment to detect critical deficiencies and recommend solutions for improvement
• Designing, implementing, and maintaining data services, interfaces, and real-time data pipelines via the practical application of existing, new, and emerging technologies and data engineering techniques
• Developing continuous integration and continuous deployment for data pipelines that include automated unit & integration testing
• Workflow management platforms like Airflow
• Mentoring, motivating, and supporting the team to achieve organizational objectives and goals
• Advocating for agile practices to increase delivery throughput
• Creating, maintaining, and ensuring consistency with published development standards

Preferred Qualifications

Exceptional interpersonal skills, including teamwork, communication, and negotiation

Benefits

• Location : 100% Remote
• Shift Timing : 3:30 PM to 11:30 PM
• Salary : 30 LPA to 37 LPA ( FIXED )
• Looking for Immediate Joiners
• CloudHire’s mission is to create a positive and lasting impact in the world. By increasing competitiveness and efficiency in businesses, we believe that we are a catalyst for innovation across a multitude of specialties
• CloudHire works closely with its team to help you grow as much as we grow, and value your holistic development. Employees who are most successful at CloudHire take initiative, know how to identify problems and provide solutions, and always put the Team first
• With a belief that the journey to growth and greatness is ongoing, CloudHire gives employees the opportunity to continue learning and honing their skills with programs such as tuition reimbursement; mentorship programs; lunch and learns; online course subscriptions; paid industry certifications; business resource groups; and more