Description

WHO WE ARE

ZBeta is a world-class physical security design, consulting, and managed services firm that partners with some of the most dynamic, high-profile organizations and individuals in the world. We leverage a Data Driven, Technology Led, Human Centered approach in order to help our clients architect and engineer superior physical security solutions, implement them seamlessly, and operate them at peak efficiency. ZBeta prides itself on its level of technical expertise but remains independent and product-agnostic. Our highly experienced team brings decades of security expertise, diverse organizational perspectives, and proven best practices to every project and customer. It is our meticulous attention to detail, and our ability to deliver at scale that positions us to deliver an exceptional customer experience.

Our primary goal is to redefine the standards of professional security, equipping our clients with innovative tools to master today’s challenges and fortify against tomorrow's risks. By consistently delivering exceptional solutions and pioneering advancements in the security field, we can exceed expectations and set new standards of excellence in pursuing our vision.

Find out more about us here.

Who You Are

You are a forward-thinking strategic partner with a passion for enhancing security measures and fostering community resilience. You excel in fast-paced settings where your leadership abilities can catalyze meaningful transformation. You thrive in a workplace culture that is:

Innovative
Strives for Excellence
Reliable
Detail Oriented
Adaptable
Highly Organized
Client Obsessed
Curious
Resilient

Does this sound like you? If so, join us in our mission to redefine security standards and make a lasting difference in our community.

What You'll Do

As a Data Integration Specialist at ZBeta, you will be responsible for designing, developing, and maintaining data integration processes to ensure the seamless flow of data across different systems and platforms. You will collaborate with cross-functional teams to gather requirements, transform & load data, and support data-driven decision-making within the organization, providing critical support for ZBeta's operations. This role requires a passion for technology, a methodical mindset, analytical problem-solving skills, and meticulous attention to detail.

The ideal candidate should also be self-motivated, take initiative, and work independently, with the ability to overcome challenges by leveraging their resources and experience to drive projects to successful completion.

CORE COMPETENCIES

Growth Minded: Strong self-awareness of strengths and development areas with a curiosity and appetite for change and innovation
Data-Driven: Strong analytical skills with critical thinking driven by data
Collaborative: Ability to solicit and understand multiple perspectives
Evaluative: Ability to evaluate outputs rigorously to ensure consistent excellence in delivery
Accountable: Assumes responsibility for successfully accomplishing work objectives and delivering results; setting high standards of performance for self and others

Position Responsibilities

The essential duties and responsibilities include, but are not limited to the following:

Data Integration Design

Develop data integration strategies and solutions that align with organizational goals and objectives.
Design data pipelines, workflows, and ETL processes to move and transform data.

Data Source Evaluation

Assess data sources, both internal and external, to determine their quality, relevance, and compatibility with existing systems.
Identify data gaps and recommend data acquisition strategies.

ETL Development

Build, maintain, and optimize ETL processes using tools and technologies such as SQL, Python, Apache Spark, Talend, Informatica, or similar platforms.
Ensure data accuracy and consistency during the transformation and loading process.

Data Mapping and Transformation

Create data mapping documents that define how data should be transformed and integrated across different systems.
Apply data cleansing, enrichment, and validation techniques as needed.

Data Quality Management

Implement data quality checks and validation routines to monitor and improve data accuracy.
Identify and resolve data anomalies, duplicates, and inconsistencies.

Integration Testing

Develop and execute test plans to validate the functionality and performance of data integration processes.
Collaborate with cross-functional teams to ensure data accuracy and reliability.

Documentation

Maintain comprehensive documentation for data integration processes, including data flow diagrams, process workflows, and metadata descriptions.
Ensure documentation is up-to-date and accessible to relevant stakeholders.

Collaboration

Work closely with key stakeholders to understand data requirements and deliver integrated data solutions that meet their needs.

Project Management

Manage all aspects of the development and deployment of data integration solutions, including project planning, resource allocation, risk management, and ensuring timely delivery of high-quality results.
Collaborate with teams to ensure seamless implementation and operation of integrated systems.

Monitoring and Maintenance

Monitor data integration jobs and processes, proactively identifying and addressing issues and bottlenecks.
Perform routine maintenance and troubleshooting to ensure data pipelines run smoothly.

Technical Support

Provide technical support to end-users, including problem diagnosis, resolution, and comprehensive documentation.
Own troubleshooting efforts, utilizing problem-solving skills to address software issues.

Requirements

WHAT YOU'LL NEED

Experience: Minimum 4 years of relevant experience. Experience in integrating with external APIs and web services to fetch or push data.

Education: Bachelor’s degree in computer science, Information Systems, or a related field, or equivalent practical experience required. Relevant certifications in data integration tools or technologies, such as certifications from ETL tool vendors or cloud service providers preferred.

Knowledge

Knowledge of OAuth, RESTful APIs, and API authentication mechanisms.
Proven experience in data integration, ETI, development and data warehousing.
Strong understanding of data modeling concepts and database management systems (e.g., SQL Server, Oracle, MySQL).
Demonstrated knowledge of data governance, data quality, and data security best practices.

Skills

Highly proficient in PowerBI. Certification preferred.
Proficient with Microsoft SQL Server Express and Standard versions 2019 and 2022.
Proficient with Microsoft Azure SQL.
Experience integrating Power Automate with other Microsoft tools and platforms for seamless data exchange and automation.
Experience managing data integration projects, including project planning, resource allocation, and adherence to deadlines.
Experience with Workato for automating workflows and integrating applications preferred.
Microsoft Certifications are a plus.

Abilities

Exceptional attention to detail and highly organized, with the ability to prioritize and balance workloads.
Excellent written, verbal, and interpersonal skills, with an ability to organize and present information.
Strong customer service orientation, a team player with the ability to establish collaborative working relationships.
Self-directed problem solver who takes the initiative to start projects, work unsupervised, complete tasks independently, resolve roadblocks, and address issues before they become problems.
Dedication to ongoing learning and technological advancement, as well as staying up to date on industry trends.

What We Offer

Competitive salary based on job-related skills, experience, and qualifications
ZBeta is a remote-first company with a distributed team. This role is open to individuals based in the United States.
Our excellent benefits package includes 100% paid premiums on health, dental, vision, and life insurance, a 401k retirement plan, and significant work schedule and workplace flexibility.
Diverse and supportive culture

What's Important To Know

This remote role is open to individuals based in the United States
Must have a quiet, designated workspace and access to high-speed internet (minimum 200Mbps d/l, 10 Mbps u/l)
This position is not eligible for visa sponsorship
Candidates must be able to meet client and/or government security screening requirements for the role
This position requires verification of U.S. citizenship due to citizenship-based legal restrictions. As a condition of employment, the successful candidate will be required to provide proof of citizenship.
The successful completion of a background check is required upon hire and every two years thereafter

How To Apply

We look forward to connecting with individuals who are passionate about our mission and can bring diverse contributions to our team — not just those who check all the boxes.

We are committed to creating a supportive, encouraging environment where everyone can fully express their diverse perspectives, showcase their talents, and grow their knowledge, skills, and abilities.

If you're interested in joining our team, complete the application and submit your resume. We look forward to hearing from you!

ZBeta, Inc. jobs

Data Integration Specialist