James OBrien
@jamesobrien
Results-oriented Data Engineer with expertise in data-driven solutions.
United StatesWhat I'm looking for
I am a results-oriented Data Engineer with over 9 years of experience in designing, developing, and optimizing data-driven solutions, particularly in logistics and real estate. My expertise lies in creating custom ETL/ELT pipelines, SQL performance tuning, and API integrations that transform raw data into actionable insights. I am known for my ability to partner with cross-functional teams to deliver robust data warehouses and analytics platforms on time and within scope.
In my current role at MV Realty, I developed a custom ETL pipeline to migrate database records to a data warehouse, significantly improving application and reporting performance through refactored queries and added indices. My previous experience as a Software Engineer Lead at Sonwil Distribution allowed me to mentor junior developers and manage the development and deployment of new projects, ensuring high-quality software solutions that meet business needs.
Experience
Work history, roles, and key accomplishments
Data Engineer
MV Realty
May 2022 - Present (3 years 1 month)
Developed a custom ETL pipeline to migrate database records to a data warehouse as they age out. Refactored complex queries and added important indices, which resulted in improved application and reporting performance. Designed and implemented new tables and scripts for data migration and manipulation.
Software Engineer Lead
Sonwil Distribution
Jun 2020 - May 2022 (1 year 11 months)
Scoped new software development projects and provided technical guidance. Mentored junior developers, fostering their professional growth. Managed the development and deployment of new projects to the production environment.
Software Developer
Sonwil Distribution
Nov 2016 - Jun 2020 (3 years 7 months)
Developed ASP.Net webpages to support internal warehousing operations. Designed and implemented SQL stored procedures, scripts, triggers, and tables. Created SSRS Reports and SSAS cubes for data analysis and reporting.
Pricing Analyst
Sonwil Distribution
Jun 2015 - Nov 2016 (1 year 5 months)
Developed pricing models for warehousing and value-added services. Reviewed P&L statements and forecasts to ensure profitability. Conducted time studies and production analysis.
Client Relations Representative
Sonwil Distribution
Sep 2012 - Jun 2015 (2 years 9 months)
Managed communications with internal staff and supply chain. Processed orders for picking, monitored, and scheduled receipts and shipments.
Production Analyst
Sonwil Distribution
Apr 2012 - Sep 2012 (5 months)
Calculated piece-rate wages for refurbishment operations. Developed ad-hoc reports and spreadsheets summarizing production activity.
Education
Degrees, certifications, and relevant coursework
SBSUNY College at Buffalo
Bachelor's Degree of Science, Computer Information Systems
2015 - 2019
Completed a Bachelor's degree program focused on Computer Information Systems. Gained knowledge in various aspects of IT.
ITT Technical Institute
Associate’s Degree, Multimedia
2009 - 2011
Obtained an Associate's degree with a focus on Multimedia. Developed skills in multimedia production.
Availability
Location
United StatesAuthorized to work in
Job categories
Interested in hiring James?
You can contact James and 90k+ other talented remote workers on Himalayas.
Message JamesFind your dream job
Sign up now and join over 85,000 remote workers who receive personalized job alerts, curated job matches, and more for free!
