SHAUNJAY J. BROWN

Data Engineer / Data Analyst (Contract)

Charter M — Remote Charter M partners with entrepreneurs, family offices, and investors, providing deal sourcing through operational support across Africa. chartermgroup.com

Impact & responsibilities

• Designed and operated a serverless ELT on AWS, centered on AWS Glue (Spark + Ray), to ingest portfolio, market, and operational data from SQL Server, Postgres, and MySQL into an S3-based data lake (Parquet + partitioning); implemented incremental loads (watermarks, CDC patterns), schema evolution, and job retries.
• Built reusable Glue job templates (args, bookmarks, and error logging) to standardize ingestion for new sources; published output to curated zones for downstream analytics.
• Implemented data quality gates (null/dup checks, type constraints, referential checks), and SLA monitors with CloudWatch metrics/alarms; routed failed batches to S3 quarantine.
• Orchestrated pipelines with EventBridge and Step Functions; used AWS Lambda for light transforms, manifest creation, and commit signals; added Snowflake stage loaders for modeled marts.

• Designed and maintained automated end-to-end data pipelines ensuring data integrity and quality.
• Led the design and maintenance of automated data pipelines.
• Oversaw strategic projects and provided key data-driven recommendations influencing business strategies.
• Worked with structured, semi-structured, and unstructured data formats.
• Developed and optimized SQL queries to analyze large datasets and extract insights.
• Collaborated with cross-functional teams, understanding unique data constraints and business needs.
• Supported the design and documentation of data models, mappings, and flow diagrams.
• Provided data-driven recommendations, influencing business strategy and decision-making.

• Managed SSIS Packages for ERP data transitions in alignment with managerial and business stipulations.
• Managed critical ERP data transitions and data architecture projects.
• Coordinated with various teams to ensure alignment with business needs and high-quality deliverables.
• Designed and constructed data architectures for bespoke and off-the-shelf applications.
• Supported the overall data architecture, from ingestion to visualization, aligning with business needs.
• Created and maintained architecture diagrams, data models, and other documentation.
• Oversaw configuration, support, and system admin tasks for both bespoke and off-the-shelf applications.
• Handled data load requisitions, manual data recovery, data conflict resolution, data extraction, and report generation.
• Constructed pivot tables and charts from worksheet data and external sources.
• Coordinated with consultants to ensure high-quality and timely deliverables.

• Uploaded and validated sensitive data into the Argus ERP system for insightful reporting.
• Managed the ETL process, including data ingestion, transformation, and validation.
• Worked closely with teams to define data needs, problem-solve, and support the broader agenda.
• Evaluated existing legacy data and designed data infrastructure improvements.
• Curated extensive datasets, applied statistical software, and devised data models for strategic quantitative evaluations.
• Translated report results into actionable insights.
• Formulated and executed standard operating procedures to bridge data gaps and troubleshoot related concerns.