| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
EMAIL AVAILABLE PHONE NUMBER AVAILABLELINKEDIN LINK AVAILABLESummaryMy mission is to develop and lead data engineering and data warehousing teams, to make them faster and better, and to empower data-driven decision making, automation, and innovation. If your central data teams are grinding down, overloaded, and you're not sure what to do, let's talk! 15 years of experience architecting and implementing data infrastructures across multiple clouds, domains, and industry sectors, incl. government, higher education, and blockchain/finance. Selected skills, accomplishments: Architected Foundry Digitals data infra: Kinesis-s3-Glue-Lambda-Athena, Snowflake, Atlan, Tableau Designed/Terraformed Foundry Digitals AWS s3-based medallion data lake Designed/Terraformed Metropolitan Council's Databricks workspaces (+UC) Built Carleton College data warehouse: modeling, Kimball, ETL, Analysis Services, Power BI Worked with many ETL/ELT tools: Jitterbit, SnapLogic, SSIS, Mulesoft, Azure ADF Broad skills with SQL/NoSQL DBs (Oracle, SQL Server, MySQL, Snowflake, Analysis Services) Ten+ years doing (de)normalization, modeling (PowerDesigner, SqlDBM); Kimball and Data Vault Coding, scripting (Python, C, C#, Bash, Perl), DevOps tooling (GitHub, GitLab, Jira, Vault, Artifactory) ExperienceData ArchitectMetropolitan Council of the Twin CitiesNov 2023 - Present (7 months)Evaluate major data platforms (focusing on Azure Synapse, Fabric; Databricks, Snowflake, and Dremio). Show data engineers and data scientists what's possible, coding Terraform for Synapse and Databricks workspaces and Databricks Unity Catalog, and building PoC data pipelines, medallion- architecture data lakes, and Spark notebooks. Evangelize storage-compute separation, modularization, domain data meshes, and the use of NoSQL in place of traditional relational databases, where appropriate.Data Engineering ArchitectFoundryJun 2022 - Oct 2023 (1 year 5 months)Design Foundrys overall data infrastructure and lead the implementation of that design. In fifteen months, we went from a basic data infrastructure (Python, GitHub, and MySQL) to a fully Terraformed s3-based data lake; Kinesis-Firehose-Lambda-Glue-Athena; Python and Go pipelines in GitLab with CI/CD, Vault, and Artifactory; Athena/Presto; Snowflake; an EDW design done in SqlDBM; Tableau Cloud setup; Atlan for cataloging, governance; and Mulesoft for API-led integrations. Candidate's Name - page 1Evaluate products systematically with the team; assist in standing up services as needed; train and mentor; and work through key decisions as a group. Test MLOps environments including SageMaker and Databricks.Data Warehouse ArchitectCarleton CollegeSep 2004 - Jun 2022 (17 years 10 months)Design enterprise data warehouse infrastructure - ETL/ELT, monitoring, data marts, OLAP cubes. Manage integrations with external vendor APIs (e.g., TeamDynamix, Salesforce, and Workday) and repositories (e.g., AWS S3, Azure ADLS). Build/test/deploy ETL/ELT (mostly SnapLogic, SSIS, Jitterbit; some ADF); load, clean data from various sources, including Oracle, SQL Server, MySQL and other databases. Manage analytics stack (Power BI).Integrate with SCADA/building automation systems, SNMP agents, card-access systems, and various operational data stores (particularly Ellucian Colleague ODS). Tie data marts to reporting tools. Integrate with ERP and other enterprise systems (Salesforce, Workday, Colleague). Manage databases (formerly Oracle, later SQL Server on prem; finally Azure cloud). Work with quants/ researchers to feed data into R, Python/pandas codebases. Create Power BI reports. Support Tableau users. Code scripts and functions in C#, Perl, Java, C, VB, Python, etc. as needed, and provide general systems support. Help integrate CS Gold, EMS scheduling, and other secondary systems. Perform logical, physical modeling of databases for applications as needed. Took on a temporary role in 2020 as PaperCut and general print administrator, after the retirement of a colleague. As of 2022, embroiled in a Workday project, constructing EIBs and migrating data from legacy system.PartnerGoerwitz Information Technology ConsultingApr 2001 - Jan 2020 (18 years 10 months)Side consulting business. In 2020 built and ran a Cardano-blockchain stake pool, as a proof of concept. Since 2002 provided strategic planning, advice, custom programming, and systems integration services for clients spanning both for-profit and nonprofit sectors (e.g., the Nature Conservancy; Countrywide Credit Industries, Inc.; Brown University).Interim Information Security OfficerCarleton CollegeJul 2017 - Jun 2018 (1 year)Filled InfoSec vacancy after departure of a colleague. Duties: Build out Splunk SIEM (major task). Document policy, practice (PII disclosure, collection; GPO usage; SPF components). Assist admins as needed with GPO management, SCCM endpoint protection rules, etc. Kill outmoded services. Manage DKIM/SPF/DMARC morass. Empower systems, helpdesk staff with unused account notices; unpatched machine reports; missing and misplaced asset detection/ reports; lateral movement, password spray, globetrotting-user alerts. Harden SQL Server installations, put monitoring in place. Collaborate on security-related projects, Duo two-factor implementation(metrics, training, cheering). Write institutional and departmental notices and missives re current threats Candidate's Name - page 2e.g., Spectre, Meltdown, Intel SA-00086. Evaluate NGAV products (performed full-blown Infocyte Hunt test).Nurture policy, conformance discussions (NIST 800-171, GDPR, etc.). Nudge internal process improvements, request changes to Palo Alto firewall rules; help establish better endpoint maintenance windows. Collaborate with peers in other institutions. Monitor alerts, SIEM logs; evaluate NCATS Nessus scans. Watch current threat landscape and change monitoring accordingly. Round up colleagues to test new security features and procedures before unleashing them on users, and take heat when things break. Currently working on integrating AWS, GCP, and Azure/O365 monitoring into Splunk. Learning tons about Google Cloud Platform. Web Technical AdministratorCarleton CollegeFeb 2002 - Aug 2004 (2 years 7 months)Manage web infrastructure, upgrades, database; handle most systems integration and identity management for Carleton College. Set up, administer LDAP/enterprise directory. Create IdM and provisioning system and interface it with other information repositories. Provide connectivity to Oracle, Informix, SQL Server, and integrate with various NOSs. Help integrate/construct front-end proxy for Datatel WebAdvisor. Work with Luminis portal. Provide general programming, database, systems administration, and systems integration support.EducationUniversity of ChicagoBA, LinguisticsUndergraduate degreeBryn Athyn College of the New ChurchAA, General liberal artsUniversity of ChicagoPhD, Near Eastern Languages and CivilizationsNatural language degree launched me into formal languages ('coding') University of ChicagoMA, Near Eastern Languages and CivilizationsPrecursor to PhDYale UniversityMA, Divinity School, BiblePrep for Chicago MA, doctorateLicenses & CertificationsCandidate's Name - page 3Hands On Essentials - Data Warehouse - SnowflakeSnapLogic Integrator Training - SnapLogicSnapLogic Certified Enterprise Automation Professional - SnapLogic Hands On Essentials - Data Lake - SnowflakeAtlan Product Essentials - Atlan6i-LOXmKtAAtlan Starter Program - AtlanSZ4FCyKn0QMicrosoft Certified: Azure Fundamentals - Microsoft 3F355F252C863BA3Data Cloud Deployment Framework - SnowflakeIssued Feb 2024 - Expires Dec 203494648164SkillsAzure Databricks Azure DevOps Services Bicep (Domain-Specific Language) Synapse Analytics Azure Fabric PySpark Business Intelligence (BI) Data Architecture Network Security Data LineageHonors & AwardsSnapLogic Certified Enterprise Automation Professional - SnapLogic Jan 2022https://www.credly.com/earner/earned/share/70f4515a-a983-4c78-b36b-dc8b078a79d3 Candidate's Name - page 4 |
