Overview Your Future. Secured. ISC2 is a force for good. As the world’s leading nonprofit member organization for cybersecurity professionals, our core values — Integrity, Advocacy, Commitment, Diversity, Equity & Inclusion and Excellence — drive everything we do in support of our vision of a safe and secure cyber world. Our globally recognized, award-winning portfolio of certifications provide an independent and globally recognized endorsement of cybersecurity knowledge, skills and experience for all career levels. Our charitable arm, the Center for Cyber Safety and Education, enables ISC2 and our members to serve the public by educating the most vulnerable about cyber risks and empowering access to enter and thrive in the cyber profession. Learn more at ISC2 online and connect with us on Twitter, Facebook and LinkedIn. When you join ISC2, you’ll demonstrate your commitment to an inclusive and equitable environment. Your support of the unique perspectives and experiences shared by our global cybersecurity workforce and profession will be recognized. We invite you to take an active role in helping us create a true sense of belonging across our organization — an environment of authenticity, trust, empowerment and connectedness that empowers all of our successes. Learn more. Position Summary We are looking for a savvy Data Engineer to join our growing team of analytics experts. The hire will be responsible for expanding and optimizing our data and data pipeline architecture, as well as optimizing data flow and collection for cross functional teams. The ideal candidate is an experienced data pipeline builder and data wrangler who enjoys optimizing data systems and building them from the ground up. The Data Engineer will support our software developers, database architects, data analysts and data scientists on data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects. They must be self-directed and comfortable supporting the data needs of multiple teams, systems and products. The right candidate will be excited by the prospect of optimizing or even re-designing our company’s data architecture to support our next generation of products and data initiatives. Responsibilities + Design, develop, and maintain data pipelines and ETL processes using Azure Synapse Analytics, and other Azure services to integrate and process data from various sources like Salesforce, GCP etc. + Collaborate with cross-functional teams to gather requirements and design scalable data solutions that meet business needs. + Optimize data storage, retrieval, and processing in Azure Synapse to ensure optimal performance, efficiency, and cost-effectiveness. + Further transforming and refining large datasets using Azure Databricks, clusters , Python and Pyspark. + Develop, test, and deploy Azure Logic Apps and Azure Functions to automate data processing tasks and support data analysis and reporting. + Work closely with data scientists and analysts to enable advanced analytics and machine learning capabilities using Azure Synapse Analytics. + Ensure data security, data governance, and compliance with regulatory requirements. + Monitor, troubleshoot, and optimize the performance of Azure Synapse workloads. + Stay up-to-date with the latest developments in Azure Synapse, Azure Data Factory, and other Azure services to ensure that our data solutions remain current and efficient. + Creating and monitoring data sources in PowerBi. Build and run DAX queries. + Create custom data extracts and adhoc reports in Microsoft Power BI. Qualifications Skills/Competencies: + Ability to demonstrate and support the 5 Company Core Values: Integrity, Excellence, Unity, Accountability, Agility + Ability to build an inclusive culture that encourages, supports and celebrates diversity; serve as a role model to promote DEI best practices. + Strong analytic skills related to working with unstructured datasets. + Working knowledge of message queuing, stream processing, and highly scalable ‘big data’ data stores. + Strong project management and organizational skills. Education and Work Experience + Bachelor’s degree in computer science or other equivalent degree. + 7+ years of experience in a Data Engineer role. + Experience with Cloud Data warehouses such as Azure , AWS and Google BigQuery. + Experience with big data tools: Hadoop, Spark and Kafka. + Experience with Azure Dedicated and Azure Synapse. + Experience with Analytics one or more of the following reporting tools; Tableau, PowerBI, Looker, Domo and Microstrategy. + Experience with relational SQL and NoSQL databases, including Postgres and Cassandra. + Experience with data pipeline and workflow management tools: Azkaban, Luigi, Airflow, etc. + Experience with object-oriented/object function scripting languages: Python, Java, C++,etc. - Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases. + Experience building and optimizing ‘big data’ data pipelines, architectures and data sets. + Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement. + A successful history of manipulating, processing and extracting value from large disconnected datasets. Physical and Mental Demands + Up to 5% travel may be required. + Work normal business hours and extended hours when necessary. + Remain in a stationary position, often standing or sitting, for prolonged periods. + Regular use of office equipment in a remote environment such as a computer/laptop and monitor computer screens. + Dexterity of hands and fingers to operate a computer keyboard, mouse, and other computer components. Equal Employment Opportunity Statement All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic as protected by applicable law. Job candidates will not be obligated to disclose sealed or expunged records of conviction or arrest as part of the hiring process. Job LocationsUS-Remote Posted Date1 month ago(8/20/2024 4:32 PM) Job ID 2024-1868 # of Openings 1 Category Information Technology